Planning Analytics

 View Only

  • 1.  PAW SYNCHRONIZATION OPTIONS

    Posted Mon October 25, 2021 04:21 AM
    Hi all

    i believe it's great time to improve sysnchronization options .

    At the moment when a dimension is out of a view in a selector widget and as a row dimension in a view , PAW shows the selected element and its children.

    Most of the time we'd like to have level0 Descendants of the selected element or children without the selected element.... 

    we definetely need options for synchonizations , its too restrictive at the moment.

    regards

    fred




    ------------------------------
    frederic MALLAVAL
    ------------------------------

    #PlanningAnalyticswithWatson


  • 2.  RE: PAW SYNCHRONIZATION OPTIONS

    Posted Tue October 26, 2021 03:55 AM
    Hi, 

    I think you can do this with MDX or combination of Hierarchy and MDX. 

    For your case, you can create a hierarchy of "model" which contain consolidated elements and create a MDX in row dimension which takes just leaf level elements.

    ------------------------------
    Corentin Gombert
    ------------------------------

    Original Message


  • 3.  RE: PAW SYNCHRONIZATION OPTIONS

    Posted Tue October 26, 2021 04:20 AM
    Hi


    because it's synchronized , any MDX you write is removed when you change selection in widget selector , that's the point .

    regards

    Fred

    ------------------------------
    frederic MALLAVAL
    ------------------------------

    Original Message


  • 4.  RE: PAW SYNCHRONIZATION OPTIONS

    Posted Wed October 27, 2021 03:29 AM
    Edited by System Fri January 20, 2023 04:50 PM
    Hello Frederic,

    In the example shared, I think you can achieve that using the option "Hide totals" (right clic on rows).
    It will hide the total member and keep childrens (even not directly the descendants).




    Regards,

    ------------------------------
    Florence Mougnaud
    ------------------------------

    Original Message


  • 5.  RE: PAW SYNCHRONIZATION OPTIONS

    Posted Thu October 28, 2021 02:51 AM
    Hello Florence

    good to know , many thanks .

    Anyway we do need more options , children, descendants ....

    regards

    Fred

    ------------------------------
    frederic MALLAVAL
    ------------------------------

    Original Message