Calculate Planned versus Actual defined by

Measures

Use this value if you actually have measures defined as Planned and Actual in your data service. The measures might have names such as the below:

The controls displayed on this screen differ based on which value is selected in this control.

Planned vs. Actual Indicators

Use this value if you have members (not measures) that indicate planned and actual values.

This type of configuration is typically found in data services based on SAP BI systems.

The controls displayed on this screen differ based on which value is selected in this control.

Dimension

Lists all dimensions in the cube on which the query is based.

Select the dimension that contains the hierarchy to display in the Hierarchy field.

Hierarchy

Lists all hierarchies in the currently selected dimension.

Select the hierarchy that contains the level to display in the Level field.

Level

Lists all levels in the currently selected hierarchy.

Select the level that contains the members for which to evaluate planned vs. actual results.

These are the members that will appear on the rows in the result.

Planned versus Actual defined by = Measures only:

Plan measure

Lists all measures in the cube on which the query is based.

Select the planned measure.

Actual measure

Lists all measures in the cube on which the query is based.

Select the actual measure.

Planned versus Actual defined by = Planned vs. Actual Indicators only:

Measure for comparison

Lists all measures in the cube on which the query is based.

Select the measure for which you want to compare planned vs. actual values. For example, Profit.

Planned / Actual dimension

Lists all dimensions in the cube on which the query is based.

Select the dimension that contains the hierarchy to display in the Planned / Actual hierarchy field.

Planned / Actual hierarchy

Lists all hierarchies in the currently selected planned / actual dimension.

Select the hierarchy that contains the level to display in the Planned / Actual level field.

Planned / Actual level

Lists all levels in the currently selected planned / actual hierarchy.

Select the level that contains the members to display in the Planned indicator and Actual indicator fields.

Planned indicator

Lists all members in the currently selected planned / actual level.

Select the member that indicates the planned value.

Actual indicator

Lists all members in the currently selected planned / actual level.

Select the member that indicates the actual value.

Either Planned versus Actual Option:

Plan version

If checked, allows you to specify a plan version using the controls below.

This option is typically only valid for data services based on SAP BI systems.

Version dimension

Lists all dimensions in the cube on which the query is based.

Select the dimension that contains the hierarchy to display in the Version hierarchy field.

Version hierarchy

Lists all hierarchies in the currently selected version dimension.

Select the hierarchy that contains the level to display in the Version level field.

Version level

Lists all levels in the currently selected version hierarchy.

Select the level that contains the members to display in the Version field.

Version

Lists all members in the currently selected version level.

Select the member that indicates plan version. For example, this might be a numeric value such as "001" or "003."