cancel
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

Hi

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

santosh

Answers (3)

Answers (3)

Former Member
0 Kudos

got it

ravishanker_cheedepudi
Active Participant
0 Kudos

Ganesh,

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.

Ravi

Anand71
Active Contributor
0 Kudos

Hello,

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.

Thnaks.

With regards,

Anand Kumar