Common Tab (Custom Dimension Security Dialog Box)
Use this tab to specify options for visual totals and to define a default member.
The options for visual totals determine whether users see aggregated cube cell values that are calculated with values for:
- Only the members they can see (users see
visual totals ). - All members (users see actual totals).
One option produces visual totals at and above a specified level, and actual totals below it.
If you select a default member, and a query is issued on a cube that includes the dimension, but the query does not project the dimension on an axis, by default the returned dataset is filtered (that is, sliced) by the default member. If you do not select a default member, the default member is determined by the Default Member property of the dimension, which is accessed in the properties pane of Dimension Editor (if the dimension is shared) or Cube Editor (if the dimension is private).
Options
Enable - Show visual totals
Displayed, aggregated cell values are calculated according to only the viewable members.
Note Visual totals cannot be enabled for a cube that contains a distinct count measure. For more information, see Using Aggregate Functions.
Custom - Show visual totals starting at the following level and above
To produce visual totals at and above a certain level, but to produce actual totals below it, select this option and, in the box below it, type an expression for the level in Multidimensional Expressions (MDX). Or, instead of typing, beside the box you can click the build (...) button to access MDX Builder, where you can select the level in the Data box and drag it to the MDX expression box. The MDX expression must name a level or resolve to a level.
For example, in the Geography dimension, to display visual totals at and above the Continent level, type:
[Geography].[Continent]
Important This option creates one or more security exposures below the specified level when it allows end users to calculate values for a denied member by combining values for allowed members. For example, in the Geography dimension, if France has two children, Northern France and Southern France, and only Northern France is denied, users in the role can calculate values for Northern France by subtracting values for Southern France from values for France.
Disable - Do not show visual totals
Displayed, aggregated cell values are calculated according to all members, whether they are viewable or not. This option is the default for visual totals.
Important This option creates one or more security exposures when it allows end users to calculate values for a denied member by combining values for allowed members. For example, in the Geography dimension if France has two children, Northern France and Southern France, and only Northern France is denied, users in the role can calculate values for Northern France by subtracting values for Southern France from values for France.
Define default member and specify using MDX
To select a default member, select this check box and in the box below it type an MDX expression for the default member. Or, instead of typing, beside the box you can click the edit button (...) to access MDX Builder, where you can select the default member in the Data box and drag it to the MDX expression box.
For example, in the Geography dimension to select the France member, type:
[Geography].[All Geography].[Europe].[France]