This discussion is archived
0 Replies Latest reply: Jan 30, 2013 9:03 AM by 966242 RSS

OBIEE 11g Report-When drilling down to lower level, totals are not matching

966242 Newbie
Currently Being Moderated
Hi All,

I am creating a report in Analytics 7.9.6.3 , OBIEE 11g - Let’s say Budget Cost/Actual Cost based on the Date Dimension

Have selected the Fiscal Year Dim, Fact Budget Cost, Fact Actual Cost

FY BCost ACost

2011 100 120
2012 150 140
---------------------------------
Total 250 260
------------------------------------

But here when I am drilling down from Year to Quarter and Period - The values are not matching with the totals....

FY FY Qrt BCost ACost

2011 2011 Q1 80 100
2011 Q2 100 90
2011 Q3 110 120
2011 Q4 90 130
-----------------------------------------------------
Total 380 440
----------------------------------------------------

Fiscal Year, Fiscal Quarter Budget Cost and Actual Cost are not returning correct results – When selecting cost's by fiscal year, or filtering on a specific fiscal year, the amount returned does not equal the fiscal year total;

when I am drilling down to Quarter and Period Level the BCost & ACosts are bumping the Numbers as above and not matching with totals

Any suggestions?

Legend

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