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.

1. Static Subset:

2. Dynamic Subset:

   1. Click on the + sign to create a new subset, input a name for it, and click the “check” button.

   2. Click on the new subset. On the Configuration side, there are four fields:

      1. KeepSubsetDynamic: after the subset creation by mdx it will become static

      2. Automated MDX Type: Predefined mdx subsets

      3. Automated MDX Base Element: dimension elements

      4. SubsetExpression: Manually type an MDX subset(Only available if nothing is selected on Automated MDX Type)

   3. See the results on the Content side

   4. Click on the Save&Close button.

3. Standard - Decide if the standard subsets are to be updated or not.