Cube Management

Options to connect to Cubes In order of most-secure, to least-secure. 1. Macros VBA Office Bridge files use and allow Macros to run in Excel via the Microsoft Trust Center options. It is the default method for viewing and using Catalyst enabled cube files. These files end in the .xlsm file forma...

How Often Does the Cube Update? The Cube draws data out of various systems on a scheduled basis. There is also an Administrative Tool that allows for the manual processing of the cube as needed. What is a Pivot Table? A pivot table is a data summarization tool that can automatically sort, count, ...

You may encounter a myriad of error messages when using Microsoft Excel, but rest assured we've likely seen it before.  Many errors occur due to an issue with the cube attempting to open or refresh, so if the instructions in each link below do not resolve the issue, try restarting your computer a...

Connection issues with Microsoft Office are sometimes inevitable but many errors can be resolved using the Catalyst Cube Updater, which is found at the bottom of the Analysis tab. Resetting the EBM Connection in your File If you encounter a Microsoft based error message while working in your EBMO...

Sometimes you may run into issues when building or viewing reports connected to Catalyst that show incorrect, missing, negative, or doubled amounts. There are many reasons data may not appear in your Excel cube file, when you believe it should exist. Some of those reasons are highlighted below, a...

This article contains the following topics: Overview Data types Exporting and uploading steps Detailed tutorial   Overview Catalyst offers the ability for us to feed data from your ERP(s) into the application automatically through automated integrations, but we also allow you to manually load ...

When a file is reused, saved and shared, stored in a cloud service like Dropbox, SharePoint, or OneDrive, or if cube connections are pasted or copied, the file may become stale or unusable. Oftentimes a file can become usable after fixing its cube connections and queries.   This articles cont...

Optimizing Excel files is vital for avoiding common issues like file breakages or size limitations. Recognizing stale, corrupt, or degraded files involves identifying conditions such as extensive data rows, numerous external connections, and prolonged existence without updates. Best practices in...

If you have an account that you know exists but cannot seem to locate it within your Excel cube, there's no need to worry. This guide will help you understand the possible reasons behind this issue and how to resolve it. Question "I have an account that I know exists, but I cannot see it in th...

Refreshing cubes in Excel is essential to ensure that your data is up-to-date and accurate. Whether you prefer a streamlined approach through the EBM Office Bridge Ribbon, navigating the Data tab for Queries and Connections, or simply right-clicking into the pivot table, there are multiple ways...

Note: Updated as of 6/1/22. For the change notes and full description on Microsoft.com follow this link. To skip to what you should do about it, click here. This article contains the following topics: What's changing with macros What these changes mean Who it impacts Who it doesn't impact What y...

EBM is migrating to new infrastructure using Microsoft Azure. This means all client websites are moving to the new environment. We'll help migrate your files to ensure they're connected correctly, but if you want to get ahead, you can start the process yourself. Important Note: The Cube Migrato...

Online Analytical Processing (OLAP) is a technology that is used to organize large business databases and support business intelligence. More simply, in Excel you can convert your EBM cube to OLAP formulas in order to format tables in a way that's more customized than a standard pivot table and c...

Large and complex Excel files can sometimes encounter performance issues due to inherent limitations within Microsoft Excel. This article aims to provide step-by-step guidance on optimizing such files for better performance and usability. This article contains the following topics: Common iss...

Microsoft Excel offers a password protection feature that allows users to secure their workbooks by restricting access to the file's contents. However, this functionality poses significant limitations when used in conjunction with external data connections, such as those used in our systems. ...