Advanced option to filter by top/bottom x

Apliqo UX
1

What are the parameters to set up advanced filtering for

  • Leaf elements of dimension
  • Leaf elements of subset

image

I have this and stuck on the last two parameters.

{
   "table": {
    "tableFilters": {
      "filterOptions": {
        "topOrBottom": "top",
        "x": 10,
        "filteredColumn": "[Period].[Period].[January]",
        "column": 2,
        "itemsOrPercent": "items",
        *"leafElements": "?",
        *"TM1level": 0
      }
    }
  }
}
2

Solution!

{
   "table": {
    "tableFilters": {
      "filterOptions": {
        "topOrBottom": "top",
        "x": 10,
        "filteredColumn": "[Period].[Period].[January]",
        "column": 2,
        "itemsOrPercent": "items",
        "leafElements": "leavesOfDimension",
        "level": 0
      }
    }
  }
}

leafElements can either be leavesOfDimension or leavesOfSubset