Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

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

  • 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.

4 Replies

  • v-chuncz-msft's avatar
    v-chuncz-msft
    Icon for Community Support rankCommunity Support

    Anonymous,

     

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

    • Anonymous's avatar
      Anonymous
      Not 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_2304's avatar
        priyanka_2304
        New 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.

  • 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.