Cube doesn't give expected sum total

#1

Hello all,

Following is the case.
I have a cube on client level filled with currect and past clients.
For each client i have a nr_of_client value of 1 (current) or 0 (past).

If I do a select sum( nr_of_client ) in QA on the time partitioned fact
table I get a total of 9457457.
But when I process the cube I get a total of 9406465 in AS.
And yes i have all dimension set to "All" except for the time dimension of
course.

The entire fact table doesn't allow nulls.

Does anybody have an explanation and more importantly a solution?

#2

You check the generated SQL statements during cube processing in QA.

Ohjoo Kwon

"Mike van der Niet" <MikevanderNiet (AT) discussions (DOT) microsoft.com> wrote in
message news:B4E5FF1D-1541-4C5A-865D-5E08CECB00EE (AT) microsoft (DOT) com...

Quote:

Hello all,

Following is the case.
I have a cube on client level filled with currect and past clients.
For each client i have a nr_of_client value of 1 (current) or 0 (past).

If I do a select sum( nr_of_client ) in QA on the time partitioned fact
table I get a total of 9457457.
But when I process the cube I get a total of 9406465 in AS.
And yes i have all dimension set to "All" except for the time dimension of
course.

The entire fact table doesn't allow nulls.

Does anybody have an explanation and more importantly a solution?

#3

When you get the 9457457 result are you using the same joins to the
dimension tables that you use when processing the cube? It sounds like
you have data in the fact table that isn't in one of your dimension
tables.

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Cube doesn't give expected sum total

microsoft.public.sqlserver.olap microsoft.public.sqlserver.olap

Cube doesn't give expected sum total - 03-14-2005 , 02:17 AM

Re: Cube doesn't give expected sum total - 03-14-2005 , 04:16 AM

Re: Cube doesn't give expected sum total - 03-14-2005 , 10:18 PM