PowerExcel Slice

Creates a Slice from a PowerExcel database (providing Connection exists).

Opens a saved Slice, providing options about the Slice Type and where to insert the data.

Saves a PowerExcel Slice, which can be viewed by another user with a connection to the same model.

Shows the PowerExcel Sidebar (pane) if you have unchecked the Option (see Option [PowerExcel Slice] below) to automatically display the PowerExcel sidebar.

[Licensed Feature]

Opens the Spreading Options dialog where you can opt to enable the Spreading feature.

[PowerExcel Slice] Brings up a dialog concerning Workbooks (Create a new Workbook, Create a new Sheet in current Workbook) and to enable Defaults (Constrain Rows, Delete Removed Rows, Dynamic Row Labels). Also includes Formatting options and a checkbox to automatically Show/Hide PowerExcel sidebar.

Finds PowerExcel function in an open Slice governing the Slice [for current version: Perspective Slice].

Calculation

Triggers the calculation to take place.

Allows the worksheet to automatically calculate every time changes occur.

Shows the Formula of a particular cell.

PowerExcel Data

Refreshes the Slice data after making Member selections.

[Licensed Feature]

Saves a Slice as a View in a selected database (e.g., SQL Server) that is reachable by third-party products (Tableau, etc.). See Section on DRDC – Dynamic Relational Database Connectivity (Licensed Feature)

[Licensed Feature]

Accesses the multidimensional data or individual relational transactions that comprise a cell in a PowerExcel spreadsheet.

PowerExcel Connection

Create a New connection (or Delete an existing one), or select an existing connection to an underlying database, and shows Name, URL, and Database.

[PowerExcel Connection] Brings up a dialog concerning Caching Options, including Cache Expiration (Hours) and Disable All Caching.

Clears Cache in the open Slice.

My Analysis

[Licensed Feature]

Allows you to set up the connection for My Analysis to be used between the Master Database and the My Analysis database.

[Licensed Feature]

Starts making "My Analysis" changes. When My Analysis is enabled and changes have been made, this button changes to the Commit button.

[Licensed Feature]

Allows you to commit or roll back the changes that have made to the master database.

[Licensed Feature]

Allows the user to view pending changes that have been made before committing them to the master database.

[Licensed Feature]

Updates the My Analysis database with the latest values that are in the master database to ensure that the Master Database and the My analysis database correspond.

Cube

[Licensed Feature]

Allows an end-user with permissions to update Cube(s) in the relational source.

Allows you to execute an existing Olation Cube Task.

Locks the Cube to avoid overwriting.

[Licensed Feature]

Accesses the capability to create Cubes in Olation® from selected tabular data in an Excel spreadsheet.

Dimension

Opens the Dimension Editor, which allows you to:

  - create new members or rename existing members,

  - modify the hierarchy structure or create a new hierarchy,

  - edit hierarchy weights, and

  - sort and filter the member list.

Help

While PowerExcel detects the operating system’s default language, a user can make another available language selection.

Enables the user to change Password on the selected database.

Brings up the Register PowerExcel window.

[Licensed Feature]

Checks for latest PowerExcel release.

.

Shows information as to the Version/build and License number of the PowerExcel User Client application.