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

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
------------------------------

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
------------------------------

I suspect your Total Movement NP in UPR is also rule-based calculation? It could be that part is not fed properly.

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

Ida - Adjustments to UPR due to RI Non Qualified looks potentially unfed.

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

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
------------------------------