Planning Analytics

 View Only
Expand all | Collapse all

Rest API - Process variables position when using MDX view as a source

  • 1.  Rest API - Process variables position when using MDX view as a source

    Posted Wed January 19, 2022 03:38 PM
    Edited by System Fri January 20, 2023 04:08 PM
    I am trying to figure out how position property works in Process Variables. 

    When I use a Native View as a source, position of a variable should match order of dimensions in a source cube. However, when an MDX view is used a source, that doesn't seem to work any more and I get mismatched results via variables. Things get even more complex if I add multiple hierarchies from each dimension.

    Can you please help me to match variables to corresponding hierarchies for MDX view sources?

    Thanks!
    #PlanningAnalyticswithWatson


  • 2.  RE: Rest API - Process variables position when using MDX view as a source

    Posted Thu January 20, 2022 12:50 AM
    Edited by System Fri January 20, 2023 04:34 PM

    The issue was in the version of TM1 I used. The variables positions were scrambled when an MDX view was used as a data source. After upgrading to the latest version, I found that variables positions are based on the order of Axes and Hierarchies in a cell set (starting with 0).

    https://www.ibm.com/support/pages/apar/PH24729


    #PlanningAnalyticswithWatson