SSRS multi value parameter used in SSAS MDX

  • scottichrosaviakosmos

    SSCommitted

    Points: 1887

    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.

  • Sue_H

    SSC Guru

    Points: 90707

    scottichrosaviakosmos - Friday, January 12, 2018 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.

    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 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply