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.