Hello and thank you for any help on this question.  I am somewhat new to MDX, Cubes and sorts, but have found an issue that I can not find a work around.

I have a large excel workbook that connects to a data cube.  Within this workbook, I use about 8 MDX queries to bring back date related data such as, Yesterday, MTD, Previous Month ect.  This has worked great until now.  On refresh, I am receiving an error stating the "Organization of the OLAP Cube has changed and as a result a pivot table will not update".  I have identified that what is happening is that all of my MDX queries are missing.  They still show in the field list in the rows section, but they seem to be removed from the data connection.  I can not recreate the MDX queries as it says that the name is not unique.  Any help on this error?

EXHORTER

Hi,

Was there any changes on your data source side, like data structure, DB server name, etc.. Make sure your connection

string to the right server and right cube.

You can refer this thread and this article for some ideas. Thank you.