This discussion is archived
0 Replies Latest reply: Feb 13, 2013 6:49 PM by mssandye RSS

Hierarchy Totals Issue

mssandye Newbie
Currently Being Moderated
Hello,

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.

Please help.

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points