Dimensional Reporting Grouping Members

[cognos05]

Hi,

I have a dimension customer by group and there are nearly 240 customers.

I have to group these customers in to 10 custom groups.  Mostly like I have customers name ending with Abc_Bestbuy, bdc_BestBuy

so the name either ends with or statrs with a same word.

SO what member expression should i write to create my custom groups

Thanks,
Nithya

[MFGF]

Hi,

I have a dimension customer by group and there are nearly 240 customers.

I have to group these customers in to 10 custom groups.  Mostly like I have customers name ending with Abc_Bestbuy, bdc_BestBuy

so the name either ends with or statrs with a same word.

SO what member expression should i write to create my custom groups

Thanks,
Nithya

Hi,

Don't go there. Do it in the cube (or in FM if it's a DMR package).

MF.

[cognos05]

Thanks, Planning to add it at cube .