Posted: 4/17/2012
Hi,
I'm processing a CUBE and i'm getting the following error:
"Errors in the OLAP storage engine: The attribute key cannot be found: Table: Permit_x0020_FACTS, Column: CaseStatus, Value: Collections. Errors in the OLAP storage engine: The attribute key was converted to an unknown member because the attribute key was not found. Attribute Case Statuses of Dimension: Case Statuses from Database: ACCELA Performance Reports, Cube: Permits, Measure Group: Permit FACTS, Partition: Permit FACTS, Record: 320702.
But when i processed the PERMITS_FACT individually, it was a success, please need advice as why this FACT table is failing in the CUBE and not individually?
Thanks
Posted: 5/3/2012
Try unprocessing the entire SSAS database and then do a Full Process on the entire SSAS database. You should be at the very top level of the hierarchy when in SSMS or BIDS to do this.