Working with Static Report Set

Overview

You can create a Static Report by defining each Report Set line item. Static Report Sets often have header lines, Excel lines, reference account lines, and row title lines.

Top Menu Options

The following are the top menu options you can use to create or edit a static report set:

• Reload - Click the Refresh icon to reload the report.

• Save - Click the Save icon to save the report.

• Save As - Click the Save As icon to make a duplicate report and change its name.

• Add Rows - Enter the number of rows in the field that you want to add and click the Add Rows icon to add rows to the grid.

• Remove Rows - Enter the number of rows in the field that you want to delete and click the Remove Rows icon.

• Move Row Up - Click the Move Row Up icon to move the selected rows within the grid.

• Move Row Down - Click the Move Row Down icon to move the selected rows within the grid.

• Copy - Click the Copy icon to copy existing rows.

• Paste - Click the Paste icon to paste the selected rows.

• Format Painter - Click the Format Painter icon to copy the format of a selected cell and paste the format to other cells. The text and data format is copied from the source to the target cell.

  Note:

  The Format Painter icon is disabled when you select multiple source cells.

  You can copy the format and paste it to all cells, Report Set lines including row, column headers, merged lines, and Excel formulas. You can copy and paste the data format to the Report Set line only. The format is retained when you Save, Run, Refresh, Save As, Copy, and export a Report Set.

Format

Click the Format icon to open a pane where you can format the lines and data in the grid, and add conditions such as, equal to, not equal to, and so on.

More Options

Click the More icon to add lines and rules and perform the following grid actions:

Add Lines & Rules

• Single Dimension - Select this to add multiple lines and rules at once from a single dimension. You can select the required dimension member from the Add Lines & Rules window as displayed in the image below. Using a single dimension, you can bulk upload Report Set lines from a dimension in a Report Set.

Grid Actions

• Gridlines On/Off - Select this to show or hide gridlines.

• Freeze On/Off - Select this to turn freeze on or off.

• Show/Hide Row Header - Select this to show or hide the row header. This option is available only for the Modern Static Report Set.

• Show/Hide Column Header - Select this to show or hide the column header. This option is available only for the Modern Static Report Set.

• Show/Hide Formula Bar - Select this to show or hide the formula bar. This option is available only for the Modern Static Report Set.

• Show Excel only Formula / Show All Formulas - Select this to display only Excel formulas or all formulas. This option is available only for the Modern Static Report Set.

Output

• Print - Select this to print the Report Set.

• Print Setup - Select this to apply print settings based on your requirements.

• Export to Excel - Select this to export the Report Set to Excel.

Show/Hide/Re-arrange Columns

Select the Show/Hide/Re-arrange Columns icon to show, hide, and re-arrange the columns based on your requirements. You can drag and drop a column to reorder in the Show/Hide/Re-arrange Columns drop-down list. The column settings are retained when you access the Report Set next time and export a Report Set to Excel.

Enable Modern Features

Select this toggle button to convert the Classic Report Set to Modern, and all the new features will be displayed in the Report Set.

Grid Actions

You can perform the following actions:

Change Line Type

Select the required cell under the Line Type column in the grid and the following options available:

• Reference Account - Select this option to map the selected line to a dimension member.

• Header - It provides a visual space within a report.

• Row Title - This allows for the data commonly found in Column A of a report to be relocated to a different column.

• Excel - Allows you to enter Excel formulas for the line. You can enter the formulas in Column F of the report set.

• Variance - Work in conjunction with Column K of the report set to show Favorable/Unfavorable variances.

  

Copy

Select this to copy the selected cell.

Paste

Select this to paste the copied cell.

Insert Copied Rows

Select this to insert copied rows.

Add / Edit Rule

Clicking Add or Edit in the Rule column to open the Add Rule or Edit Rule window. Select the Single, Multiple, or Advanced tab based on your requirements. You can add single or multiple members from the selected dimension, as well as the actual rule itself.

The selected options in a Report Set are dynamically applied at Dynamic Report run time instead of adding members to Report Set lines one time at the setup. This ensures that any new members added to the hierarchy are pulled dynamically without making any changes to Report Set definitions. This applies to Main, Alternate, Attribute, and Attribute Hierarchies, Substitution (Standard and Derived) Variables when used within the Single-dimension rule in a Report Set.

Single Tab

Select this to add a single dimension to the Report Set. The following fields are available only on the Single tab:

• Suppress Indents

  Select this check box to remove indents from the output for the selected member(s), children, all children, the selected member(s) plus the children, the selected member(s) plus all children, leaves, the selected member(s) plus leaves, or the selected member(s) plus the parents.

• Options

  The drop-down list is enabled only when a single rollup member is selected in the rule. The following options are available in the drop-down list:

  • Selected - Members in the tree, as selected by the user. This is the default value.

  • Children - Immediate children of members, as selected by the user

  • Selected + Children - Selected members, and their immediate children

  • Selected + All Children - Selected members, and all levels of children under them

  • Leaves - Leaf members at all levels under the selected members

  • Selected + Leaves - Selected members, and their leaf members, at all levels.

  • Selected + Parents - Selected members, and their immediate parents.

  • The following options are available only for the Time dimension:  

    • Year

    • Quarter

    • Month

    • Trailing

    • Total - Trailing

      Note:

      The Options drop-down list is enabled only when you select a single dimension in the rule and a single roll-up member within the single-dimension rule.

Display Parents Last

Select this check box to display the parent member at the bottom of the hierarchy. This check box is available for the Selected + Children, Selected + All Children, Selected + Leaves, and Selected + Parents options. If the check box is selected, the parent member will be displayed at the bottom of the hierarchy.