Hello, 

I have a budget cube using ID#s and a Time dimension. For the year 2020 the time dimension consolidation has stopped working at Quarter and Year levels. 

The Monthly totals are calculated from another cube, and all years except 2020 are consolidating correctly. 

Does anyone have an explanation or fix for this?



------------------------------
Brianne Melrose
------------------------------

#PlanningAnalyticswithWatson

Hi Brianne,

Prima facie it seems that your months for FY20 are not being fed at the leaf-level and hence the lack of consolidation (since they're calculated fields -- but not fed appropriately).

I'd advise you to scrutinise the rule file of the respective cube to further debug.

Kind Regards,
- Roscoe

------------------------------
Roscoe Lobo
Leader - Data Science & AI
Veracitiz
India
------------------------------

Hi,

Check the following:

1. If the values are rule driven, check that 2020 months are fed (more likely the case)
2. Check if the element weight for 2020 periods is 0
3. Ensure there are no c level rules applying for 2020 forcing it to be 0

R,

------------------------------
Amin Mohammed
------------------------------

As others have mentioned this appears to be an issue with feeders (or lack of feeders).  When a rule derived cells are not fed the impact is that any consolidations on top of those rule derived cell will be empty.  In cases were you don't care about the consolidations on top of rule derived cells (because the consolidated values are never used or referenced) you can skip creating a feeder statement to improve performance.  Less feeders will give you better performance but feeders are required to get the consolidations on top of rule derived cells.

Without adding a feeder statement you can typically prove the issue is with feeders by removing SKIPCHECK from your rules.  Note that it might be very slow to refresh the view with SKIPCHECK removed depending on the size of the cube.  If the consolidated values appear with SKIPCHECK removed you know that feeders are the issue.


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