Business calendar is used automatically in a data mart Datamarts for every date field , to find out, determine 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 Datamart data-mart.
This "cal data source " Data Source table exists out-of-the-box, and you cannot modify its fields. By configuration here we mean, Configuration means here 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 sourceData Source.
Once the calendar is populated, it can look in the application like this:
Generate
the dataData
Navigate to .
Find the data load Data Load with Target : DMDS.cal and Type : Calendar.
Click on the Label label of the data load Data Load to open its the detail.
Start the data load by click on Data Load by clicking Run Data Load. The data load Data Load will be scheduled for execution. It is usually in the Pending state for about 1 minute before it’s it is executed. Use the refresh of the Refresh in Job/Task Tracking to see , if the job has started and finished.
Wait until the job gets to the Ready state. The process of calendar data creation itself is really quick, so it shouldn’t should not take more than 1 minute altogether.
Review
the generated calendarGenerated Calendar
Navigate to .
Click on the data source’s Data Source Label Calendar to open its detail.
Click on the tab Data to see the content of the data sourceData Source.
Review the generated data generated, how each day/date is mapped to a specific week, quarter and fiscal year. The actual content (spread of dates) will depend on the date when you generate them.