Report Model Project with SSAS 2005 - Reporting Services

Learn Microsoft BI Forum Core Servers Reporting Servi... Report Model Project with SSAS 2005

5/20/2009 5:34 AM

	Qazafi
51 posts

Report Model Project with SSAS 2005

Hi All

I am trying to use Report Model Project with SSAS 2005. The problem which I am facing with that, I could not see my user defined hierarchies in report model project, other then that every thing (Measures, Calculated Measure, and Attribute) is available. Does any body have any idea why these hierarchies are not available inside report model project? Am I missing any thing? Your help will be highly appreciated.

Many Thanks

Qazafi

5/27/2009 7:10 PM

	cutley
363 posts

Re: Report Model Project with SSAS 2005

Welcome to Report Builder with SSAS 2005. See this quote:

"Jamie MacLennan from the SSAS team did a great presentation about driving report payloads when UDM is used as a data source. What impressed me most was that Jamie gave us an honest account about some of the problematic integration areas instead of a let-me-show-you-how-cool-everything-we-did-is type of a presentation. For example, he pointed out that SSAS hierarchies don’t have Report Builder equivalents." (from http://prologika.com/CS/blogs/blog/archive/2006/06/18/1293.aspx)

Also see this post for some general issues when using a report model with a cube: http://blogs.microsoft.co.il/blogs/barbaro/archive/2008/05/15/creating-a-report-model-based-on-an-analysis-cube-pros-and-cons.aspx

Page 1 of 1

Learn Microsoft BI Forum

Core Servers

Reporting Servi...

Report Model Project with SSAS 2005