Create a Set Expression

When working with dimensional data, set expressions are a set of dimension members that you create to reuse in queries in your reports. For example, you can create a named set called Top Ten Products that contains the ten members of the Product Name dimension that have the highest values for the Gross Profit measure. You can then use the Top Ten Products set in queries.

When you insert a Set Expression object, you must select a hierarchy and a set expression. The expression must return members from the specified hierarchy. Note that the Tuple function returns an intersection value and not a member, and is therefore not a set expression.

Steps

1. In the Insertable Objects pane, click the Toolbox tab .

2. Drag Set Expression to the report.

3. In the Name box, type a name for the calculation.

4. In the Hierarchy box, select the hierarchy within which you will create this calculated member or measure and click OK.

   The Data Item Expression dialog box appears.

5. In the Available Components box, define the calculation:

   • To add data items that are not shown in the report, on the Source tab , double-click the data items.

   • To add data items that are in the report but not necessarily in the model, such as calculations, on the Data Items tab , double-click the data items.

   • To add functions, summaries, and operators, on the Functions tab , double-click elements.

   Tip: You can also type the calculation directly in the Expression Definition box. When typing date values, use the YYYY-MM-DD format.

6. Click the validate expression button .