cancel
Showing results for 
Search instead for 
Did you mean: 

Issue with Key Figure Database Aggregate (Ratio)

Former Member
0 Kudos

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!

Accepted Solutions (1)

Accepted Solutions (1)

MariannevL
Advisor
Advisor
0 Kudos

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

Former Member
0 Kudos
We have problems with database aggregation objects period

+1

Avoiding database delegated works for us too

Answers (0)