Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2000 Forums
 Analysis Services (2000)
 Urgent - My cube is not giving correct results :(

Author  Topic 

Joozh
Posting Yak Master

145 Posts

Posted - 2004-04-14 : 05:11:34
Hi,

When I check the totals for various dimensions (tables) in the database which is used for my cube, I get the correct results (I have tallied them with the results from my OLTP)...

But when I browse my cube (using the same parameters, or should i say dimension combination) i get different results as compared to what I mentioned earlier

The datatype for the field/column under question in my datamart is float (which is giving me the correct results). What should I change the Data Type of my measure in the Cube Editor to ??? to get the same results?

Please guide/help.

Thanks & Regards.

-J

Merkin
Funky Drop Bear Fearing SQL Dude!

4970 Posts

Posted - 2004-04-14 : 07:21:07
No need to cross post

Damian
Go to Top of Page
   

- Advertisement -