List of known issues that may occur when you use SQL Server 2005 Analysis Services cube-based report models in SQL Server 2005 Report Builder

Article translations Article translations
Article ID: 899825 - View products that this article applies to.
BUG #: 382596 (SQLBUDT)
Expand all | Collapse all

INTRODUCTION

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.

MORE INFORMATION

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.

REFERENCES

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:
http://www.microsoft.com/sql/default.mspx

Properties

Article ID: 899825 - Last Review: July 5, 2007 - Revision: 2.1
APPLIES TO
  • 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
Keywords: 
kbhowto kbinfo KB899825

Give Feedback

 

Contact us for more help

Contact us for more help
Connect with Answer Desk for expert help.
Get more support from smallbusiness.support.microsoft.com