Solved

SSAS Errors in the OLAP storage engine: The attribute key cannot be found when processing

Posted on 2013-01-16
3
721 Views
Last Modified: 2016-02-18
Hi,
I'm getting the followin error when I process the cube.
any solution to get out of this error to accept this. becaouse I know there are dimension keys  missing.
so, I need to tell the deployment process to ignor this error and process.

Thanks in  advance
0
Comment
Question by:keplan
  • 2
3 Comments
 
LVL 44

Assisted Solution

by:Rainer Jeschor
Rainer Jeschor earned 500 total points
Comment Utility
Hi,

yes, there are two possible areas to specify that:
When you try to process the cube through BIDS deployment and process, then you have to modify the property "ErrorConfiguration" on each (!) dimension and configure your expected behavior (e.g. discard records, map to unknown ...).

If you process the cube through SQL Server Management Studio, you can set the same options for the whole process (Process Database/Cube -> button "Change Settings" -> Tab "Dimension Key error")

HTH
Rainer
0
 

Accepted Solution

by:
keplan earned 0 total points
Comment Utility
Hi,

I did that, however, when I process the entire cube, it is givin me so many dimension_key not found error. However  I've dimension keys on the dim table. Both fact and dim table.
Why this behavior?

Just to more details about my structure, I've one dimension shared by many fact table. In a confirm dimension.

Is this the reason.

Thanks for any answer.
0
 

Author Closing Comment

by:keplan
Comment Utility
gh
0

Featured Post

What is SQL Server and how does it work?

The purpose of this paper is to provide you background on SQL Server. It’s your self-study guide for learning fundamentals. It includes both the history of SQL and its technical basics. Concepts and definitions will form the solid foundation of your future DBA expertise.

Join & Write a Comment

Naughty Me. While I was changing the database name from DB1 to DB_PROD1 (yep it's not real database name ^v^), I changed the database name and notified my application fellows that I did it. They turn on the application, and everything is working. A …
How to leverage one TLS certificate to encrypt Microsoft SQL traffic and Remote Desktop Services, versus creating multiple tickets for the same server.
Here's a very brief overview of the methods PRTG Network Monitor (https://www.paessler.com/prtg) offers for monitoring bandwidth, to help you decide which methods you´d like to investigate in more detail.  The methods are covered in more detail in o…
This video shows how to remove a single email address from the Outlook 2010 Auto Suggestion memory. NOTE: For Outlook 2016 and 2013 perform the exact same steps. Open a new email: Click the New email button in Outlook. Start typing the address: …

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

16 Experts available now in Live!

Get 1:1 Help Now