Rigid Relationship Error in SSAS Cube

hi all,

in our system whenever have restored data other server , processed cube throwing error saying 'rigid relationships between attributes changed during incremental processing of dimension'. 

this error occurs if there records in analysis server dimensions not there underlying database. doing redeployment of ssas cube.

to resolve issue redeploying cube , processing same. 

1. there other option resolve issue without redeploying cube?

2. , processing dimensions using "analysis service processing task" , using "parallel processing". causing issue rigid relationships?

regards,

sindhu

hi sindhu,

this problem occurs when have defined rigid relationship in dimension's attribute relationship. when processing dimension using incremental processing , attribute changes hierarchy.

for example,

we have rigid relationships defined under:

personid-->person-->department

when, during incremental processing, ssas finds out person in depaertment x, showing under department y, give error mentioned.

to rid of such errors in future, make sure define rigid relationships applicable. like, in above example, personid-->person can rigid relationship (as person have same id without fail), person-->department relation should flexible (a person might change department - though rarely, still can).

so while you're re-deploying cube, please make sure make these changes.

---

let me know if have more questions on this. please mark post answer if helps resolve question. - bhawesh

SQL Server  >  SQL Server Analysis Services