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]
check the data if it has been excluded in a temporary crosstab, not in tabular data
Quote from: tarunkrdas2013 on 30 Sep 2015 07:19:51 PM
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.
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]
Quote from: tarunkrdas2013 on 01 Oct 2015 10:49:19 AM
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.
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