Forum Discussion

akash0800's avatar
akash0800
Helper I
2 years ago
Solved

Independent Table Refresh

Hi,

I am getting an error when refreshing an incident table through SSMS using XMLA.

Error : refesh failed due to table dependence. 

 

I have a Table ABC and a Date table is created using a Date column from ABC table. I am getting above error while refreshing the ABC table alone.

 

We feed last month data into database every month and the date table shows the dates until the last day of the month as per the uploaded data.

 

Example: we feed July data in Aug and Aug data in Sep.

 

Your suggestions and support will be of great help.

 

Thanks

Akash

  • That is working as designed, but usually the dependencies are refreshed automatically.  

     

    Try updating the Date table rather than the ABC table.

1 Reply

  • That is working as designed, but usually the dependencies are refreshed automatically.  

     

    Try updating the Date table rather than the ABC table.