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 |
|
truchuynh
Starting Member
4 Posts |
 Posted - 2012-01-09 : 15:17:37
|
| Hi,We have a Survey table with 9 millions records.We want to create a dimension from this table using field QuestionnaireCode(non numeric) as key.There are about 8000 disctinct QuestionnaireCode.So 2 attributes are created: QuestionnaireGroup and QuestionnaireKey(both using the field QuestionnaireCode).In the QuestionnaireGroup attribut, the following properties are set:* DiscretizationBucketCount= 20* DiscretizationMethod= EqualArea* EstimatedCount=8000Result: Only 3 groups are created (instead of 20).Why did it happen ?Any other property that need to be set to get 20 groups?Note: If DiscretizationBucketCount is reset to 300 then 18 groups are created. (Why ?)Thanks for all your input. |
|
|
|
|
|
Create grouping in dimension