SQLTeam.com | Weblogs | Forums

Displaying Hierachy Members in DataSet


#1

Pretty new to all this but here goes....I'm building a report in SSRS using Analysis Services as the source.

In the Query Designer of my DataSet I'm bring in a hierarchy and an amount. I don't want to see some of the members in the hierarchy when it comes to building my report but I can't seem be able to select just the members that I need. I can only select the full hierarchy.
I want to be able to see the members of the hierarchy so I can pick and choose and reorder exactly how I want them to appear.

Is that achievable?