Business calendar is used automatically in a data mart for every date field, to find out, into which business/fiscal week, month, quarter and year the date belongs. Such new dimensional fields (like month, year, …) are then used for filtering and aggregation of the data of data-mart.
This cal data source table exists out-of-the-box, and you cannot modify its fields. By configuration here we mean, that you populate the table with the records, which will drive the dates conversion.
In this article you will create the calendar conversion data using a built-in process, which generates conversion based on Gregorian calendar. If you need your own special business/fiscal conversions, you simply need to upload the data into the cal data source.
Once the calendar is populated, it can look in the application like this
Generate the data
Navigate to
Find the data load with Target: DMDS.cal and Type: Calendar
Click on the Label of the data load to open its detail
Start the data load by click on Run Data Load. The data load will be scheduled for execution. It is usually in Pending state about 1 minute before it’s executed. Use the refresh of the Job/Task Tracking to see, if the job has started and finished.
Wait until the job gets to Ready state. The process of calendar data creation itself is really quick, so it shouldn’t take more than 1 minute altogether.
Review the generated calendar
Navigate to
Click on the data source’s Label Calendar to open its detail.
Click on the tab Data to see the content of the data source
Review the data generated, how each day/date is mapped to specific week, quarter and fiscal year. The actual content (spread of dates) will depend on the date when you generate them.