on 11-12-2009 6:51 AM
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....
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
got it
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
87 | |
23 | |
11 | |
9 | |
8 | |
5 | |
5 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.