please need help with cube processing error

Who is online?  0 guests and 0 members
Home  »  Forums   »  microsoft business intelligence   »  analysis services   » please need help with cube processing error

please need help with cube processing error

Topic RSS Feed

Posts under the topic: please need help with cube processing error

Posted: 4/17/2012

Jedi Youngling 14  points  Jedi Youngling
  • Joined on: 4/16/2012
  • Posts: 7
0

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

Padawan 909  points  Padawan
  • Joined on: 6/7/2011
  • Posts: 48
Answered  Answered

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. 


Page 1 of 1 (2 items)