I have data model where is possible to enter from one dimension several members at same time (two tables with relationship 1:n, Product1 is possible to have Detail_Product1 and Detail_Product2). So now I want to filter data so to choose all products which does not have Detail_Product_id=1 and to remove it. Problem is that for Product_ID=1 I have for the same time and Detail_Product_id=1 and Detail_Product_id=2, and report studio keep giving me back and this Product1.
How to create filter or something else that will remove Product1 because it has Detail_product_ID=1.
I use DMR
Thanks
To be honest, I am not really clear on the data structure. Can you explain the dimension hierarchy? I thought maybe it was like
[Product1]
--[Detail_Product1]
--[Detail_Product2]
and your issue was if you filtered [Detail_Product2] you were still seeing [Product1], but that would make sense. Do I have the hierarchy or something all wrong?
As to what i understood with your post. It will return Product1 since it has both detail_product ID 1 and 2. It will only remove products that dont have Detail_product ID 1.
???