on 09-08-2010 4:38 AM
Hi All
We are facing issues of blank/ empty key figures when we set it to measure by Database Aggregate (Ratio) upon data refresh.
When we run it in BEX directly with such aggregate (ratio) it does not seem to have this issue. We highly suspect it is the MDX query issue.
Anyone faces such issue and how did you resolve this? Any note that you all applied?
This is the current version of SAP BW we are on now --> SAPKW70106 SAP Business Warehouse
Hope to here from you all soon!
Hi,
We have problems with database aggregation objects period, not just ratios.
Two reasons we hit this blanks or #UNAVAILABLE or keep having #TOREFRESH.
1) Using dimension variables that are defined in the report, not in the BEX query.
This can be as simple as concatenating a key and description
2) Not able to get back the rows on the aggregation level asked for
Happens when you use a condition pulling back multiple key values for an infoobject.
For this reason we do not use database aggregation anymore.
If we need things like ratios, we pull back the divisor and denominator separately
(each having a sum aggregation) and calculate the ratio in the report.
This calculation will aggregate correctly.
Hope this helps,
Marianne
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
84 | |
24 | |
11 | |
9 | |
7 | |
6 | |
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.