I am using OBIA Financial Analytics for PeopleSoft. We have the out of box Segment1 Hierarchy tree and we are using it for a number of reports. However, we noticed an issue where the hierarchy is not rolling up data correctly. We removed the aggregate table from the Fact to test if it was an aggregates issue, but it is not. Does anyone have any suggestions? Below is what we see.
Level 1 = 10000
- Level 1 Child A = 10000
- Level 1 Child B = 300
- Level 1 Child C = 700
Obviously Level 1, should equal 2000, not 1000. This is happening up and down the tree, where the parents are taking the values of the first child in the lower level.