After upgrading all custom MDX OLAP calculations within Cubes reports have disappeared
Description of Issue
Upgrading Cubes server and all custom MDX (OLAP) calculations within Cubes reports have disappeared once the new connection is established
Context
Cubes
Cause
Upgrading Cubes server
Resolution
This is an Excel / Microsoft issue:
Note: Because the Excel MDX Calculated Measure is used to create a session specific calculation for a SQL Server Analysis Services data source, your Calculated Measure will be limited to the session and the data source connection you used.
If a connection file needs to be changed (e.g. new server requires updating the connection file), it changes the data source so those MDX (OLAP calculations) would need to be recreated.
Additional Information