In an RPD that started its life in 11g and has been migrated to 12c, I now see a consistency check warning in 12c: "[39092] Presentation level "Budgets"."Time"."Year" is first under presentation hierarchy, but logical level it is associated with is not grand total level."
Year has always been the topmost level of this Time hierarchy. It has never had a topmost parent level that represents a total of all values at the Year level.
I want to clear this consistency check warning, and I know I need to tick a "Grand Total Level" checkbox to do so.
Do I need to add a true Grand Total level as a parent of Year, and tick the checkbox on that level? I have no business need for such a level, so I would be doing so only for the purpose of clearing this warning. (Side note: This RPD started its life in EBS, so there are about 300 of these warnings. Adding a true Grand Total level for each of them will be a pain.)
Or can I simply tick that checkbox on the existing Year level? That feels wrong, because Year is not a true grand total level. But I can't find any documentation that describes what the Grand Total level checkbox does behind the scenes, the real, true reason why it is important, so I can't determine whether ticking the Grand Total checkbox for Year is a good thing or a bad thing.
Can someone share the purpose behind the Grand Total level checkbox at a deeper level than what is found in the documentation? And then also answer my question above: Do I have to add a true Grand Total level?