-
Cube Overview
What is a Data Cube? A data cube is a live window into your database/dataset via Excel that allows for fast and efficient analysis. The cube will enable consolidation or aggregation of data for which you can then drill down, slice and dice the data to analyze at different angles and levels of g...
Read more -
Diligent Cube Troubleshooting
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 ...
Read more -
How do I create a Trusted Location in Excel?
EBM Software applications require Excel to trust its connection to your Diligent website. With recent Microsoft Security Hardening, Excel now requires you to create a trusted location for all EBM-connected files, otherwise we can't guarantee your files will work as expected. If you encount...
Read more -
Accessing & Modifying Data Cubes
This article provides a few basic tips and tricks for getting starting using Diligent data cubes in Excel. This article contains the following topics: Data Cube Access Getting Started Sample Data Cut Builds How to Access a Cube: The cubes can be accessed/modified using vario...
Read more -
Cube Updater
Connection issues with Microsoft Office are sometimes inevitable but many errors can be resolved using the Diligent Cube Updater, which is found via the 'Analyze' tab in the Diligent user interface. Common Use Cases: You encounter a Microsoft based error message while working in the file You ref...
Read more -
How do I fix a stale or broken file?
Why isn't my file working? Most of our users do the majority of their work in Excel (as do we!), and with that comes a multitude of limitations. Files break or become too big, connections get old, updates aren't run, bugs exist -- and all of these occur regularly with Excel and Microsoft in gener...
Read more -
Macros and Security for Trusted Documents
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...
Read more