Planning Analytics

Planning Analytics

Get AI-infused integrated business planning

 View Only

  • 1.  Default set for hierarchy (PAW)

    Posted 06/03/19 08:59 AM
    Hi,

    This might be a silly question, but I can't figure it out.

    I have created hierarchies in my dimensions. However, I can't find a way to set default subsets for the hierarchies (setting one for the dimension/default hierarchy works fine). Naming a subset Default does nothing and the hierarchies can not be accessed in Architect so I can't go in and just check the box to make a set default. Any ideas?

    The default set seems to default to "DESCENDANTS({[<dimension>].[<hierarchy>].DEFAULTMEMBER} , 1 , SELF_AND_BEFORE)", and I would in this case at the very least want to set the alias to use.

    This is in cloud versions 2.0.6(TM1) and 42(PAW).

    ------------------------------
    Anssi Lehtinen
    ------------------------------

    #PlanningAnalyticswithWatson


  • 2.  RE: Default set for hierarchy (PAW)

    Posted 06/06/19 09:08 AM
    Hi Anssi,
    I create default subsets in hierarchies with a TI. E.g. SubsetCreatebyMDX('DimensionName:HierarchyName', sMDX);
    regards
    Trevor

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



  • 3.  RE: Default set for hierarchy (PAW)

    Posted 06/09/19 09:34 AM
    Thanks for the reply, Trevor

    Unfortunately I'm unable to get that to work. I tried
    SubsetCreatebyMDX('Customer:Customer By Country', vMDX);
    and got Error: Prolog procedure line (6): Name ('Customer:Customer By Country') contains an invalid character (the invalid character being the colon, since if I remove that, I can create subsets, but obviously they do not become the default subset). Customer is my dimension and Customer By Country is the hierarchy I want the subset in.

    Ran the code in the TI editor in PAW and will not fire up Architect until July when my vacation is over so will get back to this then.

    Cheers, Anssi


    ------------------------------
    Anssi Lehtinen
    ------------------------------

    Original Message


  • 4.  RE: Default set for hierarchy (PAW)

    Posted 06/11/19 04:24 AM
    For info, here is a script that works in my environment. I only use PAW editor (ver 2.0.41) no Architect anymore.

        sDim = 'ActuarialSegment:CalculationSegment';
        sMDX = '[' | sDim | ']';
        sMDX = '{TM1SUBSETALL( ' | sMDX | ' )}';
        sMDX = '{TM1FILTERBYLEVEL( ' | sMDX | ', 1)}';
     If (SubsetExists(sDim, cSubset) = 0);
      SubsetCreatebyMDX(cSubset, sMDX);
     Else;
         SubsetMDXSet(sDim, cSubset, sMDX);
     Endif;​

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

    Original Message


  • 5.  RE: Default set for hierarchy (PAW)

    Posted 06/12/19 06:46 AM
    Hi Annsi,

    The TM1 database does not really have a concept of a default subset or default view.  Planning Analytics Workspace will look for a subset (private or public) that is literately named 'Default' and display this subset at the top of the list of subsets as well as showing that subset by default in the left hand side of the set editor.  I believe subsets named default, if they exist, will also be used by default when defining new views in Workspace.

    We are planning on adding a feature in Workspace that will allow modelers to set a default subset (for any hierarchy).  However, this will likely work the same as it works in Architect, where it simply saves the subset with the name 'Default'.  This is something you can do manually now.

    Please let me know if this explanation helps.

    ------------------------------
    STUART KING
    ------------------------------



Related Content