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 (899825)

MORE INFORMATION

• 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.
• Reports that contain Key Performance Indicator (KPI) images cannot be rendered or saved.
• Formulas that use explicit aggregate functions over a set instead of using server aggregates return null values because of an issue in the server components of Analysis Services. Examples of explicit aggregate functions are the Sum aggregate function and the Count aggregate function.
• For the DateTime attribute, two attribute variations are visible in the model. One attribute returns a DateTime value that is displayed in a caption format. For example, the DateTime value that is displayed is 1 July 2004. The other attribute returns a DateTime value that is displayed in a value format. For example, the DateTime value that is displayed is 7/1/2004. However, in SQL Server June 2005 CTP, both attributes return a DateTime value that is displayed in a value format.