Home > OLAP Dialog Boxes and Wizards > Generate Calculated Measures
![]() Previous |
![]() Next |
Calculated measures are stored equations, similar to a SQL view. No data is stored; the calculation is performed in response to a query. Thus, you can create a multitude of calculated measures without using any significant storage space.
OLAP provides templates of all of the basic analytic functions. The analytic functions provide the most powerful computations and fuel the most useful queries for business intelligence and similar applications. They include a variety of rank, share, time series, and other single-column functions. The analytic functions enable analysts and decision makers to make comparisons and identify trends.
Use this dialog box to generate the basic calculated measures for a cube using these subpages:
After creating the calculated measures, you can modify them and create additional custom calculated measures using the Code Editing Window for OLAP Calculated Measures.
Related Topics
"Creating Calculated Measures"
Use this subpage to select the measures and define the calculations.
Select Measures for the Calculations: Select one or more measures or predefined calculated measures that provides the data for the calculations.
Specify Calculation Details: Select the types of calculations to generate and modify the templates. See Table: OLAP Calculation Types.
Hierarchy: Select the Time hierarchy for the calculations.
You Have Specified n Calculated Measures: Displays the current number of calculations (n) based on your selections and lists them in a table. The names and descriptions are generated using the current naming rules. You can change them in Naming Rules.
Type: Type of calculation
Calculated Measure Name: Name of the calculated measure
Description: Description of the calculated measure
Short Description: Short description of the calculated measure
Long Description: Long description of the calculated measure
Expression: The calculation rendered in the OLAP expression syntax
Calculation Settings: Identifies the path to the current calculation template, or Default if no template is loaded.
Open: Displays the Open dialog box for selecting an XML file of previously defined calculations. To automatically load a particular template instead of the default, use the OLAP Preferences dialog box.
Save: Saves the selected measures and the currently defined calculations in an XML file.
Use Default: Restores the Calculations subpage to its original settings.
Generate Calculations: Creates all calculated measures listed in the table.
Use this subpage to modify the rules for naming the calculated measures. The table lists all calculated measures and the rules for creating the name and descriptions for each one.
Name: Identifies the values in the other columns. This column provides a navigation tree and a Calculation folder for each calculated measure.
Value: Specifies the naming rules for generating the name and descriptions for each calculated measure. Double-click the current value to edit it. You can use basic SQL functions and syntax to create new rules.
The default naming rules use this syntax:
{variable} || 'literal'
For example, {measure_name} || '_RANK'
creates the name of the Rank calculated measure as the concatenated string of the measure name and the literal string '_RANK', such as SALES_RANK or UNITS_RANK.
Preview: Displays the names and descriptions using the current naming rules.
Naming Rules Setting: Identifies whether the current rules are based on the default settings or a previously saved template.
Open: Opens an XML file of saved naming rules. These rules replace the current settings. To automatically load a particular template instead of the default, use the OLAP Preferences dialog box.
Save: Saves the current naming rules for all calculations to an XML file.
Use Default: Restores the Naming Rules subpage to its original settings.