Microsoft KB Archive/899825

= 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 ID: 899825

Article Last Modified on 7/5/2007

-

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

-



BUG #: 382596 (SQLBUDT)



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.

