...
Click on [Build Dimension] to update the FIN Company dimension.
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:
Click on the + sign to create a new subset, input a name for it, and click the “check” button.
Click on the new subset. From the middle part select which elements to include in the subset(you can select one or multiple elements).
Click on the arrow button and the Subset Content side will be updated. By clicking on the element you can change its order in the subset.
After adding all elements click on the Save&Close button.
...
https://apliqo.storylane.io/share/ca0aywihruhn
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.
...
...
Manage Security
Select Company from the sidebar. Click on the Security button.
...