Using variables in the Data Area

In addition to elements, you can use variables to define the Data Area.

Variables can contain these elements:

  • A single element
  • A set of elements from a single hierarchy
  • Multiple elements from multiple hierarchies (a tuple)

When you define the Data Area, you can distinguish between the different types of variable. Click a hierarchy in the Hierarchy column and select one of these variable types:

  • Element
  • Set
  • Tuple

Click the button in the Selection column and select the variable from the Select Elements dialog.

Examples

Element selection Hierarchy Case Aggregation function

Element Selection Hierarchy Case Aggregation Function

Selected by name. For example yyyy Fixed hierarchy and selection Used with multiple selections

Reference to a combo box. For example, ReportObjects.lvTime.Text)

Selected by name For example, Time The selection refers to an element in a combo box Used with multiple selections

Variable containing a single element. For example, ReportObjects.Time.Text with value [Time].[2008]

Selected by name For example, Time The selection is stored in a variable Used with multiple selections

Variable containing a comma separated list of elements from different dimensions. Only one element is allowed from each dimension. For example, ReportObjects.Slicers.Text with value [Time].[2008].[Product].[All Products]

Selected by name For example, Time Multiple selections as slice-dimensions on database independent reports Multiple selections are not allowed

Variable containing a comma separated list of elements from a single dimension or an MDX function. For example, ReportObjects.Slicers.Text with value [Time].[2008].[Children]

Variable For example.=ReportVariables.VerticalDim.Text The selection in a variable contains multiple elements or MDX functions Always