I'm having a problem with how numbers are totalling up with only one
dimension. And within that dimension, it's only one member. Everything else
is adding up correctly. However, this member has a very large count (excess
of one billion).

This is my first foray into SSAS2005. The cube only has one measure group.
I'm stuck.






Event Count (Year)
2006
Pencils Event Count 32,804,341
Staples Event Count -252,548,399




Event Count (Month in 2006)
January February March April
Pencils Event Count 2,200,105 2,032,483 21,939,494 6,632,259
Staples Event Count 1,283,911,300 1,234,406,428 1,395,568,217
128,532,952








Event Count
2005 Difference Total September October
November December
A Event Count 31,883,685 0 31,883,685 6,601,080 15,030,556 5,971,077
4,280,972
B Event Count 18,425 0 18,425 2,336 867 3,424 11,798
C Event Count 7,325 0 7,325 906 340 1,357 4,722
D Event Count 16,500 0 16,500 1,816 677 3,410 10,597
E Event Count 6,061 0 6,061 528 194 1,222 4,117
F Event Count 6,647,586 0 6,647,586 1,698,098 1,615,147 1,495,443
1,838,898
G Event Count 6,390,173 0 6,390,173 1,671,898 1,560,075 1,422,098
1,736,102
H Event Count 712,639 0 712,639 442,926 269,713
I Event Count 822,691,255 0 822,691,255 210,503,173 238,054,803
201,350,084 172,783,195
J Event Count 42,914,951 0 42,914,951 25,986,340 16,228,307 315,552
384,752
K Event Count 10,723,405 0 10,723,405 2,666,238 3,113,327 3,325,980
1,617,860
L Event Count 86,721,174 -4,294,967,296 4,381,688,470 869,963,982
1,302,772,901 1,046,337,036 1,162,614,551
M Event Count 29,800,195 0 29,800,195 6,248,464 8,551,092 8,832,515
6,168,124
N Event Count 1 0 1 1
O Event Count 390,564,431 0 390,564,431 86,115,191 104,679,761
95,041,063 104,728,416
P Event Count 13,395 0 13,395 2,455 4,065 3,717 3,158
Q Event Count 10,941,788 0 10,941,788 3,502,492 1,944,896 1,606,150
3,888,250
R Event Count 59,452,964 0 59,452,964 7,268,306 14,546,862 14,946,049
22,691,747
S Event Count 17,174,519 0 17,174,519 3,085,474 3,769,825 4,590,678
5,728,542

So the formatting didn't exactly come out, my apologies.


"Jesse O." <jesperzz (AT) hotmail (DOT) com> wrote