Archive for December, 2014

Accessing Member Properties on Parent-Child Hierarchies from SSRS Reorts

1) Edit MDX and add properties to DIMENSION PROPERTIES of the axis as below…..

SELECT	non empty {[Measures].[PnL],[Measures].[PL Limit]} ON COLUMNS , 
		NON EMPTY [Organization].[MyTree].members
   DIMENSION PROPERTIES PARENT_UNIQUE_NAME,[Organization].[MyTree].[My Level Name] ON ROWS  
   FROM [MYCUBE] 
   WHERE ([Date].[Date].&[20141210]) 

[Organization].[MyTree].[My Level Name] is a property of the MyTree at any given level.

2) SSRS query designer will automatically add a field (“My_Level_Name”) to the dataset, but it doesn’t show any data when we add the field to the Table (only in this case of Parent-Child Hierarchy, it works fine in other cases), so it is of no use to us, we might as well bin it.

3) When we need to access Member properties of the tree, we can use expression something like this….
=Fields!MyTree(“My Level Name”)

(Same as retrieving Cell Properties….=Fields!FieldName(“FORMAT_STRING”))

Tags: , , ,

Monday, December 15th, 2014 SSRS No Comments