May 30, 2015 at 9:04 am
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
May 30, 2015 at 10:00 am
I was following a tutorial online, but the authour did not specify that I had to create another dataset for the parameter. so I
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
May 31, 2015 at 12:28 pm
looks right. You have to create a dataset pretty much anytime you're connecting to a different database object (table, query, stored procedure, whatever).
May 31, 2015 at 12:54 pm
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
May 31, 2015 at 2:10 pm
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.)
May 31, 2015 at 2:18 pm
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
May 31, 2015 at 2:29 pm
check out the WiseOwl tutorial on youtube on how to create datasets and filtering. Helped me a lot.
Viewing 7 posts - 1 through 6 (of 6 total)
You must be logged in to reply to this topic. Login to reply