MS SQL Server OLAP - Inconsistant values from the same cube?

You are viewing an archived Text-only version of the thread. To view this thread in it's original format and/or if you want to reply to this thread please [click here]

Author

Inconsistant values from the same cube?

Tarpan

2005-04-21, 8:24 pm

Perhaps this is something that is well known, but I did not see
anything (perhaps I missed it). But I am finding that the real value
for some of my cells in the Budget (FoodMart 2000) cube are
inconsistant in that the value is different when differnet people are
connecting the same cube.

I am placing Accounts / Category on the Rows / Columns. Ther is a
value that will appear in this list on the Current Years Budget as well
as others that will be "565238.129999999". What I find odd is that
when other people are connecting to this cube they are seeing a
slightly differnet value such as "565238.130000006" or
"565238.130000002".

I'm not very clear as to why this number would change depending on the
client connecting. I'd appreciate any insight I could get.

Sponsored Links