This forum is no longer active. Please post your questions to our new community site

Doubt in MDX query

Subscribe to Doubt in MDX query 1 post, 1 voice

Avatar retail 9 post(s)

can anyone tell me how to add two members of a slicer dimension in the where clause of the MDX query in jpivot?
for example i have a location dimension in my cube which has many locations like adelaide,sydney,boston etc.I also have a product dimension ie., products being sold in each location.suppose i need to display all the products that are sold only in adelaide and boston,how do i frame the query for this?please provide me with a sample query.i am a newbie to MDX.