BeyondERP.Newsletter
Menu

Setup step on the Date dimensions page · Organization administration

Set up Date dimensions

Use this page to keep the date range current so that date-based reports keep showing data.

Used by
Information technology manager
Business process
Administer system features
Menu item
BICalendarBuilder
Main table
BIDateDimension
Setup steps
1 on this page
Show what matters for
SETUP GUIDEHow to set it up8 sections. Choose a role to highlight what matters to you.
Everyone

1What it is and why

What it isA setup page where you define the date dimension and its date range, which date-based analytics such as the cash flow Power BI reports rely on.
What you do hereUse this page to keep the date range current so that date-based reports keep showing data.
Date dimensions 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 pathOrganization administration › Setup › Calendars › Date dimensions
Used next byCash overview Power BI reports Microsoft Learn
In this process Set up Data cache parameters · Set up Tile data cache configuration
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 Date dimensions1 screen

Use this page to keep the date range current so that date-based reports keep showing data.

  1. Screen 1

    Check the date dimension

    Go to Organization administration > Setup > Calendars > Date dimensions

    1. Select the date dimension in the list
    2. Check the date range it covers and the month the year starts
    3. Check the first day of the week used by reports
    1NameDate
    3Start date1/1/2016
    4End date12/31/2031
    5From monthJanuary
    6First day of weekSunday
    Check the date dimension (zoomed on the outlined fields)
    Show the full screenCheck the date dimension
    page title tab to open what to set or check

How to use it

  1. Go to Organization administration > Setup > Calendars > Date dimensions.
  2. Select Date in the list on the left.
  3. Select Edit.
  4. Under Calendar dates, change the Start date and End date.
  5. Choose the From month and First day of week.
  6. Select Close.

Source: Checked in Dynamics 365

Fields on the page

FieldWhat it meansExampleTable column
End dateThe last date of the date range. Make sure it extends into the future.Microsoft Learn 12/31/2031EndDate
NameThe name of the date dimension.Microsoft data model DateName
Start date1/1/2016StartDate
From monthJanuary
First day of weekSundayFirstDayOfWeek

Test checklist

  1. Check the End date is at least a year after today.
  2. Run Calculate cash flow forecasts for the company.
  3. Refresh the LedgerCovLiquidityMeasurementV2 aggregate measurement on Entity store.
  4. Open the Cash overview workspace and check future inflows and outflows appear.

Source: Microsoft Learn

Functional consultant

4Setup decisions

Setup stepRecommended value and whyDecision, common mistake and test
Set up Date dimensionsA date range whose End date reaches well into the futureMicrosoft's checklist for an empty or incomplete cash flow Power BI report includes making sure the date dimension's End date extends into the future.Letting the End date fall behind today. Cash flow Power BI views then don't show all data or appear empty.
Solution architect

5Design impact

Shared or per companyShared: the same records are used by every legal entity. Microsoft data model
Can it be undoneReversible: Extend the date range at any time; refresh the Entity store measurements afterwards.
Technical architect

6Technical

Menu itemBICalendarBuilder Checked in Dynamics 365
FormBICalendarBuilder Checked in Dynamics 365
TableBIDateDimensionShown as “Time dimension” in Record infoChecked in Dynamics 365
Who can open itPrivilegesMaintain Gregorian calendars BIGregorianCalendarsMaintainDutiesMaintain the calendars that are used for business intelligence BICalendarsMaintain
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=BICalendarBuilder
Table definitionBIDateDimension columns and relations Microsoft data model
Everyone

8Sources

To cite this step: OA-SETUP-300, Set up Date dimensions. Beyond ERP Atlas Hub, 2026-11-11. https://www.beyonderp.cloud/atlas/step/OA-SETUP-300