We are encountering a very peculiar error in our DW environment. The
OLAP database on our PRODUCTION Server contains many cubes and one such
cube was processed as part of a job which ran to completion. However,
the data the cube reports is wrong and totally different than the one
we get running a direct SQL against the underlying database. We moved
this OLAP database to a different (DEV) server, reprocessed the cubes
(without changing the datasource) and this cube reports the correct
data!! Has anyone encountered such an issue and if so, what exactly the
problem here. We are in touch with MicroSoft but they do not have any
answers yet. Thanks in Advance.

Thanks
Jagannathan Santhanam

You should provide more info.
Are the extraction queries exacly the same?
Could you show both and provide information on table relationships?

Adriana
Datatime Team
http://cam70.sta.uniroma1.it/Technic...ew/Default.htm

Does the values at the leaf levels of the cube matches RDBMS data in
your Production Server ?
May be you are using some shared dimensions and that might be causing
the problem.