Planning Analytics with Watson

Expand all | Collapse all

Is there a way to create/update the calculation in a cube using Ti

  • 1.  Is there a way to create/update the calculation in a cube using Ti

    Posted Tue November 19, 2019 02:11 PM
    I have a model I am using. It has a bunch of "manual input" cubes. It has a cube that calculates cost, based on the inputs in other cubes.

    I would like to create a single Ti script that would completely create the database, with all required dimensions and cubes, and insert all the members into the "manual input" dimensions. By now, I know how to achieve this.

    The one thing I don't know is how to put the requisite calculations in the cube Calculation property.

    Is there a way I can achieve this particular step in Ti?

    ------------------------------
    Shubho Ghosal
    ------------------------------


  • 2.  RE: Is there a way to create/update the calculation in a cube using Ti

    Posted Wed November 20, 2019 03:45 AM
    Hi Shubho,

    have a look at the Rule Management TI function. This should solve your problem.

    https://www.ibm.com/support/knowledgecenter/en/SSD29G_2.0.0/com.ibm.swg.ba.cognos.tm1_ref.2.0.0.doc/c_rulesmanagementturbointegratorfunctions_n71e7c.html

    Cheers

    ------------------------------
    Tomasz Brzoza
    tomasz.brzoza@linde.com
    ------------------------------



  • 3.  RE: Is there a way to create/update the calculation in a cube using Ti

    Posted Wed November 20, 2019 02:17 PM
    Excellent! Thank you Tomasz!

    ------------------------------
    Shubho Ghosal
    ------------------------------



  • 4.  RE: Is there a way to create/update the calculation in a cube using Ti

    Posted Thu November 21, 2019 04:14 PM
    Hi Shubho,

    Do keep in mind that the feeders would need to be refreshed as well. 

    Vikas


    ------------------------------
    Vikas Bhatia
    ------------------------------