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 |
Enables text files to be imported into PowerOLAP database cubes. Select this option to open a text file to be imported using Excel. |
|
Process |
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 |
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. |