The relationship doesn't hold any data because it needs to be recalculated

[Anonymous]

Hi,

I've made some changes in the cube connections both in the test and in production.

The test report does work, but production give me an error:

"The expression referenced a relationship between 'Sales'[EntryDateKey] and 'Calendar Entry Date'[DateKey],
which does not hold any data because it needs to be recalculated."

I have the same reports for both environments. I have no idea, what can be the reasone and how to resolve it?

Thanks

[technolog · Accepted solution]

@priyanka_2304 

You need to open SMSS, connect to the desired database via XMLA and click "Process Database". After completing this operation, everything will work.

[v-chuncz-msft]

@Anonymous,

You might need to check the relationship between the two tables.

[Anonymous]

Thank you for your answer, but, that was the only issue with the process i should made. After the processing the problem disappeared.

[priyanka_2304]

Hi, I am facing the same issue and was wondering if you could clear on what do you mean by the line:
"the only issue with the process i should made. After the processing the problem disappeared." 

Thanks in advance.