Planning Analytics

 View Only

  • 1.  PAW - How to remove set editor it from default setting

    Posted Wed September 04, 2019 05:25 PM

    Hi

     

    I am fairly new to PA and PAW I was wondering if anyone knows how to remove  the default setting and set it to the desired option that user wants.

     

     

    Thanks &Regards,

    Dhwani N Talsania, Financial System Analyst I
    Email: dhwani.talsania@hunterindustries.com


    Hunter Industries, Inc.
    1940 Diamond Street
    San Marcos, CA 92078 USA
    www.hunterindustries.com

     


    #PlanningAnalyticswithWatson


  • 2.  RE: PAW - How to remove set editor it from default setting

    Posted Thu September 05, 2019 04:58 AM
    ​Hi Dhwani,
    I assume from your question that you want to override the default when the set editor is opened in PAW.
    Firstly, you need to delete any subset on the dimension that is named 'Default'. TM1 will then use 'All Roots' as the default set in the set editor.

    This will however have the adverse effect of removing the default settings for your dimensions and views. Therefore you need to append an alternative subset to the dimension to be used instead of 'Default'. You can see from the image that in our instance we have named these 'Standard'.
    Then you need to recreate the 'Default' view for the cube using the 'Standard' subsets.

    If this doesn't address your challenge then I suggest you post an image showing specifically where the problem lies.

    ------------------------------
    Trevor Mills
    ------------------------------

    Original Message


  • 3.  RE: PAW - How to remove set editor it from default setting

    Posted Thu September 05, 2019 07:00 AM
    Hi Trevor,

    Thanks for this answer.  I can confirm that the intentional behaviour of the Workspace set editor is to display any subset named Default first.  This behaviour cannot be disabled, but you can modify the Default subset (it's just a normal subset with the name Default).  In this case you could modify the public subset named Default to be the same as All Members.   As you suggest this will impact any views that use the subset named Default.  Also, if you have a private subset named Default it will take priority over any public subset named Default in the set editor.

    ------------------------------
    Stuart King
    IBM Planning Analytics Offering Manager
    ------------------------------

    Original Message


  • 4.  RE: PAW - How to remove set editor it from default setting

    Posted Thu September 05, 2019 07:38 AM
    ​Hi Stuart,
    thanks for setting out the specified behavior, it is a good idea for this question.
    The limitation of this approach, specifically in the set editor, is the following. By way of example:
    The "default" subset for our Financial Period dimension is defined as 2019Q4&Prior.
    However when the user uses the search functionality in the set editor within the default subset, then no results are returned.


    Therefore we renamed the default subset to "Standard" and now the search functionality in the set editor works.

    ------------------------------
    Trevor Mills
    ------------------------------

    Original Message


  • 5.  RE: PAW - How to remove set editor it from default setting

    Posted Thu September 05, 2019 07:49 AM
    ​Hi Dhwani - sorry I didn't see the image that had posted, this doesn't display in the email. But I think your challenge is the same as we experienced. If you follow our approach then it seems that the set editor then defaults to All Roots not All Members.

    Stuart - I would also be keen to know how to direct the set editor to use All members, or Root members or All Leaves. I didn't find a way to code this.

    ------------------------------
    Trevor Mills
    ------------------------------

    Original Message


  • 6.  RE: PAW - How to remove set editor it from default setting

    Posted Fri September 06, 2019 03:46 PM
    ​Thank you very much,  I really appreciate your prompt responses. We have decoded not change as it might affect other subset that are already created with Default setting as per my understanding from your responses.
    Thank you again...

    ------------------------------
    Dhwani Talsania
    ------------------------------

    Original Message


  • 7.  RE: PAW - How to remove set editor it from default setting

    Posted Thu September 05, 2019 08:26 AM
    Hi Dhawani!

    I also experienced some thing like this and it was later resolved though not by me. I think how the guy did it was to delete any subset on the dimension that is named 'Default'. Then the TM1 will be used "All Roots" as the default set in the set editor. That was how he explained it but i haven't tried it yet.

    ------------------------------
    falade yusuf
    ------------------------------

    Original Message