Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 549
  • Last Modified:

SSAS OLAP Cube from one source table - Avoid Missing Attribute Error

I was able to successfully deploy and process an SSAS OLAP cube from one source table. This did not require a Dim or Fact table defined.

However, in the subsequent processing I encountered this error:
"Errors in the OLAP storage engine: The attribute key cannot be found when processing: ..."

 What should I do to prevent missing attribute key?
1 Solution
Ryan McCauleyData and Analytics ManagerCommented:
Even though you have a single source table, you still have dimensions, correct? I believe it's telling you that a new dimension value has shown up and a processing of your cube uses one of the new values, but the formalized dimension isn't aware of the new value.

This has happened to us when we do an incremental processing of our cubes - switching the automated processing from incremental to full resolved the issue, as it processes all the dimensions first, before proceeding to processing the facts.

Featured Post

Become an Android App Developer

Ready to kick start your career in 2018? Learn how to build an Android app in January’s Course of the Month and open the door to new opportunities.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now