Planning Analytics

 View Only
  • 1.  PAX Exploration view question

    IBM Champion
    Posted Mon October 03, 2022 04:22 AM
    hi,

    i have an client who want to make some PAW exploration view with the MDX modified (for exemple, for create a colum of calcul perso) but they want to make the MDX dynamique

    is there a way to make an TI to update the MDX of PAW exploration view? 

    is there a way to save the last choice on PAW explocation view? (for exemple: last time, i chose another company to view, when i come back, i want it is the same company that i chose)

    is there a way that MDX can take the value of widget of selector? 

    thank your help !

    ------------------------------
    Duong DAU
    Consultant EPM Finance Transformation & Performance - Micropole


    M +33 (0)7 62 61 85 33
    F +33 (0) 4 26 99 60 81
    131 Boulevard Stalingrad / 69100 Villeurbanne
    ------------------------------

    #PlanningAnalyticswithWatson


  • 2.  RE: PAX Exploration view question

    Posted Tue October 04, 2022 04:26 AM
    Make a cube with dashboard, client and measure.  Add a picklist attribute to the measure dim.

    Make a subset that is the current member in client.  Then change the MDX to pick up the selection.

    This will let users have their previous selections, you can change the selection in ti (though not the MDX).

    I think there is a decent write up of this somewhere.  Will post if I get time to look.

    ------------------------------
    James McCarthy
    ------------------------------



  • 3.  RE: PAX Exploration view question

    IBM Champion
    Posted Tue October 04, 2022 04:49 AM
    Thank you very much! I will try it

    i have another réponse on TM1forum that give me an exemple with Strtomember but i dont see StrtoMember in the support MDX list of TM1 ==> is this documention updated? 

    https://www.ibm.com/docs/en/planning-analytics/2.0.0?topic=reference-mdx-function-support


    Then change the MDX to pick up the selection. ==> can you give me 1 exemple of MDX modified to pick up the selection? 
    thanks !

    ------------------------------
    Duong DAU
    Consultant EPM Finance Transformation & Performance - Micropole


    M +33 (0)7 62 61 85 33
    F +33 (0) 4 26 99 60 81
    131 Boulevard Stalingrad / 69100 Villeurbanne
    ------------------------------



  • 4.  RE: PAX Exploration view question

    Posted Tue October 04, 2022 08:14 AM
    Hi,

    StrtoMember is used widely in TM1 solutions. I am guessing that everyone on here uses it in virtually every model they ever build.

    So you can use it in TM1 MDX.

    regards,

    Mark

    ------------------------------
    Mark Wragg
    ------------------------------