BeyondERP.Newsletter
Menu

Page · System administration

KPI detail data cache

An inquiry page that lists the KPI detail data held in the data cache, with columns for the tile, the time of the last update, the filter values and the value.

Used by
Information technology manager
Business process
Administer system features
Menu item
KPIDetailDataCache
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 KPI detail data held in the data cache, with columns for the tile, the time of the last update, the filter values and the value.
What you do hereUse this page to see when the KPI detail data in the data cache was last updated and the value it holds.
ExampleFor example, when the figures behind a KPI in a workspace look stale, an administrator filters this page on the KPI's tile and compares Last update with the time the data changed.
KPI detail 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 › KPI detail data cache
Set up firstKPI detail 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 KPI detail cache is

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

Steps from Microsoft

  1. Go to System administration > Inquiries > Data cache > KPI detail data cache.
  2. Use the Filter box to find the KPI detail 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 KPI detail data cache configuration.

Source: Microsoft Learn

Fields on the page

FieldWhat it meansExample
TileThe tile whose KPI detail data 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 KPI detailThe 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 KPI detail 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 KPI detail 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 KPI detail cache isCheck Last update of the KPI's detail entry before you treat KPI figures 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 KPI detail data be?Changing the KPI calculation to fix figures that are only waiting for the next cache refresh.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 itemKPIDetailDataCache 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=KPIDetailDataCache
Data migrationLoad order: KPI detail 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