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.
| Author |
Topic |
|
bridge
Yak Posting Veteran
93 Posts |
 Posted - 2005-04-28 : 06:11:43
|
| I have made a cube in which measuring column is UserID and dimension is Content Type, The results are correct except Total which is as under MeasuresLevelContent Type UserIDAll ContentType 195Footer 91HomePage 195Main 1News 0Links 19The total should be the sum of (91+195+1+0+19) = 306But it is showing 195, how can it be corrected. Please tell me I have tried so many times by deleteing the cube and making a new one but it always gives te results mentioned above. |
|
|
mateamargo
Starting Member
10 Posts |
Posted - 2005-06-10 : 11:34:52
|
| It is because you are using "Distinct Count", try with "Count". |
 |
|
|
rockmoose
SQL Natt Alfen
3279 Posts |
Posted - 2005-06-10 : 12:29:48
|
quote:
Originally posted by mateamargo
It is because you are using "Distinct Count", try with "Count".
You mean SUM ?What is the aggreagat function that is used for the measure ?What is the datatype of UserID ?rockmoose |
|
|
|
|
|
|
Incorrect Cube Total