Toolbar (Calculations Tab, Cube Designer) (SSAS)
Use the Toolbar pane to perform common operations on the Calculations tab in Cube Designer.
Options
Option
Description
Add Business Intelligence
Click to display the Business Intelligence Wizard and add business intelligence features to the cube. For more information about the Business Intelligence Wizard, see Business Intelligence Wizard F1 Help (SSAS).
Process
Click to display the Process dialog box and process the cube. For more information about the Process dialog box, see Process Dialog Box (SSAS).
Reconnect
Click to reconnect the Calculations tab to the Analysis Services instance and database that contains the cube, if the session for the Calculations tab is disconnected due to connection loss or timeout.
New Calculated Member
Click to display the Calculated Member Form Editor and create a new calculated member. For more information about the Calculated Member Form Editor, see Calculated Member Form Editor (Calculations Tab, Cube Designer) (Analysis Services).
.gif "ms186920.note(en-US,SQL.90).gif")
Note:
This option is enabled only in form view.
New Named Set
Click to display the Named Set Form Editor and create a new named set. For more information about the Named Set Form Editor, see Named Set Form Editor (Calculations Tab, Cube Designer) (SSAS).
Note:
This option is enabled only in form view.
New Script Command
Click to display the Script Editor and create a new script command. For more information about the Script Editor, see Script Editor (Calculations Tab, Cube Designer) (SSAS).
Note:
This option is enabled only in form view.
Delete
Deletes the selected calculation in the Script Organizer pane in form view, or the selected script in script view.
Move Up
Moves the selected calculation in the Script Organizer pane up one place in form view.
Move Down
Moves the selected calculation in the Script Organizer pane down one place in form view.
Form View
Select to use the Calculations tab in form view.
Script View
Select to use the Calculations tab in script view.
Check Syntax
Click to check the syntax in the cube script.
Font
Click to display the Font dialog box and insert a valid set of font-related cell property values at the selection point in the cube script.
Note:
This option is enabled only in script view.
Color
Click to display the Color dialog box and insert a valid RGB (Red-Green-Blue) value at the selection point in the cube script.
Note:
This option is enabled only in script view.
Calculation Properties
Click to display the Calculation Properties dialog box and edit the calculation property values for calculations in the cube script. For more information about the Calculation Properties dialog box, see Calculation Properties Dialog Box (Analysis Services).
Change User
Click to display the Security Context dialog box and change the user and role used in the Calculations tab. For more information about the Security Context dialog box, see Security Context Dialog Box (SSAS).
Highlight changed cells
Note:
This option is unavailable.
All Item Totals
Note:
This option is unavailable.
Show Empty Cells
Note:
This option is unavailable.
Clear Results
Note:
This option is unavailable.
Commands and Options
Note:
This option is unavailable.
See Also
Reference
Cube Designer (SSAS)
Script Organizer (Calculations Tab, Cube Designer) (SSAS)
Calculation Tools (Calculations Tab, Cube Designer) (SSAS)
Calculated Member Form Editor (Calculations Tab, Cube Designer) (Analysis Services)
Named Set Form Editor (Calculations Tab, Cube Designer) (SSAS)
Script Editor (Calculations Tab, Cube Designer) (SSAS)
Calculations (Cube Designer) (Analysis Services)