SSRS Report Against a SSAS Parent Hierarchy
The steps below are a combination of the steps located in the following Forum post, http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=138549&SiteID=1, as well as my experience in getting the Parent Hierarchy to display as intended in a SSRS report.
SSAS Dimension Setup
First, here is a quick setup of the Dimension table in SSAS that will be used in the steps below. The Dimension table, called Entity Dim, contains an Entity Id as the PK and has a field called Parent Id, which lists out the Parent Entity for the current Entity record. The Parent Id is a FK to the Entity Id field. Also, the Parent Id attribute of the dimension has the Usage property set to Parent which will create the Parent Child Hierarchy within the dimension. Lastly, the NameColumn property of the Parent Id is set to a to the [Entity Dim].[Entity Name] attribute to list out the full description name as opposed to the integer representation of the Parent Id record.
SSRS Report Creation
Tags: ssrs, parent-child