PowerOLAP's Add-In Menu Commands


PowerOLAP's installation automatically creates the necessary Add-in components within Excel: a custom PowerOLAP menu and the corresponding commands are added to Excel. Upon starting Excel, the PowerOLAP Excel Plug-in splash appears and by going through the newly added PowerOLAP Add-in Tab within the Excel ribbon, the PowerOLAP menu commands are presented.

 

The following figure detail PowerOLAP's Add-In Menu commands accessible through the PowerOLAP Add-in Tab as shown below, which provides access to PowerOLAP features from within the Excel environment.

 

 

 

The table below lists the functions provided by the PowerOLAP Add-In Menu along with a brief description of each function.

The PowerOLAP Add-in Tab, shown above, is located within the Excel ribbon and is comprised of  buttons that provide point-and-click access to PowerOLAP's add-in functions. The table below identifies the function accessed by each button.

 

Dimension Hierarchy Toolbar

Command

Icon

Description

Launch Modeler

Opens a connection to the PowerOLAP Application, instead of having to open PowerOLAP from the Start Menu.

Save Database

Saves any changes you have made in the Excel worksheet back to the dynamically connected PowerOLAP database.

Cut

Cuts the selection and puts it on the clipboard.

Copy

Copies the selection and puts it on the clipboard.

OLAP Paste

This function pastes or saves the numbers entered into an OLAPTable in Excel back to the PowerOLAP database.

Select Cube

Enables the selection of Cubes Names based on the currently active PowerOLAP database.

Select Dimension

Enables the selection of Dimension names based on the currently active PowerOLAP database.

Select Members

Enables the selection of Member names based on the currently active PowerOLAP database.

New Slice

Enables you to create reports directly from Excel through the use of OLAPNavigate function.

Formula

Opens the Edit Formula dialog box for creating and modifying PowerOLAP database references.

Outline

This feature leverages the hierarchical definitions within PowerOLAP and deploy that out to Excel. When used, this automatically formats the Excel report and applies the hierarchical structure based on how it was defined from within PowerOLAP.

Clear Outline

Clears the Outline applied to an Excel report.

Print Report Set

Enables users to users to quickly select various combinations of report, by specifying which dimensions to be used, then use the standard Excel print functionality to print those reports in a digital PDF format or a physical printer.

Execute Jobs

Opens the Add Job dialog box that will allow you to access all existing PowerOLAP Scheduler jobs and execute them directly from the Excel environment.

Execute Tasks

Opens the Add Task dialog box that will allow you to access PowerOLAP cube tasks and execute them directly from the Excel environment.

Drill Through

Shows the source of the data value highlighted in Excel.

PowerOLAP Portal Files

When clicked, this gives users easy access to a default repository which can be a shared network drive, a network location, an FTP site or a web page. This directory is configured from within PowerOLAP and ideally should contain the most updated PowerOLAP related files.

Select
Import File

Enables text files to be imported into PowerOLAP database cubes.

Select this option to open a text file to be imported using Excel.

Process
Next Line

This feature triggers Excel to push data from an import text file to a particular data point in a PowerOLAP cube. By selecting this option, this will push the import data to the corresponding intersection in a PowerOLAP cube per line.

Process
Entire File

This feature triggers Excel to push ALL data from an import text file to their corresponding data point in a PowerOLAP cube.

Options

This brings up a dialog that consists of settings that can be configured for a Slice to Excel report.

PowerOLAP Auto Calc

Checking this feature ensures that all subsequent spreadsheets that contain a connection to a spreadsheet with an initial PowerExcel Function will be calculated.

PowerOLAP Help

Launches the PowerOLAP CHM Help File.