Skip to Content
0
Former Member
Sep 18, 2007 at 01:17 AM

BI Standard Report : Aggregation Error

17 Views

Hi All,

Recently activated BI Content. While checking one of the standard report(Query), i found that some of the key figures were not aggregated(sum).

The queries that i am checking now are based on 0SD_C01 (Customer cube). I'll use one of the standard report as example. 0SD_C01_Q026

Instead of displaying the sum-med figure, some of the key figures are displaying a *. A quick check on the standard cube shows that these key figures belongs to type CURR. Key figures type DEC is however, displaying the sum-med figure.

I created a simple query, by dragging in some of the key figures. Data that i've loaded, consist of different currency values. What i can see is, it's able to display the data in detail level, in different currency. The aggregated values, are not displayed.

Thus, i am suspecting - there's something wrong with the currency conversion that causes the error during aggregation. Anyone dealt with this problem before?

Thanks in advance.