Create a new Subset
Select Company from the sidebar.
Click on the Subsets button, a dropdown will appear with three options: Dynamic, Static, and Standard.
Static Subset:
...
Dynamic Subset:
Click on the + sign to create a new subset, input a name for it, and click the “check” button.
Click on the new subset. On the Configuration side, there are four fields:
KeepSubsetDynamic: after the subset creation by mdx it will become static
Automated MDX Type: Predefined mdx subsets
Automated MDX Base Element: dimension elements
SubsetExpression: Manually type an MDX subset(Only available if nothing is selected on Automated MDX Type)
See the results on the Content side
Click on the Save&Close button.
...
Standard - Decide if the standard subsets are to be updated or not.
...
Subsets can be managed most places where metadata is managed in Apliqo FPM. There are three classes of subsets that can be defined in Apliqo FPM: Standard Subsets, Static Subsets and Dynamic Subsets.
Standard Subsets are common subsets apply to most dimensions. The default settings for the Standard Subsets are appropriate to Apliqo FPM.
Static Subsets is a defined list elements that are members of the subset. The static subset will only change if the static subset definition is updated, or the element is removed from the dimension.
Dynamic Subsets are defined by using a query language called Multidimensional Expressions, or MDX for short. Each time the dimension is updated the dynamic subsets are re-evaluated according to their MDX expression. This means the members of the dynamic subsets change as the dimension changes. Knowledge of MDX expression language will allow you to define advance dynamic subsets. The Dynamic Subset UI has a MDX Helper that will help define common dynamic subsets.
In summary, Static Subset are easy to use and gives you the most control over this subset. Dynamic Subsets require less ongoing maintenance but requires knowledge of the MDX expression language.
Static Subsets
...
Dynamic Subsets
...
More Information
...