Independent Table Refresh

[akash0800]

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

[lbendlin · Accepted solution]

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

Try updating the Date table rather than the ABC table.