Components of Reports

You can add several types of components when creating a report.

The following table lists the components that you can add to a report and how you can manipulate these components:

Component

Actions

Dimensions

Choose Edit Report to edit the report. The available dimensions appear.

Drag a dimension to the Row Axis area or the Column Axis area.

You can nest dimensions by placing additional dimensions in the column or row.

You can remove a dimension from a column or row by clicking the X beside that dimension.

Members

You can select the members you want to use in the report.

Select a dimension in the Column Axis or Row Axis area and click Select Members to choose the members to use for that dimension. Use the member selector to define the set of members to display for the dimension.

You can select members by choosing the following options:

  • Single Member - You can choose one member of the current context.

  • Fixed List - You can choose more than one member.

  • Select Children - You can choose the children of the current context.

  • Select Children and Me - You can choose both the children and the parent member.

  • Select Descendants - You can choose descendants of the current context. Select the levels to be included using the Number of Levels Down and Do not include intermediate levels options.

  • Select Descendants and Me - You can choose both the descendants and the parent member. Select the levels to be included using the Number of Levels Down and Do not include intermediate levels options.

  • Select Base Members - You can choose the base members of the current context.

  • Select Base Members and me - You can choose both the base members and the parent member.

You can exclude members from the selected member list in the following ways:

  • Exclude a single member - If you exclude a base member, you exclude that member from the selected member list.

  • Exclude descendants and me - If you exclude a parent member, you exclude that parent member and all of its descendants.

If you do not specify any members, the current context is used.

Charts

You can export a chart from a report or input form. See Create Charts in a Worksheet.

Work Status

You can set the work status on data that you enter and save. See Work Status.

Comments

You can add comments to any selected cell. You can also enter a comment for a specific context, in which case the comment also appears in all other reports containing the same context.

You can view and report on comments including the commenting thread that shows the history of a comment. See Comments.

You can cut, copy, or paste data both from and to Microsoft Excel. You can also export a complete report to Excel.

You can determine the appearance of reports by setting the following formatting options:

  • The scaling factor

  • The number of decimals to display after the separator

  • The placement of totals