Hello everyone,

I'm hoping someone has experienced this before. I am having problems with
data inconsistencies when cubes are processed.

For instance, the data becomes static when we move forward to a new month,
therefore; the past month's financial data should not change. However, when
the cubes processed, sometimes the data becomes dynamic. But when I run
queries within query analyzer I receive the correct data. Then after going
and back forth, if I processed the cubes again, the data is back to normal.

Has anyone experienced data inconsistencies in reporting against OLAP 2000?
I am using excel pivotal tables to run reports. Not sure why the data keeps
changing when there is no new data or changes to past month's financial data.

Any insight would be greatly appreciated.

Which method do you use when you process your cube? If you are processing
with Incremental Update you might be giving wrong criteria which causes
duplication of existing records.
erdal

"SAM" <SAM (AT) discussions (DOT) microsoft.com> wrote

I actually use the Full Process method. To make sure it totally refreshes the
cube and not duplicate any of the data.

As a example, the first I process the cube, my total amount $487, 327.58 for
the month of May, then did some troubleshooting to compare numbers with an
old report method. Then processed again, the number changed to $487,269.58
for the same month.

The correct amount should be $487,278.08. If I drill down and query from
query analyzer, everything matches until I get to the final amount. Then
processed it again and I am back to $487,327.58.

"erdal akbulut" wrote: