Dynamic Report Sets

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.

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. 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.
2. 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.
3. You can update the Rule Definition for your reference if needed.
4. Click Save to add 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.