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 |
|
tabreaz
Starting Member
3 Posts |
 Posted - 2006-08-17 : 02:11:11
|
| My fact table is Col1 Col2 Col3 Sum1 Sum2 Sum3Col1 and Col2 are related to respective other information tables in a star schema fashion.Col3 is related to other information table, but when I include that table in Cube during the processing of Cube I get error "Members Per Parent Limit exeeds(64,000)", Col3 have more than million of distinct values. So I did not include that information table in cube.My requirement is to have distinct count of col3, I define it using DISTINCT COUNT Col3But the problem is that it takes huge processing time and space too. I search internet to find some solutions but all other alternatives need information table for col3.Is there any other alternative?RegardsTabreaz |
|
|
Jim77
Constraint Violating Yak Guru
440 Posts |
Posted - 2006-08-23 : 17:58:48
|
| I think that error message came about as all your members where part of a hierarhical structure make all the members the same level and see what that does, but I could be mistaken!!! |
 |
|
|
|
|
|
Distinct Count on Fact Table Column