Use this screen to design the layout for your Freeform OLAP query results. The Freeform template is a special template that walks you through defining a query without the constraint of a particular business question. On this screen, you select from available measures (key figures), dimensions, and levels and place them into either rows or columns. You can also optionally specify sort conditions for dimensions or levels.
The main sections and controls of this screen are listed in the following table:
Section |
Control/Sub-section |
Description |
---|---|---|
Cube Data |
Lists the metadata for the cube you selected on the Select a Cube screen, in tree format. At the root of the tree is the cube, followed by dimensions (including the special measures and time dimensions), followed by available hierarchies, levels, and members. Select a measure, dimension, or level to place in either rows or columns. |
|
Selected Data -- Rows |
→ button |
Transfers the measure, dimension, or level selected in the Cube Data list to the rows. You can create multiple rows in the query definition, as long as the metadata for each row comes from a different dimension. |
← button |
Clears the selected data from the query definition. |
|
Clear button |
Removes all objects in the Selected Data -- Rows list from the query definition. |
|
Rows |
Lists all objects currently selected to appear on the rows. |
|
Selected Data -- Columns |
→ button |
Transfers the measure, dimension, or level selected in the Cube Data list to the columns. You can create multiple columns in the query definition, as long as the metadata for each column comes from a different dimension |
← button |
Clears the selected data from the query definition. |
|
Clear button |
Removes all objects in the Selected Data -- Columns list from the query definition. |
|
Columns |
Lists all objects currently selected to appear on the columns. |
|
Properties |
Caption |
Review the caption of the metadata selected in one of the Selected Data lists to help you determine sort conditions. |
Unique name |
Review the unique name of the metadata selected in one of the Selected Data lists to help you determine sort conditions. |
|
Type |
Review the type (dimension, level, or measure) of the metadata selected in one of the Selected Data lists to help you determine sort conditions. |
|
Sort by |
Select from the available metadata to specify sort conditions. Any dimension members in the query can be sorted either by one of its attributes (caption, name, or unique name) or by any measure. |
|
Sort order |
Select whether to sort in Ascending or Descending order on the metadata selected in Sort by, above. |