Using the Reports Tab in Report Collection

Reports Tab

You can add reports to the report collection, select bursting criteria and dimensions, and apply member selections.

You can do the following in the Reports tab:

1. Add Reports - Click the Select Reports option in Add Reports. The Select Dynamic Report window appears.
2. In the Select Dynamic Report window, choose the desired report from the File Cabinet, and Click Add. Additionally, a single report can be used in multiple tabs in the Report Collection or across Report Collections. You can add only Dynamic Reports to a Report Collection. 
3. Selected Reports - You can view all the reports added in the respective report bursting tab here. Under Action, you can:
   • Delete a report.
   • Move the report up by one place.
   • Move the report down by one place.
4. If you want to create a new report bursting tab, click the drop-down near the tab to open a list box. The list box contains the following options:
   1. Add - Creates a new report bursting tab and you must provide all the details.
   2. Duplicate - Creates a copy of the current report bursting tab as a new report bursting tab.
   3. Delete - Removes the current report bursting tab.
      
      You can drag and drop the bursting tabs in a Report Collection to reorder them. The maximum number of tabs that can be added to a single Report Collection is ten. Contact Support to increase this number. 
5. In the Bursting Criteria section, enter a name to identify the bursting criteria in the Name field.
6.  Select any of the following bursting methods from the Method drop-down:
   Bursting Methods:
   • Single Dimension Multiple Members - When you use this method, each selected report in the Report Collection is run individually for each selected bursting member. You can use a single bursting method multiple times in a single Report Collection. You can select one dimension as the bursting dimension and then select multiple members related to the selected dimension subject to the dimension security.

     In the example below Income Statement, Balance Sheet, and Expense Report are run for the Head Office, Redwood City, and New York locations individually.
     One output file is generated for each location and one sheet/page in Excel/PDF is generated for each report selected. Within the output file, the member selected first in the bursting selection is listed and the reports are added for this member in the same order in which they were selected in the Reports section. Report outputs generated are:

     • Head Office: Income Statement, Balance Sheet, Expense Report
     • Redwood City: Income Statement, Balance Sheet, Expense Report
     • New York: Income Statement, Balance Sheet, Expense Report.
   • Multiple Dimensions Single Member – When you use this method, you can select multiple dimensions and one member for each dimension for bursting. Each report selected in the Report Collection is run for a combination of the member selections made on each dimension.
     For example, let's consider the following selection is made for reports, bursting dimensions, and members:
     • Reports Selected: Income Statement, Balance Sheet, Expense Report
     • Bursting Dimensions: Company, Location
     • Member Selections: Company – HA RWC, Location-Head Office
       In the example above, the Income Statement, Balance Sheet, and Expense Report are run for HA RWC-Head Office locations. Report outputs generated are:
     • Income Statement for HA RWC-Head Office
     • Balance Sheet for HA RWC-Head Office
     • Expense Report for HA RWC-Head Office
       A single output file is generated for HA RWC-Head Office and one sheet/page in Excel/PDF is generated for each report selected.
   • Multiple Dimensions, Multiple Members - If this option is selected, you can select multiple dimensions and multiple members for each dimension. A single Excel or PDF file is generated for each bursting tab where the Multiple Dimension, Multiple Members bursting method is selected. If Generate Single Output File is selected in Settings, one Excel or pdf file is generated across all bursting tabs in the Report Collection.
     If you have added multiple reports in the bursting tab, selected multiple dimensions (for example 3 dimensions), and added multiple members for each dimension; the number of reports generated in the Excel or PDF file is equal to the number of reports selected times the number of members in dimension 1, dimension 2, and dimension 3 (and so on)
   • None - If this option is selected, there are no bursting dimension or member selections. The result is a simple Report Collection or book. Each report is run independently based on its own member selections. A single output file is generated for the tab and one sheet/page in Excel/PDF is generated for each report selected.
     Note

     The order of the selected members for each bursting dimension is retained in the Report Collection output.

     
     
7. Generate Single Output File for Selected Members - This checkbox appears when you select the Single Dimension, Multiple Members option in the Method field. Selecting this checkbox generates a single output file (Excel or PDF) for all members in the Bursting tab. The Report Collection output generated varies depending on how you set this checkbox and the Generate Single Output File option in the Settings tab. The following table describes different outputs generated based on your selection criteria for these checkboxes:
   

   Options	Generate Single Output File for Selected MembersGenerate Single Output File for Selected Members	Generate Single Output File	Output Generated
   Selection Criteria	Yes	Yes	Generates a single output file (Excel or PDF) for all members in the Bursting tab.
   Selection Criteria	Yes	No	One Excel or PDF file is generated for all members in the bursting tab where the checkbox is selected.
   Selection Criteria	No	No	One Excel or PDF file is generated for each bursting member on the bursting tab.
   Selection Criteria	No	Yes	One consolidated file is generated for all bursting tabs in the Report Collection.

   Note

   When you perform a Copy or Save As the Generate Single Output File for Selected Members checkbox setting is copied or saved. This setting is also retained for Report Collection integration with Cloud Scheduler.
8. Dimensions - Select the required bursting dimension from the drop-down. The drop-down displays the list of dimensions based on the report(s) you have selected in the Add Report field. You can add single or multiple dimensions and members to the Report Collection based on the option chosen in the Method field. When you select multi-dimension options in the Method field, you can view an additional Add icon next to the Dimension field using which you can add multiple dimensions. To add multiple dimensions, click the Add icon and click the dimensions drop-down again to choose the next bursting dimension.
9.  Members - Once you select a dimension, the Members section appears. This section displays the selected dimensions as blocks where you can add members related to that dimension. Click on the Select <Dimension Name> to view the Select Members window. You can view the associated dimension members based on your dimension security. Based on the option you choose in the Method field, you can select single or multiple members for each dimension. The following options are available in the Selected list box:
   • Selected (default) - Members in the tree, as selected by the user
   • Children - Immediate children of members, as selected by the user
   • All Children - All levels of children under the selected member
   • 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
     
     A Display Parents Last checkbox is available for the Selected + Children, Selected + All Children, Selected + Leaves, and Selected + Parents options.
     The following options are available for the Time dimension:
   • Year
   • Quarter
   • Month
   • Trailing
     Note:

     The Period dimension in Sales does not support the additional Time dimension options.
10. Click Update to exit the Select Members window.
    Note:

    You can modify the Member selections on page dimensions for each report added to the Report Collection. These selections are saved to the Report Collection and do not affect the selections made on the source Dynamic Report. By default, the member selections made within the Dynamic Report setup page are displayed for each dimension. Member selection on non-bursting page dimensions can be modified in this section for the Report Collection. All member selections are subject to Dimension Security. If the page dimension is locked in Dynamic Reports, it will be displayed with a lock symbol in the Report Collection. All associated dimension members cannot be edited when the dimension is locked.