multivalue parameters in ssrs usinf mdx query

Question

multivalue parameters in ssrs usinf mdx query

MGLTD

Old Hand

Points: 300
More actions
May 30, 2015 at 9:04 am

#398524

Hi i was trying to have multivalue options in a ssrs report, and I used this query
SELECT {[Measures].[Sales Amount],[Measures].[Tax Amount]} on columns,
non empty([Product].[Color].[Color],[Product].[Product Name].[Product Name]) on rows
from
( select
(STRTOSET(@color))
on columns
from [Analysis Services Tutorial])
But the report only showed the default value as an option(in this format [Product].[Color].&[Multi] whic is not presentable),
and what I also noticed in the parameter option is that, the available values option is set to none
, also when I try to use get from query , it does not give me the vales for the parameters,
and when I right click the designer pane it does not have the show hidden dataset option.
I have created the parameter with multivalue option. Please what can I do to get the multivalue option to work
Thanks

Viewing 7 posts - 1 through 6 (of 6 total)

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

MGLTD Old Hand Points: 300 More actions · Answer 1

I was following a tutorial online, but the authour did not specify that I had to create another dataset for the parameter. so I

https://social.msdn.microsoft.com/Forums/sqlserver/en-US/6ce3fbaa-bc6d-4411-bb1f-aaecaaede3cc/ssrs-passing-multivalued-parameters-to-mdx?forum=sqlreportingservices

then cretaed another dataset for the parameter and was able to use it, I dont know if its the right way but it worked. Also the hidden dataset is still not coming up.

Thanks

pietlinden SSC Guru Points: 63519 More actions · Answer 2

looks right. You have to create a dataset pretty much anytime you're connecting to a different database object (table, query, stored procedure, whatever).

MGLTD Old Hand Points: 300 More actions · Answer 3

Hi, Please do you have an idea, why the hidden dataset is not showing, and also any book you can recommend that deals in ssrs for mdx , cheers

pietlinden SSC Guru Points: 63519 More actions · Answer 4

Why would a hidden dataset show? By setting it as hidden, you're telling SSRS not to show it.

Not sure there are any books specifically on MDX and SSRS. (Checked Amazon, nope.)

MGLTD Old Hand Points: 300 More actions · Answer 5

AS regards the Hidden data,

The example I was following online by roopesh (https://www.youtube.com/watch?v=keHDpyeuHkg).

in the tutorial, when he declared the parameter , the dataset was created automatically (though he had to right click to show the hidden dataset for the parameter, which I also so on technet.

But when i declared my parameter no dataset was created automatically (I had to create a dataset myself, then map the available values to the dataset I created), But when I created a second parameter (also created a dataset for it) it does not filter appropriately,so am thinking I might have started on the wrong foot and thats why the dataset is not created automatically

pietlinden SSC Guru Points: 63519 More actions · Answer 6

check out the WiseOwl tutorial on youtube on how to create datasets and filtering. Helped me a lot.