Solved

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

Posted on 2013-01-16
3
734 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
ID: 38789244
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
ID: 38791954
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
ID: 39767521
gh
0

Featured Post

Best Practices: Disaster Recovery Testing

Besides backup, any IT division should have a disaster recovery plan. You will find a few tips below relating to the development of such a plan and to what issues one should pay special attention in the course of backup planning.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

If you have heard of RFC822 date formats, they can be quite a challenge in SQL Server. RFC822 is an Internet standard format for email message headers, including all dates within those headers. The RFC822 protocols are available in detail at:   ht…
Occasionally there is a need to clean table columns, especially if you have inherited legacy data. There are obviously many ways to accomplish that, including elaborate UPDATE queries with anywhere from one to numerous REPLACE functions (even within…
This Micro Tutorial will give you a basic overview how to record your screen with Microsoft Expression Encoder. This program is still free and open for the public to download. This will be demonstrated using Microsoft Expression Encoder 4.
This tutorial gives a high-level tour of the interface of Marketo (a marketing automation tool to help businesses track and engage prospective customers and drive them to purchase). You will see the main areas including Marketing Activities, Design …

813 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

9 Experts available now in Live!

Get 1:1 Help Now