August 11, 2009 at 5:25 pm
I deployed a cube in SSAS using BIDS, and within BIDS I assigned my dimension attribute to be sorted by KeyColumn and not Name. And when I actually browse my cube either in SSAS envronment or BIDS environment, my dimensions are beings sorted the way I like it. However, when I built a report thru SSRS via SSAS datasource connection and created a tablix report that looks the same way in my cube browser, I noticed that my dimensions are not being sorted the way I expected it to be, but just sorting alphabetically by name. Do you know how can I go around it or fix this in SSRS?
Thanks, by the way, I'm using SSRS 2008 and BIDS 2008.
August 11, 2009 at 10:09 pm
Reporting Services does its own sorting and is not aware of the sort order you defined in the dimension. You will need to expose the column you are using in the dimension as an attribute. You can then include this in the query you are using for your report and use it for the sorting in your report.
August 11, 2009 at 10:19 pm
Reporting Services does its own sorting and is not aware of the sort order you defined in the dimension. You will need to expose the column you are using in the dimension as an attribute. You can then include this in the query you are using for your report and use it for the sorting in your report.
August 12, 2009 at 9:13 am
Yes, I was thinking of that, however, I want to make sure there's another way of doing it without exposing the attribute that will be used for sorting. I have a field in my dimension table called FieldSortingOrder which I used to sort the members of hierarchy when I browse the cube in SSAS or BIDS.
January 31, 2011 at 8:15 am
hi there
I am having exactly the same problem, however i am an ssas/mdx newbie and I wouldn't know how to go about exposing the ordering column as an attribute and then sorting on this in the SSRS query.
Any help would be highly appreciated!!
Thanks
Doodles
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply