Planning Analytics

 View Only
  • 1.  Problems to Create a hierarchy from an attribute

    Posted Thu May 21, 2020 04:40 PM
    Does anyone here is facing any problem to create a hierachy, within dimension, from an attribute?

    ------------------------------
    Marcelo Rodrigues
    ------------------------------

    #PlanningAnalyticswithWatson


  • 2.  RE: Problems to Create a hierarchy from an attribute

    Posted Fri May 22, 2020 03:43 AM
    Hi Marcelo, 

    I tried to create a hierarchy using an attribute in PAW, and received an error on a couple dimensions (some worked, some didn't). I then created a TI process to create them instead of manually in PAW, and it was successful. The ability to create them as far as I know is manually in PAW or by using a TI. Hope this answers your question?

    ------------------------------
    Sarah Norton
    ------------------------------



  • 3.  RE: Problems to Create a hierarchy from an attribute

    Posted Fri May 22, 2020 08:09 AM


    The Create Hierarchy option shown above creates the hierarchy by running a TI process using the CreateHierarchyByAttribute TI function.  This function is documented here:  https://www.ibm.com/support/knowledgecenter/SSD29G_2.0.0/com.ibm.swg.ba.cognos.tm1_ref.2.0.0.doc/r_tm1_ref_tifun_createhierarchybyattribute.html

    This is a very basic TI function with limited usability.  It's really just intended as a quick start or demo for the hierarchies features.

    My advice is to create your own TI process with some basic error handling to build and update/rebuild the hierarchies based on the attribute.  That being said, if you do use the above feature and it fails, check the tm1server.log file and the TI process log that may be generated.

    Eventually our Workspace modeling team should replace the use of the CreateHierarchyByAttribute with a generic TI process that is more robust for generating hierarchies based on attributes.    

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