Microsoft small business knowledge base

Article ID: 899825 - Last Review: July 5, 2007 - Revision: 2.1

BUG #: 382596 (SQLBUDT)


This article lists known issues that may occur when you use Microsoft SQL Server 2005 Analysis Services cube-based report models in SQL Server 2005 Report Builder.


Analysis Services and Report Builder are integrated in SQL Server 2005. You can generate report models that are based on Analysis Services cubes and use these report models in Report Builder. However, the following known issues may occur:
  • In Report Builder, when you select a report model that was generated from an Analysis Services cube, you must select a perspective that is contained within the model. You must not select the top-level model itself. If your report contains items that are not within a single perspective, an error may occur when you try to render the report.
  • The number of entities and relationships of entities in a navigation path are limited. The behavior in Report Builder is limited to the Analysis Services equivalent of navigating from a dimension to a related measure group and then to a second related dimension. In future versions of SQL Server, the user interface (UI) will restrict the length of the navigation path. In SQL Server June 2005 Community Technology Preview (CTP), the UI does not restrict the length of the navigation path. Therefore, your report may fail if the navigation path exceeds the limit.
  • The parent-child attribute relationships are not visible in the model.
  • The sort order that is applied by Analysis Services is not preserved by the reports. This issue is especially noticeable for time attributes, such as the Month attribute.


For more information about how to create an Analysis Services cube-based model, see the "How to Create a Model Using Report Manager" topic in SQL Server 2005 Books Online.

For more information about SQL Server 2005, visit the following Microsoft Web site: (

  • Microsoft SQL Server 2005 Enterprise Edition Community Technology Preview
  • Microsoft SQL Server 2005 Developer Edition Community Technology Preview
  • Microsoft SQL Server 2005 Standard Edition Community Technology Preview
  • Microsoft SQL Server 2005 Workgroup Edition Community Technology Preview
kbhowto kbinfo KB899825
Additional support options
Ask The Microsoft Small Business Support Community
Contact Microsoft Small Business Support
Find Microsoft Small Business Support Certified Partner
Find a Microsoft Store For In-Person Small Business Support