January 12, 2018 at 3:12 am
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.
January 12, 2018 at 3:38 pm
scottichrosaviakosmos - Friday, January 12, 2018 3:12 AMI 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 BowI 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.
Here are some examples of cascading parameters you may want to look at:
Add Cascading Parameters in a SSRS Report using MDX and SSAS Multi-Dimensional
Cascading parameters in SSRS(MDX)
Sue
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply