I have a SQL table named PkgGroup that is related to the Item table, the Item table is then related to the MonthlyTrans fact table with the measures I want to aggregate. I used the Dimension Usage Tab of the Cube Designer to designate that the PkgGroup table was related by reference to the Item table. In the June release this worked fine and my table processed correctly. When I use the same Analysis Services Project that had been created with the June release against the same SQL Server database that I had Backed Up and then Restored with the installation of the Sept release, I get an error message that includes this line - "The attribute key cannot be found: Table: dbo_PkgGroup, Column: PkGrpNo, Value: 73087". I have rechecked the Tables, the Relationships, and the underlying data and it all seems to be in order. Is the new release not working correctly or is it something I'm doing wrong
Referenced Table Dimension worked in June SQL Release but fails in Sept Release
Hot Topic
- Remote Connection problem on MS SQL 2000
- Problem with valid owner
- Problem setting gvar with DTEXEC
- Unable to start new instance in Notification service
- NOT EXISTS optimization
- How to launch a SSIS package from VB or whatever
- SQL Mobile and Vista
- Problem opening UDF
- SQL Server Enterprise Manager
- Suggest Column Types
SQL Server
- Integration Services in BOL: Is this all I get?
- DTS or Replication?
- How can I attach database files from outside the local server?
- Securing the MS SQL Server 2005 database on client side
- DHCP Service fails to start after installing SQL Server 2005 April CTP
- ISSCEStatusReporting interface - replication progress in C++
- WHERE includes all letters
- Setting up connection from DB2 to Itanium
- Is it possible to deploy reports on server and view it from client machines
- SQL Server 2005 Stored Procedure inserting duplicate keys into table that is uniquely indexed
Referenced Table Dimension worked in June SQL Release but fails in Sept Release