Planning Analytics

Planning Analytics

Get AI-infused integrated business planning

 View Only
  • 1.  PAW

    Posted Fri April 16, 2021 10:13 AM
    Hello,

    There is a business rule which return current date in IBM Planning analytics workspace. Is there a business rule which can return a next month like add_month in Cognos?


    Thank you in advance!

    Best regards,
    Nikolay
    NIKOLAY DINEV
    Data Analyst Expert

    35929615455/224 | 359886434495 | N.Dinev@ibs.bg | www.ibs.bg



    This email and any files transmitted with it are confidential and intended solely for the use of the individual or entity to whom they are addressed. If you have received this email in error please notify the sender and delete it immediately. IBS Bulgaria Ltd. is registered in Bulgaria. VAT number: BG131086564. Registered office: 4 Pimen Zografski str, Sofia 1172, Bulgaria

    #staysafe


    #PlanningAnalyticswithWatson


  • 2.  RE: PAW

    Posted Fri April 16, 2021 10:46 AM
    Probably "No" but need some more info on what you are trying to do.

    If you are trying to get next month to show cube values, you need to derive a member in a dimension. Typically people put attributes into the model for Previous Period, Next period and use business rules to look those up.

    If you are deriving a value into a string measure, you possibly still want to use attributes rather than long-winded composite functions to try do this.

    The main difference is that TM1 is not relational so would not necessarily need functions like add_month etc.

    ------------------------------
    George Tonkin
    ------------------------------