Show TOC

Object documentationDesign a Layout Locate this document in the navigation structure

 

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.

Structure

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.