Hi Guys,
I am pretty much new to SSAS and a way to go. I am having a requirement like below and I need some help down here.
We are having some products. There are basically hirarchical structure (Only 1 level). Say I am having Prod1 as my parent product and it's flag is 1. Under Prod1 there can be saveral products which flag is 0.
My requirement is something like this while extracing data from the Cube through MDX by default only Prod1 records should come. If they want to see the detailed products (i.e. all the products under Prod1) then they have to use "[Item].[Contained Flag].[All]" explicitly in the MDX.
I am literally pretty much confused how to achive this. I was referering some blogs and found that we can use scope in the calculated members. Any help will be appreciable.
T