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, 2012, Cooking Gear) shows the revenue value for the year 2012 and for the product line Cooking Gear.

Use tuples to avoid report summaries that do not reflect the visible data. For more information about this issue, see Summaries in a report do not correspond to the visible members.

Procedure

From the Toolbox tab , drag the Intersection (Tuple) object to the report.
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 .
To define the hierarchy for this intersection, click a parent object in the Intersection hierarchy box.