Errors in Excel-based cube files are sometimes unavoidable, especially when switching environments, migrating cube types, or following Microsoft Office updates. The Catalyst Cube Updater, located in the Analysis tab of Catalyst, is a powerful self-service tool that can resolve many of these issues and improve overall file performance.
What the Cube Updater Can Do
The Cube Updater is more than just a connection reset. It can:
Fix common Microsoft Office-related cube errors that disrupt file functionality
Repoint your cube file to the correct server or instance when switching environments
Clear cached Excel connection data that can cause refresh failures or strange behavior
Support cube migrations (e.g., MDX to Tabular) by updating legacy files for compatibility
Serve as a key troubleshooting step after restarting your machine or closing Excel
Ensure your file is aligned with the latest Catalyst configurations
How to Use the Cube Updater
In Catalyst, click the Analysis tab on the left-hand side
Scroll to the bottom and select the Cube Update tile
In the Upload File section, select the cube-enabled Excel file you want to refresh
The system will process the file automatically. Once complete, you’ll see a status of Upload Success
Click the Download icon to retrieve your refreshed and updated cube file
Still Seeing Issues?
If the Cube Updater doesn’t resolve the issue, contact EBM Support so we can take a closer look. We're happy to assist.
Tip: If you're experiencing unexpected behavior in a cube file—such as Excel errors, missing filters, or refresh problems—restarting Excel and running the file through the Cube Updater is the best first step. It’s fast, easy, and often fixes the issue.
Comments
0 comments
Article is closed for comments.