Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
blatham
Starting Member
10 Posts |
 Posted - 2008-06-26 : 07:17:03
|
| HiDoes anybody know how I can get a reference to an attribute hierarchy?I want to pass in a string value so could do with a StrToHierarchy or similar.This is for a SSRS report so welcome suggestions. I have a report param that allows the user to choose what field the report groups by, so the dataset bound to the param looks likeGroup By Field 1, [Dim].[Group By Field 1]Group By Field 2, [Dim].[Group By Field 2]Group By Field 3, [Dim].[Group By Field 3]In the main dataset I can get the members for the selected attribute hierarchy with StrToSet(@GroupByField + ".Children").I want the caption for the current member too so with a calculated member I need something likeWITH MEMBER [Measures].[GroupByFieldCaption]AS ?????.CURRENTMEMBER.MEMBER_CAPTIONSo what replaces the question marks?! I know I could write a case statement to test the value of the @GroupByField and return the relevant reference but is there anything more elegant?Thanks |
|
|
|
|
|
Attribute Hierarchy Reference