Analysis Properties dialog: Data tab

Use this tab of the "Analysis Properties dialog" to specify how data is to be handled in an analysis.

Components

Include Null Values

Use this check box to include null values in your analysis when the entire row or column contains all nulls. When this check box is selected, null values will not be suppressed for the analysis. This turns off null suppression for all views and applies to the entire edge (that is, the row and columns axis) of the analysis. See "Understanding Null Suppression" for additional information.

Display of Columns Added in Criteria Tab

Displays options to specify how columns that are added to an analysis from the "Analysis editor: Criteria tab" after displaying the analysis results are handled:

• Display in existing and new views — Use this option to specify that the newly added columns are to be included in any existing views as well as in any new views that are added.

• Exclude from existing views, but display in new views — Select this option to specify that the newly added columns are to be excluded from any existing views (that is, placed in the Excluded drop target) but included in any new views that are added.

  For more information on the Excluded drop target, see "Columns in the Excluded Drop Target."

Hierarchy Display

Use the buttons within this area as follows, to control the placement of a member total for hierarchical columns in this analysis:

• Parent values before children — Use this option to place the member total before the children.

• Parent values after children — Use this option to place the member total after the children.

Placement of added members

Use the buttons within this area as follows, to control how members are added to hierarchical columns in this analysis using selection steps:

• Within the hierarchy: Does not display duplicate members within all hierarchies in the analysis. If the member is in the view, within the hierarchy, then this setting is ignored. Applies only to level-based hierarchies.

• Outside the hierarchy: Members are added at the bottom. Members, groups, and calculated items are added below the last members at the top level of the hierarchy, in the order in which they are added.

For more information on selection steps, see "Creating Selection Steps."