I've updated an OLAP cube and I can see the new cell value in my report.
But I was surprised when I tried to execute a MDX against the changes I made and compared it with the data of my cube in the reportin-Services.
I updated a cube cell with the value of 1
The report showed - in fact - 1; but the MDX-query got 0.99999 back.
Why is their a different?
Any idea?
Florian
If the cell you updated was not right down at the leaf level, then AS would have split up the value you were allocating across all the leaf level cells under the one that you updated. My guess is that this has most likely resulted in a small rounding error. The report is probably just set to format to a given number of decimal places an is rounding up.
No comments:
Post a Comment