Computed items allow you to create a new column by building an expression to compute measures, or by applying functions to measures. Computed items are like normal data measures and can be included in reports or reused to compute other measures.
Computed items are displayed in virtual columns (as opposed to columns that are physically stored in the cube). They are automatically calculated during the query and supplement the information already stored in the database.
For example, you can modify the Amount Sold item by building an expression around it, multiplying by the Unit Price item, and renaming the resulting item Revenue.
To compute or modify a measure:
Specify the information requested in the following fields:
Name—Specify a new column name that reflects the computation result.
Definition—Build an expression by adding items from the pad or the Functions dialog box.
Use the keypad to select and insert arithmetic and logical operators.
If you are familiar with MDX (Multi Dimensional eXpressions), type your instruction directly in the Definition field.
Measure—Select the MDX equivalent from the list of available measures for the expression.
Functions—Apply a numeric function to a selected measure in the Definition field. Depending on the function you select, the Functions dialog box changes to accommodate the selected function. For more information about functions, see Using OLAPQuery Functions.
When the expression is complete, click OK.
The new measure name is added to the data layout.
For more information on computed items, see Computed Items.