Using Dimensional Calculations

Create a Simple Member Calculation
When working with dimensional data sources, you can select members in your report and create simple calculations.

Insert a Query Calculation
When working with dimensional data, insert a query calculation into your report to add a new row or column with values that are based on a calculation. For example, you create a query calculation named Euros that converts dollars to euros by multiplying an existing dollar measure by a conversion rate. Euros can then be displayed to end users in a separate row or column.

Create a Layout Calculation
Create a layout calculation to add run-time information to your report, such as current date, current time, and user name.

Create an Intersection (Tuple)
When working with dimensional data, an intersection, also known as a tuple, is useful for obtaining a value from the combination of two or more members that you specify. Each member must be from a different hierarchy. The intersection can include only one measure.

Assigning a Hierarchy or Dimension
You must assign each calculated member, set expression, and intersection (tuple) to a hierarchy or dimension. We recommend that you select the hierarchy or dimension upon which your calculation focuses. For example, if your calculated member is based on years, select the Time hierarchy. If you create a calculated measure, select the Measures dimension.