BeyondERP.Newsletter
Menu

Setup page · System administration

KPI detail data cache configuration

A setup page that lists the cached detail data of key performance indicators (KPIs), one row per item, with its refresh frequency and switches.

Used by
Information technology manager
Business process
Administer system features
Menu item
KPIDetailDataCacheConfiguration
Main table
SysDataCacheConfigurationTable
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 isA setup page that lists the cached detail data of key performance indicators (KPIs), one row per item, with its refresh frequency and switches.
What you do hereUse this page to review and change, for each item, its refresh frequency, whether it is enabled, and whether filtering and manual refresh are allowed, and to enable or disable all of them at once.
ExampleFor example, if the detail data behind a BEAT KPI is refreshed every 10 minutes while the KPI value refreshes daily, the two can differ during the day; an administrator aligns the frequencies on this page and KPI cache configuration.
KPI detail data cache configuration 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 › Setup › Data cache › KPI detail data cache configuration
Set up firstKPI cache configuration Microsoft Learn
Used next byKPI detail data cache Microsoft Learn
Related pagesData cache parameters 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.

Step by step, with screenshots

Set up KPI detail data cache configuration1 screen
  1. Screen 1

    Review the KPI detail data cache configuration

    Go to System administration > Setup > Data cache > KPI detail data cache configuration

    1. Find the KPI detail in the list when one is cached
    2. Review whether it is enabled and how often it refreshes
    3. Select Edit to change the refresh frequency, then select Save
    Review the KPI detail data cache configuration (zoomed on the outlined fields)
    Show the full screenReview the KPI detail data cache configuration
    page title tab to open what to set or check

How to use it

  1. Go to System administration > Setup > Data cache > KPI detail data cache configuration.
  2. Use the Filter box to find an item in the Consumer column.
  3. Select Edit, then change Enabled, Refresh frequency, Filtering enabled or Manual refresh for the item.
  4. Select Enable all or Disable all to change all the items at once.
  5. Select Delete to remove a selected record.

Source: Checked in Dynamics 365

Fields on the page

FieldWhat it meansExample
Refresh frequencyHow often the cached detail data is refreshed; the administrator can change it at run time.Microsoft Learn 10 minutes
EnabledWhen cleared, the item's cached data isn't updated.Checked in Dynamics 365

Common errors and fixes

MessageWhat to do
KPI details don't match the KPI valueCompare the refresh frequencies on this page and on KPI cache configuration, and align them. Checked in Dynamics 365

Test checklist

  1. Find the item in the Consumer column.
  2. Select Edit and set its Refresh frequency.
  3. Change data behind the KPI.
  4. Check the detail data after the refresh interval.

Source: Microsoft Learn

Functional consultant

4Setup decisions

Setup stepRecommended value and whyDecision, common mistake and test
Set up KPI detail data cache configurationGive KPI detail data the same refresh frequency as its KPI, chosen from the query time as Microsoft advises for cached tilesMatching frequencies keeps the details consistent with the KPI value, and Microsoft ties frequency to query time to avoid load.How often should each cached KPI detail item refresh?Leaving detail data on a much faster refresh than its KPI: the details and the value then differ for most of the day.Test: Cached KPI detail item follows its refresh frequency

Feature management and licence

Licence or add-inOn this system the page opens for Information technology manager. 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: Enabled and the refresh frequency can be changed at any time. Checked in Dynamics 365
If you change it laterCached detail data shows data as of its last refresh, so its refresh frequency decides how current the details are; the administrator can change it at run time. Microsoft Learn
Technical architect

6Technical

Menu itemKPIDetailDataCacheConfiguration Checked in Dynamics 365
FormSysDataCacheConfiguration Checked in Dynamics 365
TableSysDataCacheConfigurationTableShown as “Data cache configuration” in Record infoChecked in Dynamics 365
Who can open itPrivileges SysDataCacheConfigurationDutiesMaintain system settings SysServerSettingsMaintain
1 security roleInformation technology manager SysServerITManager
Checked in Dynamics 365
Roles to set it up and use itTo set it up or change 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=KPIDetailDataCacheConfiguration
Data migrationLoad order: KPI detail data cache configuration has no data entity in Data management, so it can't be loaded from a file or a configuration template. Change refresh settings by hand in each environment.Checked in Dynamics 365
Table definitionSysDataCacheConfigurationTable columns and relations Microsoft data model
Everyone

8Sources