proCube’s Excel Ribbon/Toolbar

proCube toolbar in Excel 2003

The proCube toolbar in Excel 2003 contains command icons that correspond to proCube functionality. This toolbar is shown in Excel 2003 add-in toolbar.

excel2003toolbar.png

Figure 1.    Excel 2003 add-in toolbar

Table 1. summarizes the toolbar commands.

Table 1.       Excel 2003 add-in toolbar

Toolbar Command

Name

Description

2003slicewizard.png

Slice Wizard

Opens the Slice Wizard. Here you can create reports directly within Excel through an easy-to-use Wizard, and connect data directly to a cube.

2003cubewizard.png

Cube Wizard

Launches the Cube Wizard, which enables you to select a cube for your Excel report.

2003memberwizard.png

Member Wizard

Opens the Member Wizard, which allows you to select and configure members for the Excel report.

2003calcmode.png

Calculation Settings

Automatic calculation mode automatically recalculates all open workbooks each time a change is made and whenever a new workbook is opened. Select this check box to activate automatic mode. If this check box is deselected, Manual calculation mode is active. Excel will only recalculate the ACTIVE worksheet when you press F9 or CTRL+ALT+F9, or when you save a workbook. For large worksheets with multiple selections, use Manual calculation mode.

2003drill.png

Drill Through

The Drill Through button allows you to see the source of an Aggregate data value as the proCube intersection of dimensions. If you are using Xchange, it will also allow you to see the relational source of data.

2003excollchild.png

Expand/Collapse Children

The Expand Children button enables you to drill down to the children of a parent hierarchical member from within an Excel report. Available for OLAPTable only.
The Collapse Children button enables you to drill down to the children of a parent hierarchical member from within an Excel report.

2003spread.png

Spread Across

The Spread Across Selected Cells button spreads values across multiple cells based on an entered amount or a value from a cell in the spreadsheet. Data is written back to the cube.

2003pcubelaunch.png

proCube launch

Launches proCube Management Studio (if installed on your workstation).

2003about.png

About

Opens a dialog listing proCube version information.

proCube ribbon and quick access toolbar in Excel 2007

In Excel 2007, the menu toolbar is replaced with the Ribbon, which is part of the Microsoft Office Fluent user interface. This ribbon (shown in proCube's Excel ribbon and quick access toolbar) helps you quickly find the commands that you need to complete a task. Commands are organized in logical groups, which are collected together under tabs. Each tab relates to a type of activity, such as working with slices. To reduce clutter, some tabs are shown only when needed.

excelribbon&quickaccesstoolbar.png

Figure 2.       proCube's Excel ribbon and quick access toolbar

Table 2. identifies the functionality accessed from each command tool.

Table 2.       proCube's Excel ribbon commands

Command Tools

Name

Description

2007slicewiz.png

Slice Wizard

Opens the Slice Wizard. Here you can create reports directly within Excel through an easy-to-use Wizard, and connect data directly to a cube.

2007cubewiz.png

Cube Wizard

Launches the Cube Wizard, which enables you to select a cube for your Excel report.

2007memwiz.png

Member Wizard

Opens the Member Wizard, which allows you to select and configure members for the Excel report.

2007drill.png

Drill Through

Allows you to see the source of an aggregate data value as the proCube intersection of dimensions. If you are using Xchange, it will also allow you to see the relational source of data.

2007expchild.png

Expand Children

Drill down to the children of a parent hierarchical member from within an Excel report. Available for OLAPTable only.

2007collchild.png

Collapse Children

Drill down to the children of a parent hierarchical member from within an Excel report.

2007spread.png

Spread Across

Apportions values across multiple cells based on an entered amount or a value from a cell in the spreadsheet. Data is written back to the cube.

2007launch.png

Launch proCube

Launches proCube Management Studio (assuming it is installed on your workstation).

2007about.png

About

Opens a dialog listing proCube version information.

2007excelcalc.png

Automatic Excel Calculation

Automatic calculation mode automatically recalculates all open workbooks each time a change is made and whenever a new workbook is opened. Select this check box to activate automatic mode. If this check box is deselected, Manual calculation mode is active. Excel will only recalculate the ACTIVE worksheet when you press F9 or CTRL+ALT+F9, or when you save a workbook. For large worksheets with multiple selections, use Manual calculation mode.

If you prefer your Excel commands to appear on a toolbar that you can click for immediate action, you can add and customize the Quick Access Toolbar. Adding commands to the Quick Access Toolbar (shown just below the ribbon in proCube's Excel ribbon and quick access toolbar) lets you easily access commonly used Excel functions.

Using the Excel right-click menu

You can also access specific proCube commands from a menu accessed by right clicking within the Excel grid. This menu is shown in proCube's Excel right-click menu. The functionality for these commands is the same as for their ribbon or toolbar counterparts.

rightclickmenuexcel.png

Figure 3.    proCube's Excel right-click menu

 

Have more questions? Submit a request

0 Comments

Please sign in to leave a comment.
Powered by Zendesk