Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2005 Forums
 Analysis Server and Reporting Services (2005)
 Processing Cube on SQL 2005

Author  Topic 

california6
Starting Member

38 Posts

Posted - 2009-01-19 : 13:41:25
Hello,

I am trying to process a cube here's what i see:

Errors in the OLAP storage engine: The attribute key cannot be found: Table: dbo_tblFactOperations, Column: ACCOUNT_OPERATIONS, Value: KOI_DPO_DEN_SQL. Errors in the OLAP storage engine: The attribute key was converted to an unknown member because the attribute key was not found. Attribute Account_Operations_ID1 of Dimension: Account_Operations from Database: Reporting, Cube: Operations, Measure Group: Operations, Partition: FAC2Operations, Record: 1. Errors in the OLAP storage engine: The process operation ended because the number of errors encountered during processing reached the defined limit of allowable errors for the operation. Errors in the OLAP storage engine: An error occurred while processing the 'FAC2Operations' partition of the 'Operations' measure group for the 'Operations' cube from the Reporting database.

Intresting, the query which was generated by OLAP to run against the DB Server - If i take that and run on the DB - it starts to return values. kind of strange.

can somebody please help here?

Thanks,


Cali
   

- Advertisement -