Monday, May 27, 2013

Issue in SSAS cube hierarchy parameter in SSRS



Hi
I am using SSAS cube as data source in SSRS. Version is SQL server 2008 R2
In cube, there is hierarchy which is child and parent relationship. It has about 10 levels.
The hierarchy I want to make as parameter in SSRS.
In Query Designer, I have selected parameter check box for hierarchy in dimension.
My questions are here
1.I do not see multi select check box option
2.It is not loading hierarchy values into dropdown check box when run the report.
It will be great helpful if you help on this
Thanks in advance



No comments:

Post a Comment