Screen 2 of 3

Item

Description

Available Title Dimensions list

Lists the available title dimensions that you can use in the report.

For each dimension, this list displays the subset name (if applicable), number of elements in the dimension or subset, and cell address of the title dimension in the worksheet.

Selected Title Dimensions list

Lists the title dimensions to include in the report.

The order of this list is used when TM1® generates the report.

Add

Add to List button

Click this button to move selected dimensions from the Available Title Dimensions list to the Selected Title Dimensions list.

Add All

Add All to List button

Click this button to move all dimensions from the Available Title Dimensions list to the Selected Title Dimensions list.

Remove

Remove from List button

Click this button to move selected dimensions from the Selected Title Dimensions list to the Available Title Dimensions list.

Remove All

Remove All from List button

Click this button to move all dimensions from the Selected Title Dimensions list to the Available Title Dimensions list.

Move Up

Move Up button

Click this button to move the selected dimension up in the Selected Title Dimensions list. The order in this list is used when TM1 generates the report.

Move Down

Move Down button

Click this button to move the selected dimension down in the Selected Title Dimensions list. The order in this list is used when TM1 generates the report.

Subset Editor

Subset Editor button

Click this button to open the Subset Editor if you want to select a subset of elements from the currently selected dimension in the Selected Title Dimensions list.

Print Single Workbook

Select this option to create a report arranged into one complete group of worksheets.

Each sheet in the report is printed only once, including sheets that do not contain TM1 slice data.

Print Multiple Workbooks

Select this option to create a report arranged into multiple groups based on dimension elements.

This option creates a report with a larger number of sheets because a copy of each sheet is printed for each title element.

Total Excel Workbooks that will be generated

Displays the total number of Excel sheets that TM1 will generate for the current report.