Report Portal

Working with a Parent-Child Hierarchy in SQL Server Reporting Services (SSRS)

Problem
I'm trying to create a report that uses a parent-child hierarchy in a dimension of a SQL Server Analysis Services cube.  I've done this before where I had a parent-child hierarchy in a SQL Server relational database, but the cube has me completely baffled.  Can you provide an example of how to do this?

Solution
Your situation is understandable.  Working with a parent-child hierarchy in a relational database is fairly straight forward, while doing the same thing with a dimension in a cube is not.

In this tip I'm going to covering the main points you need to be able to report on a parent-child hierarchy from a relational database then show the one subtlety you need to report on a parent-child dimension hierarchy in a SQL Server Analysis Services cube.

Read more...

 

Tags: design, ssrs, hierarchy

 

2007-2015 VidasSoft Systems Inc.