COGNOiSe.com - The IBM Cognos Community

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

Quote from: nithya1224 on 20 Nov 2015 08:29:28 AM
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.

Thanks, Planning to add it at cube .