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

i know design problem. 've read there workaround issue customising errors @ processing time not glad have ignore errors, cube process scheduled ignore errors not choice @ least one.

this part of cube error thrown.

dimtime

• pk (int)
• mymonth (int, example = 201501, 201502, 201503, etc.)
• another columns

factbudget

• pk (int)
• month (int, example = 201501, 201502, 201503, etc.)
• another columns...

the relation in dsv set follows.

dimtiempo = dimtime, factpresupuesto=factbudget, periodo = mymonth, periodopresupfk = month translated understanding.

the relationship in cube follows:

the cube built without problem, when processing errror: the attribute key cannot found when processing thrown.

it thrown due factbudget has month values (201510, 201511, 201512 in example) dimtime don't, integrity broken.

as mentioned in answer here can solved @ etl process. think can nothing relationship if 1 fact table has foreign keys has not been inserted in dimensions.

note mymonth can values 201501, 201502, 201503 etc. set year , month concatenated, dimtime incremental inserted , every day calculated column in moment dimtime don't have values 201507 onwards.

is there workaround or pattern handle kind of relationships?

thanks considering question.

is there reason why you're incrementally populating dimtime? it isn't standard way it. need values you're using in fact exist in dimensions. script full set of data dimtime , stop incremental updates of it.