Hi All,
I'm new in Cognos 10 and I encounter this strange behavior when trying to use total() function.
Here's the detail.
- I retrieve data from SAP-BW, let say 3 fields (Rev Adj, Gross Profit Adj, and Net Profit Adj).
- These fields are calculation of Rev * percentage, Gross Profit * percentage, Net Profit * percentage
- In Cognos 10 Report Studio, I create data items to contain the total for each of this value
- The expression in data item is : total([Revenue Adj]), total([Gross Profit]), total([Net Profit])
- The strange part; the expression total([Revenue Adj]) works ok, but total([Net Profit]) gives me an error like this:
The query is not supported. The value summary function 'total' in the data item 'YTD Curr TP Eqin' is based on detail values and the function does not match the pre-aggregated values in the OLAP data source.
Here's the screen cap:
(http://i144.photobucket.com/albums/r171/Spinnnzzzz/CognosError.jpg)
I wonder what does this error message mean and why does the same formula work on the other fields?
Anybody can shed some light?
Thanks.