BeyondERP.Newsletter
Menu

Page · System administration

Tile data cache

An inquiry page that lists the workspace tiles held in the data cache, with the time each was last updated, its filter values and its current value.

Used by
Information technology manager
Business process
Administer system features
Menu item
TileDataCache
Main table
SysDataCacheContextTable
Setup steps
1 on this page
Show what matters for
PAGE GUIDEWhat the page does and how to use it8 sections. Choose a role to highlight what matters to you.
Everyone

1What it is and why

What it isAn inquiry page that lists the workspace tiles held in the data cache, with the time each was last updated, its filter values and its current value.
What you do hereUse this page to see when each tile in the data cache was last updated and what value it holds.
ExampleFor example, a count tile whose query runs in less than 250 ms can be refreshed every 10 minutes, so the Last update of its entry here is never more than 10 minutes old.
Tile data cache page in Dynamics 365
The page in Dynamics 365. page title tab to open what to set or check
Functional consultant · Solution architect

2Where it fits

Business processAdminister system features
Menu pathSystem administration › Inquiries › Data cache › Tile data cache
Set up firstTile data cache configuration Microsoft Learn
Used next byData cache parameters Microsoft Learn
Related pagesSystem administration workspace Microsoft Learn
End user · Functional consultant

3How to do it

About the examples: Examples and screenshots in this guide use BEAT, a demo company in a Dynamics 365 test environment. Use your own company's codes and values instead of copying them.

Setup steps on this page

Check how fresh the tile cache is

Use this page to see when each cached tile was last refreshed and which value it holds.

Steps from Microsoft

  1. Go to System administration > Inquiries > Data cache > Tile data cache.
  2. Use the Filter box to find the tile you are checking.
  3. Read Last update to see when the cached value was refreshed, and Filter values to see which filter it was cached for.
  4. Compare Value with what the workspace shows; to change how often entries refresh, open Tile data cache configuration.

Source: Microsoft Learn

Fields on the page

FieldWhat it meansExample
TileThe workspace tile whose count is cached.Checked in Dynamics 365
Last updateWhen the cached entry was last refreshed.Checked in Dynamics 365Today at 09:40
Filter valuesThe filter values the entry was cached for, such as a workspace filter.Checked in Dynamics 365
ValueThe cached result that the workspace shows.Checked in Dynamics 365

Common errors and fixes

MessageWhat to do
A workspace shows an out-of-date tileThe value comes from the cache and is refreshed only at the cache's refresh frequency. Check Last update here, and shorten the refresh frequency on Tile data cache configuration only where the query is fast enough. Microsoft Learn

Test checklist

  1. Open a workspace that uses the cache and note the value it shows.
  2. Open Tile data cache and find the matching entry.
  3. Check that Value matches the workspace and that Last update is within the refresh frequency.
  4. Change the underlying data, wait for the refresh frequency to pass, and check that Last update and Value change.

Source: Microsoft Learn

Functional consultant

4Setup decisions

Setup stepRecommended value and whyDecision, common mistake and test
Check how fresh the tile cache isCheck Last update against the tile's refresh frequency (5 seconds, 10 minutes or 24 hours) before you treat a tile count as wrongWorkspace data comes from a cache that is refreshed at a set frequency, so a value can be older than the source data by up to that interval.How fresh must the tile data be?Reading an old count as an error. Count tiles are cached automatically and refresh only at their frequency.Test: The cached value refreshes within the refresh frequency

Feature management and licence

Licence or add-inOn this system the page opens for Information technology manager. Administrators use it to check how fresh workspace data is. No Feature management feature needs to be turned on for this page.

Microsoft Learn

Solution architect

5Design impact

Shared or per companyShared: the same records are used by every legal entity. Microsoft data model
Can it be undoneReversible: The inquiry changes no data. Microsoft Learn
If you change it laterReading the cache changes nothing. How often entries are refreshed is set by the cache's refresh frequency, which administrators can change at run time on the cache configuration pages. Microsoft Learn
Technical architect

6Technical

Menu itemTileDataCache Checked in Dynamics 365
FormSysDataCache Checked in Dynamics 365
TableSysDataCacheContextTableShown as “Cache context” in Record infoChecked in Dynamics 365
Who can open itPrivilegesData cache inquiry SysDataCacheInquiryDutiesMaintain system settings SysServerSettingsMaintain
1 security roleInformation technology manager SysServerITManager
Checked in Dynamics 365
Roles to set it up and use itTo use itInformation technology manager SysServerITManagerGive people one of these roles. On this system, 1 role can open this page.Checked in Dynamics 365
Actions on the pageOptions: Personalize, Page options, ShareChecked in Dynamics 365
Developer

7Developer

Open it by URLhttps://<your-environment>/?mi=TileDataCache
Data migrationLoad order: Tile data cache has no data entity in Data management, so it can't be loaded from a file or a configuration template. The cache is rebuilt by the system from the source data in each environment, so there is nothing to move.Checked in Dynamics 365
Table definitionSysDataCacheContextTable columns and relations Microsoft data model
Everyone

8Sources