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.