Aggregation issue with Hyperion Planning
One of my friends recently called and me that the parent in her Hyperion Planning was not aggregating even if the aggregation script was ran multiple times. She double checked the aggregation script and there was no logical or syntax errors. The Parent has multiple children and half of them or dynamic calc and other are store members. What was the issue.
In this type of cases before going aggregation script we must first check the consolidation properties. There was an offshore team in India and they changed the consolidation property to "Ignore" and she was not informed.
Again this issue may look very simple but the order in which we trouble shoot may save time. Instead of banging head looking at aggregation script, we should first check the consolidation property.