Analysis Services
Guidelines, best practices
Known problems
- 906161 - The 32-bit version of the SQL Server 2005 Analysis Services Instance Rename tool (ASInstanceRename.exe) does not work correctly on a 64-bit computer
- 908500 - BUG: SQL Server 2005 Analysis Services performance monitor counters do not report values
- 912390 - BUG: SQL Server 2005 Analysis Services still generates aggregations on the (All) member of a dimension when you set the value of the AllMemberAggregationUsage property to None
- 912396 - Error message when you try to run an MDX query on a ROLAP-based dimension in SQL Server 2005 Analysis Services: "Server: The operation has been cancelled"
- 912399 - Event ID: 1023 occurs, and counter data is not logged when you use Performance Monitor to collect data from SQL Server 2005 Analysis Services performance counters
- 912421 - BUG: Error message when you run, import, or migrate a SQL Server 2000 DTS package that contains an instance of the Analysis Services Processing task in SQL Server 2005: "Invalid class string"
- 914098 - Measure data returns "#N/A" when you query a cube under a database role that has read-only access to the cells in the cube in SQL Server 2005 Analysis Services
- 915851 - All the measures of the cube are displayed when you browse a cube by using a perspective that does not have a specified measure
- 922673 - Error messages when you try to process a database or a cube in SQL Server 2005 Analysis Services: "The attribute key cannot be found" and "The record was skipped because the attribute key was not found"
- 926045 - BUG: Error message when you try to use a data mining model in a SQL Server 2005 Analysis Services project: "Errors in the metadata manager The data type of the 'Customer_Integer ~MC' measure must be the same as its source data type"
- 932214 - Minimum requirements to use Excel Visual Basic for Applications functions in MDX queries in SQL Server 2005 Analysis Services
- 932687 - The processing operation may stop responding when you process a SQL Server 2005 Analysis Services database on a server that has a single processor
- 932688 - Error message when you use the Aggregation Design Wizard in SQL Server 2005 Business Intelligence Development Studio: "No mapping between account names and security IDs was done"
- 932871 - When you reference a set alias that is referenced in a calculation in SQL Server 2005 Analysis Services, you may receive unexpected results
- 933507 - Error message when you use the ADOMD API to perform a writeback operation on a SQL Server 2005 Analysis Services database: "Incorrect procedure call or argument"
- 933832 - Error message when you try to run a Multidimensional Expressions (MDX) query in SQL Server 2005 Analysis Services: "An unexpected exception occurred"
- 933836 - Security permissions that are associated with the existing roles may reset when you use the Analysis Services Deployment Wizard to deploy a SQL Server 2005 Analysis Services project
- 935995 - When you run an MDX query in SQL Server 2005 Analysis Services, the query takes longer to run than expected
- 935996 - An MDX query takes longer than you expect to finish in SQL Server 2005 Analysis Services
- 936078 - Error message when you try to save a SQL Server 2005 Analysis Services database and a dimension in the database contains a parent/child hierarchy: "Dimension 'DimensionName' cannot be saved"
- 938495 - Slow performance when you run an MDX query that accesses the key attribute hierarchy in a parent-child dimension in SQL Server 2005 Analysis Services
- 940019 - Error message when you run a complex MDX query that contains the NON EMPTY clause in SQL Server 2005 Analysis Services: "The expression contains a function that cannot operate on a set with more than 4,294,967,296 tuples"
- 941153 - The proactive caching feature does not start on some partitions or on some dimensions after you start the SQL Server 2005 Analysis Services service
- 941742 - A cube is not modified when you process the cube by using the ProcessDefault option in SQL Server 2005 Analysis Services
- 942240 - Error message when you run an MDX query against a dimension cube in SQL Server 2005 Analysis Services: "The $<DimensionCube_Name> cube either does not exist or has not been processed"
- 942839 - An MDX query returns additional cell data when you use the IsEmpty function on the query axis in Analysis Services with SQL Server 2005 Service Pack 2
- 944527 - You obtain no result set when you run an MDX query against an instance of SQL Server 2005 Analysis Services
- 945685 - When you request a large MDSCHEMA_MEMBERS schema rowset from a client application, the request takes a long time to respond and the client application uses lots of virtual memory in SQL Server 2005 Analysis Services
- 947065 - The synchronization operation stops responding when you synchronize databases between two instances of SQL Server 2005 Analysis Services when the TCP Chimney Offload technology is enabled
- 947509 - You may obtain an incorrect result when you run an MDX query against an instance of SQL Server 2005 Analysis Services if the WHERE clause contains a set
- 947510 - Error message when you use the Rowset Viewer sample to obtain the MDSCHEMA_PROPERTIES rowset of the dimension in SQL Server 2005 Analysis Services: "The " string cannot be converted to the unsignedShort type"
- 947511 - Error message when you run an MDX query against an instance of SQL Server 2005 Analysis Services: "The set in the WHERE clause cannot contain multiple measures"
- 947512 - You cannot connect to SQL Server 2000 Analysis Services on a server that is running a 64-bit instance of SQL Server 2005 and a 64-bit instance of SQL Server 2005 Analysis Services
- 950329 - The memory usage of the Analysis Services server or of client applications may increase significantly when you execute MDX queries against a SQL Server 2005 Analysis Services server
- 950599 - An SPN for the SQL Server Browser service is required when you establish a connection to a named instance of SQL Server 2005 Analysis Services or of SQL Server 2005
- 951575 - Error message when you run an MDX query that uses the GENERATE function in SQL Server 2005 Analysis Services: "The Axis0 function expects a tuple set expression for the argument"
- 952113 - When you use dynamic security, SQL Server 2005 Analysis Services does not reevaluate the permissions of the user after the permissions change
- 952114 - How the impersonation information option of a SQL Server 2005 Analysis Services database affects deployment and synchronization
|
|
