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.

Different dynamic grouping question

Hi,

I have a basic report that has some transaction info, eg

Name Type

AAA Buy

AAA Buy

AAA Sell

BBB Buy

BBB Buy

BBB Buy

BBB Sell

Etc

I want to group all the BBB's together, but I don't want to group ANY others together... Ie, I want to group the transactions together if the name is BBB, else I don't want to group at all.

Is this possible?

I hope I have given enough info.

Cheers

Rob

You can very well do the grouping on NAME field and hide the grouping depending on the value of that field.
|||

I need to be able to drill down into the complete list if needed. which means I need a group header to display the grouped data and allow the user to click the plus sign to expand the BBB records.

This won't work for two reasons, firstly I don't want anything other than BBB to be grouped at all, secondly this would show up a group header for each different name, when I'd only want a group header for the BBB group, and the others just display the details.

Hope that makes sense.

|||Anyone? This is doing my head in