The attribute key cannot be found when processing

Question

Post reply

The attribute key cannot be found when processing

Viewing 2 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply

Site Owners SSC Guru Points: 80412 More actions · Answer 1

Thanks for posting your issue and hopefully someone will answer soon.

This is an automated bump to increase visibility of your question.

Ed B Hall of Fame Points: 3690 More actions · Answer 2

First question, did you process full on the dimension containing the error? I don't remember if you can process updaate a partition, but I did read something about process updates only adding data and not removing data that nolonger exist.

The error message in your post refers to a different partition (2021) than the error message in the attached image (2024). I know SSAS does it's best to trick you by raising hundreds of messages saying "an error was found while processing x" and then you have to look for the preceding warning to find that actual error, but is it possible you fixed one error and found another?

You said you can see the missing dimension member in the view, after processing update can you browse the dimension and see the missing member? Does the dimension read all the data from the view or is there a query that might suppress some rows? e.g. SELECT * FROM dim.vwCustomers WHERE CurrentStatus = 1. Are you any good at MDX? (I am not), but sometimes the easiest way to check the presence of a dimension member is to run an mdx query where you can include the surrogate key that may not be visible in the cube.

Is your goal to get zero errors or get the cube processed and then solve the errors? The message says the missing key way converted to the unknown member. You should have the option of allowing this to continue without causing failure. Some people prefer to allow the unknown member to be used and not fail the cube, we usually assign a default dimension key to early arriving facts, but both are valid options and if the cube fails at night we set it to ignore unknown members and fix it the next day. If you have to, can you do a full process of the dimensions and then start by processing the problematic partitions? I realise this is a nightmare if the full cube takes many hours to process, but sometimes the cube demands a full process, or so it seems.