Forum Discussion
The relationship doesn't hold any data because it needs to be recalculated
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
You need to open SMSS, connect to the desired database via XMLA and click "Process Database". After completing this operation, everything will work.
4 Replies
- v-chuncz-msft
Community Support
Anonymous,
You might need to check the relationship between the two tables.
- AnonymousNot applicable
Thank you for your answer, but, that was the only issue with the process i should made. After the processing the problem disappeared.
- priyanka_2304New Member
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.
- technolog
Super User
You need to open SMSS, connect to the desired database via XMLA and click "Process Database". After completing this operation, everything will work.