I am new to ssas and i am trying to find a way to pass multi values parameter to mdx.I have a similar report
using Sql queries.I am trying to replicate the sql report. The ssrs report has 3 parameters
a) Country
b) County
c) Town
in my sql report I have these parameters show up like
-UK
--London
---Newham
Since this is a multi values parameter so users have the option to select multiple values.
Every combination has a key associated and via another query where this keys are passed we get the dataset.ex:key Country County Town
2 UK Newham Bow
I mean everything in sql query is done via procedures.
** we have a sql table with all combination of these 3 columns(we do not have any dimension like this in cube
Although we can create if required).
How to achive the same using mdx. Any suggestion would be a great help.