Selecting Fields

After selecting a database, the next step is to add query members and set up the member clause. You do this on the Query Builder - Fields page.

Dimensions and Members displays the selected dimension and all its members. You can use these items to add members or to set up the member clause.

To add a member:

Drag a member from Dimensions and Members to Query Members.
Select a member and click .

You cannot add measure dimensions to query members; however, you can add members of measure dimensions to query members.

If a query member is a non-measure dimension, you can edit its level and generation. To do this, click on the Level and Generation columns in the Query Members pane. If the query member is a member of a measure dimension; however, you cannot edit the level and generation information.

Note:

The level and generation information entered in the Query Builder is used to form the Production Reporting commands SET-MEMBER, SET-LEVELS, and SET-GENEREATIONS. For information on these commands, see Chapter 2, “Production Reporting Command Reference” in Volume 2 of the Hyperion SQR Production Reporting Developer's Guide.

To set up the member clause:

Drag a member from Dimensions and Members to Member Clause.
Select a member and click .

Setting up a member clause adds filters to the generated report. The members selected as part of a member clause should belong to a non-measure dimension.

Tip:

You can generate reports from multiple cubes. To do this, you must create a query for each cube. To create a query from the Layout window, click Insert Fields button or select Insert, then Field. In the Report Fields dialog box that appears, click New and choose Master Query.