SolvedPrivate

OLAP CUBE Problem

Posted on 2013-06-05
2
33 Views
Last Modified: 2016-02-18
Hello, I get the following error

Errors in the OLAP storage engine: The attribute key cannot be found when processing: Table: 'MYTABLE', Column: 'ID', Value: '57101553'. The attribute is 'ID'. Errors in the OLAP storage engine: The record was skipped because the attribute key was not found. Attribute: ID of Dimension: MYTABLE from Database: OlapRepPortal, Cube: MYCUBE, Measure Group: MYTABLE, Partition: MYTABLE, Record: 216231. 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 'MYTABLE' partition of the 'MYTABLE' measure group for the 'MYCUBE' cube from the OlapRepPortal database.

Open in new window

0
Comment
Question by:snnege
2 Comments
 

Author Comment

by:snnege
Comment Utility
Last error


Errors in the OLAP storage engine: The attribute key cannot be found when processing: Table: 'MY_TABLE', Column: 'SERVER_ID', Value: '538'; Table: 'MY_TABLE', Column: 'REZ_NO', Value: '62367'. The attribute is 'SERVER ID'. Errors in the OLAP storage engine: The attribute key was converted to an unknown member because the attribute key was not found. Attribute SERVER ID of Dimension: MY TABLE from Database: OlapRepPortal, Cube: MY_CUBE, Measure Group: MY TABLE, Partition: MY TABLE, Record: 380531. 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 'MY TABLE' partition of the 'MY TABLE' measure group for the 'MY_CUBE' cube from the OlapRepPortal database.

Open in new window

0
 
LVL 37

Accepted Solution

by:
ValentinoV earned 500 total points
Comment Utility
That error means you've got values in your fact table (measure group) for foreign keys to dimensions which don't actually exist in the dimension, in other words incorrect foreign keys.

The error message clearly states what tables, columns and even values you need to look into.

There can be many causes for this to happen. Have a read through the following articles, they should contain useful info to help you out:
SSAS Quick Reference: Attribute Key Cannot Be Found
Idiot’s Guide to SSAS Attribute Relationships
0

Featured Post

Free Trending Threat Insights Every Day

Enhance your security with threat intelligence from the web. Get trending threat insights on hackers, exploits, and suspicious IP addresses delivered to your inbox with our free Cyber Daily.

Join & Write a Comment

Introduction Earlier I wrote an article about the new lookup functions (http://www.experts-exchange.com/A_3433.html) that ship with SQL Server 2008 R2.  In this article I’m going to show you another new feature of SSRS 2008 R2, this time in the vis…
In this article I will describe the Backup & Restore method as one possible migration process and I will add the extra tasks needed for an upgrade when and where is applied so it will cover all.
When you create an app prototype with Adobe XD, you can insert system screens -- sharing or Control Center, for example -- with just a few clicks. This video shows you how. You can take the full course on Experts Exchange at http://bit.ly/XDcourse.
You have products, that come in variants and want to set different prices for them? Watch this micro tutorial that describes how to configure prices for Magento super attributes. Assigning simple products to configurable: We assigned simple products…

762 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

15 Experts available now in Live!

Get 1:1 Help Now