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.

For example, the intersection (Revenue, 2004, Cooking Gear) shows the revenue value for the year 2004 and for the product line Cooking Gear.

Procedure

  1. From the Toolbox tab toolbox tab, drag the Intersection (Tuple) object to the report.
  2. From the Available members and measures pane, select items and click the right arrow to move them to the Intersection members and measures box. You can also use items from the Calculated Members and Measures tab calculated members and measures tab.
  3. To define the hierarchy for this intersection, click a parent object in the Intersection hierarchy box.
Parent topic: Using Dimensional Calculations