Creating a query-based subset

We recommend that you create query-based subsets if subsets change frequently, for example, with every structure update. Those subsets are results of queries in the form of SELECT statements. The DEPM_MOD_ELEMENTINSUBSET schema table is populated by the query. Queries are run at each publishing. You can run queries on demand.

  1. Select Dashboards > Data Integrations > OLAP Modeling.
  2. Select the model and then the dimension and hierarchy for which to create a subset.
  3. On the Elements tab, select Subsets > + Query based.
  4. Specify a name for the subset and modify the displayed SELECT statement according to your needs.
  5. Click Save.
  6. To test your query without loading the subset members, click Preview.
  7. To view the subset, select the subset from the list and click Apply.
    The query is run and all members of the selected subset are displayed in the grid.