Table Wizard

This wizard guides you through the process of creating a table report. It contains the following screens:

Back

Returns to the previous screen.

Next

Goes to the next screen.

Finish

Creates a report containing the table and closes the wizard.

Cancel

Closes the wizard without creating a report.

Help

Displays the help document about this feature.

Data screen

Specifies the business/report cube to use to create the table. This screen is hidden when there is only one cube in the current catalog. See the screen.

Available Data Resources

Lists all the available business/report cubes in the current catalog, with which you can create the table.

Display screen

Specifies the fields to be displayed in the table. See the screen.

Resources

Displays all the cube elements in the selected business/report cube.

Adds the selected cube element to be displayed in the table.

Removes the selected cube element.

Display Fields

Lists the cube elements that have been added to the table.

Display Name

Specifies the display names of the added cube elements.

Moves the selected cube element one step up.

Moves the selected cube element one step down.

Group screen

Specifies the fields to group the data. See the screen.

Resources

Displays all the available dimension objects you can use to group the data in the table.

Adds the selected dimension object as a group field.

Removes the selected dimension object.

Group By

Lists all the dimension objects that have been added as group fields.

Sort

Specifies the sort order for each group: Ascend, Descend, or No Sort.

Moves the selected group one step up.

Moves the selected group one step down.

Summary screen

Specifies the fields on which to create aggregation functions. See the screen.

Resources

Displays all the available measure objects you can use to create aggregation functions in the table.

Adds the selected measure object as the summary field.

Removes the selected measure object.

Summarized Fields

Lists the groups that have been created in the table and the measure objects you have added to summarize data in each group.

Display Name

Specifies the display names of the measure objects.

Row

Specifies to put the summary field in the header or footer row. If the summary is calculated on a group by field, it will be put in the group header or footer row of the corresponding group; if the summary is calculated on the whole dataset, it will be put in the table header or footer row. Available only when the table is Group Left type.

Column

Specifies to put the summary field in the specified detail column. Available only when the table is Group Left type.

Moves the selected measure object one step up.

Moves the selected measure object one step down.

Query Filter screen

Specifies the filter which you want to apply to the selected business/report cube. See the screen.

In this screen, all the predefined filters of the business/report cube are listed in the Query Filter drop-down list. You can choose one of them to apply. If you prefer to define a filter on your own, select User Defined from the drop-down list, and then define it according to your requirements.

For details about options in the screen, refer to Query Filter dialog.

Style screen

Specifies the style of the table. This screen is hidden when there is only one style available to be applied to the table. See the screen.

Style

Lists all table styles for you to select one from.

Inherit Style

Specifies to take the style of the parent component. The option is available only when you specify to insert the table into a banded object.

Preview

Shows a preview of the selected style.

Related topics: