Set Expressions

Set expressions, or expanders are keywords in the query to process and filter hierarchical dimension structures.


The syntax of the exander:

{"d": "dimension_name","e": "keyword","p": ["parameter","more parameters"]},

Example:

The example return element with ID actual from the dimension data_type.

{"d": "data_type","e": "one","p": ["actual"]},


List of supported keywords:


  1. ALL: returns all elements in the dimension; if the number of elements in a dimension is larger than 20,000 then the expander returns only nodes (rollups) which you can further use to retrieve leaves for

  2. ONE: return one or more elements specified in the parameter

  3. DEP: return all descendants of the specified element

  4. BAS: return all leaf elements below the specified element

  5. LDEP: return all descendants of the specified element up to n levels deep, where n must be specified in the parameter

  6. SDEP: return the specified element and its descendants

  7. LEX: return all descendants of the specified element up to n levels deep, where n must be specified in the parameter, or return element itself if it is a leaf-level element.

  8. BEX: return all descendants of the specified element up to n levels deep, where n must be specified in the parameter, or return element itself if it is a leaf-level element.

  9. FILTER: query elements based on some criteria specified in the parameter


Parameters for each expression: