CUBE Process change settings

Question

Hi,

I'm trying to change the settings on a CUBE. Right click on the CUBE select PROCESS and click on CHANGE SETTINGS and click on DIMENSION KEY ERRORS and selected 'Use Custom Error Configuration' and for the "Key Not found" option i changed it to "Ignore Error".

The problem is the changes i made are not saved, how can i save these changes?

Thanks

---

bhargav kandala

Answer 1

You can change the KeyNotFound property in the dimension's ErrorConfiguration to  IgnoreError if you want the settings to persist

hth

---

-Remember to mark as helpful/the answer if you agree with the post.

Answer 2

Thanks Naveen but no luck, its still reverting back to "Report and Continue" option.

---

bhargav kandala

Answer 3

I'm sorry if I wan't clear, you have to find the dimension that causes those errors and make those changes in the dimension definition itself. Then you don't have to change settings when processing. It will be done internally within the dimension(s)

---

-Remember to mark as helpful/the answer if you agree with the post.

Answer 4

I'm still not understanding Naveen. Sorry i'm new to SSAS. The main problem is when the nightly job failed i looked at the log and it said Attribute key not found when CUBE processing, so i went into the CUBE process and changed the settings from Report and continue to Ignore Errors. But the changes that i made are not saved, so how can i acheive it?

Thanks

---

bhargav kandala

Answer 5

Ok - a few things here you should know

a) If the job failed due to a key that was not found, it means that there are some fact records that do not have a corresponding key value in one or more dimensions. Probably not a good idea to ignore such errors. Look at the details in the log to see what dimension and value it failed on. Maybe you have to process the dimension before you process the cube

b) The IgnoreError property is in the dimension definition, so you will need to open it in BIDS and make the changes to the dimension that is causing the issue. Again, this is not advisable in a production cube, as this could result in wrong data being reported.

---

-Remember to mark as helpful/the answer if you agree with the post.

Answer 6

Thanks Naveen, where is the log file located? and how do i get to it, to see which dimensions and what keys are missing?

Thanks

---

bhargav kandala

Answer 7

Hi thinkingeye,

You could specify the error log path remaining on the "Dimension Key errors" tab of Change Settings window. If it was not specified there, you can go to the analysis services instance folder and then OLAP->Log->msmdsrv.log file where the error logs were stored.

Regards,
Jerry

Answer 8

Thanks Jerry,

" If it was not specified there, you can go to the analysis services instance folder ", can you please tell me the path or where i can find this analysis services instance folder?

---

bhargav kandala