dimension records exceeds 64000

I am facing a problem in SSAS, unlike Analysis service 2000 , I cannot find any grouping under level properties for a dimension. Actually one of the dimension is too big, some 1600000 records are there and no hierarchy as such. only way is to club by first alphabet,which we were using in 2000. i.e. by using the grouping property. but in SSAS 2005 I cannot find any, how do i overcome this, otherwise beyond 64000 records its not showing

There has been a change in terminology in AS2005. Instead of grouping this functionality is refered as Discretization.

You need to create a new attribute based on the same column as your main attribute.

Set the DiscretizationMethod to Automatic. ( you can try any other method find if you like it better).

Also take a look at the NamingTemplate property of the attribute. You should be able to use it to get Analysis Server to generate custom names for your grouping (discretized) attribute.

Here is BOL topic on the matter: http://msdn2.microsoft.com/en-us/library/ms174810.aspx

Edward.
--
This posting is provided "AS IS" with no warranties, and confers no rights.