Planning Analytics

 View Only

  • 1.  Consolidated Value

    Posted Wed February 23, 2022 10:53 PM
    Hi All,

    Can someone please help me with the rules? my TestUPR cube doesnt get the correct Total FYE (consolidated value). Tried with simple cube TestComm which works fine. May I know what's wrong with my rules? 

    Thank you in advance!




    regards
    Ida

    ------------------------------
    ida lasim
    ------------------------------

    #PlanningAnalyticswithWatson


  • 2.  RE: Consolidated Value

    IBM Champion
    Posted Thu February 24, 2022 05:10 AM
    Does the "TestUPR" cube have SkipCheck turned on in the rules?
    If so it could be that you are not feeding "Adjustment to UPR due to RI Non Qualified" - this would result in the consolidated cells not adding up (like you are seeing.)

    In the "TestComm" cube we can see your entire rule sheet and it doesn't have SkipCheck, so it would work as it doesn't need feeders and will instead just sum up all consolidations automatically.

    ------------------------------
    Declan Rodger
    Technical Director
    Spitfire Analytics
    ------------------------------

    Original Message


  • 3.  RE: Consolidated Value

    Posted Thu February 24, 2022 05:29 PM
    Ida, 
    A simple check is to turn on zero suppression and if your Non Qualified line disappears it is not fed, which appears to be the case.

    ------------------------------
    Craig Sawers
    ------------------------------

    Original Message


  • 4.  RE: Consolidated Value

    Posted Fri February 25, 2022 04:29 AM
    I suspect your Total Movement NP in UPR is also rule-based calculation? It could be that part is not fed properly.

    ------------------------------
    mvp morgan
    ------------------------------

    Original Message


  • 5.  RE: Consolidated Value

    Posted Fri March 25, 2022 09:04 AM
    Ida - Adjustments to UPR due to RI Non Qualified looks potentially unfed.

    ------------------------------
    Matthew Manuele
    ------------------------------

    Original Message


  • 6.  RE: Consolidated Value

    Posted Fri March 25, 2022 04:51 PM
    I have a feeling that your Total Movement NP in UPR is actually a rule-based calculation as well. It's possible that the part isn't getting enough nutrition.

    ------------------------------
    zaid ashraf zaid111
    ------------------------------

    Original Message