The PowerOLAP Ribbon is located directly below the Title Bar. It provides quick access to commonly used PowerOLAP functions and tasks. It consists of Five tabs: Home, Model, Slice, Data and Tools.
The Ribbon interface displays different PowerOLAP commands in logical groupings by Tabs and per control group. The Ribbon commands will be grayed out if the corresponding feature is either not applicable to the current database or active window, or if the corresponding component tool is not supported by your license. By hovering your mouse pointer over the command buttons, you will be provided with descriptions of the corresponding command function. The Ribbon can be shown or hidden simply by clicking on the Hide/Show Ribbon button, located at the upper right-hand pane of the PowerOLAP interface.
Note that the four save buttons—Save Database and Save Database As (under File Command) and Save Slice and Save Slice As (under Slice tab)—have subtle functional differences for user convenience.
Home Tab |
||
Command |
Icon |
Description |
CLIPBOARD |
||
 |
Used to insert clipboard contents. |
|
 |
Cuts the selection and puts it on the clipboard. |
|
 |
Copies the selection and puts it on the clipboard. |
|
EDIT |
||
 |
Opens up the Options dialog which permits users to configure or set general options for the PowerOLAP application and contains the licensing info of the particular installation. |
|
 |
Enables renaming or changing the name of the active database. Take note that this will only change the logical name, the physical database name or File name will remain the same. |
|
 |
This feature allows users to put a password protection simultaneously to all PowerOLAP cubes within the active or currently opened PowerOLAP database. Tick the Protected checkbox, then specify the password in the appearing Cube Password dialog. |
|
WINDOW |
||
 |
Arranges windows/slices in such a way that they overlap each other. |
|
 |
Arranges windows/slices as non-overlapping tiles. |
|
 |
Arranges icons at the bottom of a window |
|
VIEW |
||
Check Box |
This option hides/shows the status bar. Tick the checkbox to show status bar. |
|
Check Box |
This option hides/shows the Page members. Tick the checkbox to show Page members. |
|
Check Box |
This option displays the slice using the original slice display format. |
|
PORTAL |
||
|
Automatically opens the Default Folder or directory that houses the PowerOLAP related files which have been defined in the PowerOLAP Portal |
|
HELP |
||
|
Automatically opens the PowerOLAP Online Help in a web browser. |
|
|
This button opens up the Genius Center screen. The Genius center gives you the latest updates about PARIS Technologies International, Inc. such as recent news, product updates and information, upcoming training sessions clients can sign up for etc. |
|
Model Tab |
||
Command |
Icon |
Description |
MODEL |
||
 |
Opens
up the Dimensions dialog. |
|
 |
Opens up the Cubes dialog. Enables users to create modify and delete
Cubes in a currently opened database. |
|
 |
Enables the user to easily access the formulas and instantly launch the Formula Editor of a specific Cube. |
|
 |
Use to check if a formula is valid or not. |
|
SECURITY |
||
 |
A secured database feature that allows for maintenance of users and user groups as well as their corresponding types of access. This feature will only become active when working on secured databases. |
|
 |
Enables users to create security for their PowerOLAP databases. |
|
 |
A secured database feature that allows users to change or reset their password. This feature will only become active when working on secured databases. |
|
Slice Tab |
||
Command |
Icon |
Description |
SLICE |
||
 |
Allows for creation of new slices out of existing cubes. |
|
 |
Enables users to view and access all slices that were created for each Cube. |
|
 |
Closes the active slice. |
|
 |
Saves modifications made to saved slices. |
|
 |
Saves a newly created slice or allows users to save a copy of the active slice with a different name. |
|
|
Opens up the Slices dialog. Enables users to create delete and rename
Saved Slices in a currently opened database. |
|
 |
This
feature allows you to generate a new view in SQL Server out of
your PowerOLAP slices. By clicking on the DRDC button, this will
bring up a dialog which will require you to provide the SQL Server
name, valid credentials and a view name. |
|
CLIPBOARD |
||
|
Used to insert clipboard contents. |
|
|
Cuts the selection and puts it on the clipboard. |
|
|
Copies the selection and puts it on the clipboard. |
|
EDIT |
||
 |
Clears the active selection in a slice. |
|
 |
Copies the contents of the topmost data points/cells of a selected range into the succeeding cells/rows that follows below. |
|
 |
Copies the contents of the left-most data points/cells of a selected range into the cells to the right. |
|
OPTIONS |
||
 |
Allows
users to create a graphical representation of their slice data. |
|
 |
A slice feature that allows users to limit the data that will be brought into the slice, by defining certain restrictions or limitations, to omit irrelevant or unnecessary data from a slice view. Users can define specific row or column constraints. |
|
 |
A feature that enables users to view the detail values that comprise a particular cell value. |
|
WORKSHEET |
||
 |
Creates an Excel worksheet out of a PowerOLAP slice. This drops down to five different slice to Excel worksheet outputs: (1)OLAPTable, (2)OLAPReadWrite, (3)OLAPPivot, (4)OLAPWriteTable and a (5)Values only Worksheet.
The first four options are the different Excel connection types that have dynamic connection with the PowerOLAP database and have different manners of data retrieval and updating.
The last option merely exports the values of slices into Excel and does not provide dynamic connection with PowerOLAP. |
|
 |
Recalculates or refreshes the values in a slice view.
Equivalent to F9. |
|
WINDOW |
||
|
Arranges windows/slices in such a way that they overlap each other. |
|
|
Arranges windows/slices as non-overlapping tiles. |
|
|
Arranges icons at the bottom of a window. |
|
Data Tab |
||
Command |
Icon |
Description |
IMPORT |
||
 |
Feature that allows users to import metadata (such as Dimensions, Cubes, Formulas, etc...) into the current database using a text file. |
|
 |
Feature that allows users to import fact data or data values into the current database. |
|
 |
Feature that allows users to import pre-defined database security into the current database. |
|
 |
Enables users to import all elements (Meta/factdata and all defined database securities) of another PowerOLAP database into the current/new database. |
|
EXPORT |
||
 |
Exports and generates an export file (text file) of the Meta Data of the current database. The exported metadata depends on what has been defined during the export metadata process. |
|
 |
Opens up the Export Cube Tasks dialog. Exports and generates an export file (text file) of the Fact Data of the current database. |
|
 |
Exports database security that has been defined for the current database and generates a .SEC file. |
|
 |
Exports all information/component of the current database (meta data, factdata and all database security) and generates corresponding export files for them. |
|
 |
Exports the active slice data to text file. Drops down to two export slice options: (1)PowerOLAP and (2)Text. |
|
DATA TRANSFER |
||
 |
A PowerOLAP cube task that enables users to transfer data from one cube to another. |
|
 |
A PowerOLAP cube task that enables users to "clear" or erase the data of a specific cube. |
|
 |
A PowerOLAP cube task that enables users to create local cube from a remote cube that is running on an IDS enabled PowerOLAP Server, pull fact data of a remote cube down to a local cube or push fact data of local cube up to a remote cube. |
|
PERSISTENT CALCULATIONS |
||
 |
A Persistent Calculations feature which repopulates the values of a particular cube per the persistent calculation formula. |
|
 |
A Persistent Calculations feature that tells PowerOLAP to store values generated by a persistent calculation permanently in the cube. |
|
OLAPEXCHANGE |
||
 |
An OLAP Exchange feature that enables creation of cube from the relational tables. |
|
 |
An OLAP Exchange feature that performs a 'Rebuild' of an OLAP Exchange cube, in other words it refreshes or updates the data of an OLAP Exchange cube with the most current fact data coming from the source relational tables. |
|
 |
An OLAP Exchange feature that enables users to modify the composition of a Dimension that was created through an OLAP Exchange process even after an OLAP Exchange cube was already built. |
|
 |
Displays a summary of the properties and data source information of an OLAP Exchange cube as well as it's corresponding dimensions. |
|
Tools Tab |
||
Command |
Icon |
Description |
SYNCHRONIZATION SERVER |
||
 |
A Synchronization Server feature that allows users to configure or create a new Synchronization Server connection. |
|
 |
A Synchronization Server feature that "synchronizes" or updates both local and remote database of the meta and fact data changes.
In other words, this will both push the changes made in a local database up to the main synchronization server database, and pull all updates from the main synchronization server down to the local database. This is specifically applicable when Sync Server is configured to synchronize "On Demand". |
|
 |
A Synchronization Server feature that removes any expired locks or login user records. |
|
MY ANALYSIS |
||
 |
A Synchronization Server feature that allows users to perform "Ad hoc analysis" or "What If Scenarios" without affecting the users activities or live data on the main synchronization server database or other databases connected to the same synchronization connection. |
|
 |
A Synchronization Server feature that "commits" or saves any modifications done when working on "My Analysis" mode. |
|
 |
A Synchronization Server feature that "cancels" or revokes any modifications done when working on "My Analysis mode.
In other words, this will revert a user's database back to its original form before performing any "My Analysis" activities. |
|
POWEROLAP SERVICES |
||
 |
A PowerOLAP Services feature that allows users to create new linked cubes to Microsoft Analysis cubes and other OLE DB for OLAP compliant cubes.
This enables users to use PowerOLAP as front-end for viewing data of the corresponding databases. |
|
 |
A Synchronization Services feature that updates a PowerOLAP linked cube with the meta and fact data changes that were applied to the "provider" cube. |
|
OLATION CUBE |
||
 |
A PowerOLAP feature that allows users to create new linked cubes to Olation cubes.
This enables users to use PowerOLAP as front-end for viewing data in Olation cubes. |
|
 |
A Synchronization Services feature that updates a PowerOLAP linked cube with the meta and fact data changes that were applied to the corresponding Olation cube. |
|
