DMR expression to exclude [BD],[BO],[OC]

[tarunkrdas2013]

In my DMR report i have Region Level with members [NW],[BA],[LA],[SD],[NE],[SE],[MW],[TE],[WC1],[WC2],[EC1],[EC2],[EC3], [WC],[EC],[BD],[BO],[OC]
In DMR there is an option to exclude members ,i did that excluding [BD],[BO],[OC] but somehow when i ran tabular data still [BD],[BO],[OC] is displayed

Is there any DMR expression any one can suggest to exclude [BD],[BO],[OC]

[Francis aka khayman]

check the data if it has been excluded in a temporary crosstab, not in tabular data

[MFGF]

In my DMR report i have Region Level with members [NW],[BA],[LA],[SD],[NE],[SE],[MW],[TE],[WC1],[WC2],[EC1],[EC2],[EC3], [WC],[EC],[BD],[BO],[OC]
In DMR there is an option to exclude members ,i did that excluding [BD],[BO],[OC] but somehow when i ran tabular data still [BD],[BO],[OC] is displayed

Is there any DMR expression any one can suggest to exclude [BD],[BO],[OC]

Tabular data displays in a list, so you're always going to get some odd results with dimensional sources.

Why are you using an approach to exclude members - can you tell us the real requirement?

Is this the same report as in your other post? http://www.cognoise.com/index.php/topic,29140.0.html

MF.

[tarunkrdas2013]

Yes this is the same report ,requirement is i need summation of Regions as crosstab member and inside Regions i need to display Sales measures as nested cross tab member of Regions and logic for Regions is its a Member set with Set definition defined as (Exclude <- Region) and in exclude i have [BD],[BO],[OC]

[MFGF]

Yes this is the same report ,requirement is i need summation of Regions as crosstab member and inside Regions i need to display Sales measures as nested cross tab member of Regions and logic for Regions is its a Member set with Set definition defined as (Exclude <- Region) and in exclude i have [BD],[BO],[OC]

Hi,

That doesn't answer the question, though. Why are you using exclude()? There didn't appear to be a good reason to do it from what you wrote in your other post?

MF.

[tarunkrdas2013]

actually we are rewriting the expressions which were prewritten in Cube reports so exclude was used in cube so i am trying to find a way for DMR