Clear Cache
NecAccess formulas use a caching system to improve performance when retrieving similar data from the Data Model. In addition to process data, the Add‑in also caches security settings defined in the SEI environment.
The Clear Cache feature lets you manually remove locally stored data so your Excel workbook always reflects the latest information from the connected source. This is especially helpful when outdated or inconsistent cache data affects report accuracy or performance.
When to clear the cache
- Making changes to views, dimensions, or security: Clear the cache to load the latest updates.
- Forcing a data refresh: ypass cached values and retrieve current data directly from the server.
- Seeing unexpected results: Reset the cache to eliminate inconsistencies in your reports.
Clear the cache
- In the Add-ins tab, select Clear Cache.
- Choose Cache Data Model Data or Cache Security Data.
- If you select Cache Data Model Data, choose a specific reference to clear or select All.
- (Optional) Select Reporting Tree to clear cached nodes used in Reporting Tree filters.
- (Optional) Select Refresh Excel Workbook to reload the sheet with the most recent data after clearing the cache.
- Click Ok.
Clear Cache options
| Option | What it does |
|---|---|
| Cached Data Model Data | Clears cached data associated with the selected data model reference. |
| Cached Security Data | Clears cached security information, including data model authorization and field‑level security settings. |
| Reporting Tree | Clears cached nodes used by Reporting Tree filters. |
| Refresh Excel Workbook | Refreshes the Excel workbook automatically after the cache is cleared. |
How Reporting Tree caching works
note
If you use the Reporting Tree:
- All filter nodes and groups share a common cache, and this cache refreshes automatically.
- A partial‑refresh caching layer improves performance, allowing formulas to recalculate faster without requiring a full structure refresh when only part of the hierarchy is needed.