Skip to Content
avatar image
Former Member

Issue with Key Figure Database Aggregate (Ratio)

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!

Add comment
10|10000 characters needed characters exceeded

  • Follow
  • Get RSS Feed

1 Answer

  • Best Answer
    Sep 08, 2010 at 08:58 AM

    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

    Add comment
    10|10000 characters needed characters exceeded