Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

The Reporting Currencies of archived versions cannot be recalculated.

Subsets

Two types of subsets can be defined for the FIN Currency dimension, Static subsets, and Dynamic subsets.

Static Subsets

Static subsets are a list of elements that do not change unless the static subset is redefined.

To define a Static Subset, click on Subsets > Static from the toolbar.

...

To create a new static subset, click on the + button. To change an existing static subset, select the static subset that is to be changed in the left-hand widget. To add an element to the subset, select the element in the middle widget and click on > to add. To remove an element from the subset, right click on the element and select Remove. The order of the elements can be changed by dragging the element up or down the list. To save the changes to the FIN Currency dimension click on Save or Save and Close button.

Dynamic Subset

Dynamic subsets are subsets that change as the dimension changes. Dynamic subsets are defined using an MDX statement for the subset.

To define a Dynamic Subset, click on Subsets > Dynamic from the toolbar.

...

To create a new dynamic subset, click on the + button. To change an existing dynamic subset, select the dynamic subset that is to be changed in the left-hand widget. The middle widget defines the dynamic subset. Enter the MDX statement in the Subset Expression field. Or select from the list of common dynamic subset definitions found in the drop-down menu in the Automated MDX Type field. Selecting an Automated MDX Type may show other options to be configured. Choose to keep the subset dynamic or make it a semi-dynamic using the Keep Subset Dynamic option. Choosing to keep the subset semi-dynamic means that the MDX statement is revaluated each time the dynamic subsets are rebuilt for the dimension. Choosing to keep the subset dynamic means the MDX statement is revaluated each time the subset is used. The right-hand widget shows the elements that make up the dynamic subset. Click on Save or Save and Close to rebuild the dynamic subsets that have been defined for the FIN Currency dimension.