Showing results for 
Search instead for 
Did you mean: 

overall result is not matching in Primary actuals report in bi

Former Member
0 Kudos

hi guru,

i am facing prob. in checking overall result of product for my primary report in report when i am checking GSV values for 04.2009 to 06.2009 my overall result for GSV it is matching but when i drill down by product it not matching for over all result for perticular product for 04.2009 to 06.2009.

can anyone plz simplify me how to fix this prob.

rewards point for sure....

Accepted Solutions (1)

Accepted Solutions (1)

Former Member
0 Kudos


If the report is based on Multiprovider, then try restricting with infoproviders (eg in the query designe layout you have infoproviders 1 2 and 3 based on the requirement )

try doing it , hope fully you will ge result unchanged


Answers (3)

Answers (3)

Former Member
0 Kudos

got it

Active Participant
0 Kudos


If you have calculations like Qty * value , it will match at detailed level when you go to summary. it will try to add total qty * Value

As anand said you need to use Exception aggregation with reference to some character (Ex : material etc ..) in the key figure properties.


Active Contributor
0 Kudos


If you are using BI 7.0

Just try if this works..In your KF or CKF or formula, click on Aggregation tab, select Exception aggregation as Maximum or Minum and select Reference characteristic as the lowest level in your hierarchy.


With regards,

Anand Kumar