January 19, 2009 at 11:39 am
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,
January 19, 2009 at 7:53 pm
This sort of error usually happens because the dimension was not processed before the cube. If you have new records added to the tables in the dimension (in the relational database) you need to process the dimension first and then the cube.
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply