Working with Dynamic Report Set

Overview

Dynamic Report Sets are created using Rules, which fetch members directly from the dimensional hierarchies. Dynamic Report Sets performance is directly linked with the dimension hierarchy setup. You can add a Dynamic Report Set from the File Cabinet page.

The Dynamic Report Set includes two tabs:

• Single - Allows you to create a Report Set with selected members.

• Advanced - You can select multiple dimension members and functions to create a Report Set. The advanced dynamic report set also contains some rule-builder tools that provide you flexibility while building the rule.

The following fields are available on the Dynamic Report Set toolbar:

• Reload - Click the Reload icon to refresh the page.

• Save - Click the Save icon to save the Report Set.

• Save As - Click the Save As icon to save the Report Set with a different name.

• Save as Static - Click the Save as Static button to save the Report Set as static.

• Preview - Click the Preview button to launch the Dynamic Report Set Preview page. Results are based on the Rule definition. All members selected on the Dynamic Report Set page are listed. Members are displayed with or without indents based on the status of Suppress Line Spacing.

How to Use a Single Tab Option in a Dynamic Report?

You can create a Report Set with selected members of one dimension with the Single tab. The dimension chosen while adding the Report Set is displayed at the top of the Single tab. The members displayed in the Select Members section are based on the chosen dimension.

You can do the following to create a Single Dynamic Report Set:

1. Select the required dimension members from the Select Members pane to create a rule.
2. The selected members appear in the Selected Members pane. The default order of the selected members is the order of your selection. You can use the up and down arrows adjacent to each member in the Selected Members pane to re-order the selected members. The rule definition changes based on the order of the selected members.
3. Select any of the following from the Options list after you select the members:

   • 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.

     Note:

     If you select the Suppress Level Spacing checkbox, the hierarchy members are displayed in the Preview with indents suppressed (i.e., not applied). By default the checkbox is unchecked (do not suppress).

How to Use a Advanced Tab Option in a Dynamic Report?

You can select multiple dimension members and functions to create a Report Set. The advanced dynamic report set also contains some rule-builder tools that provide flexibility while building the rule. 

You can do the following to create an Advanced Dynamic Report Set:

1. Click Reports. 
2. Click the + icon, to create a new dynamic report.
3. Under the Members section, select the necessary dimension from the drop-down list.
   Note

   Utilize the Functions section to set the formula using the pre-defined system functions.
4. Drag and drop the required dimension members into the right pane to create a rule.
   Note

   • You can select a member from one dimension, change the dimension, and select another member if needed.
   • If you are adding a comma, make sure to enclose the rule in parentheses.
5. You can update the Rule Definition for your reference if needed.
6. Click Save toadd the rule to the formula. You can use the following options in the Rule Builder tool while working on a rule:
   • Reset - Clear the currently added dimension members and revert to the previously saved state.
   • Copy - Copy the syntax.
   • Paste - Paste the copied syntax.
   • Check syntax - Click to validate if the syntax is correct or not.
   • Check Auto Syntax - Enable this option to auto-validate the syntax when you save the rule.
   • Clear - Removes the rule and rule definition.