cal - Business Calendar Conversion (Data Source)

The cal object represents a business/fiscal calendar used for analytical purposes.

It is used in Datamarts to convert a date into business/fiscal year, month, quarter and week.

The conversion can either match the Gregorian calendar or fit the company business calendar.

Fields

CalDate – (Date) Date to be converted.

CalWeek – (String) Name of week into which the CalDate belongs.

CalMonth – (String) Name of month into which the CalDate belongs.

CalQuarter – (String) Name of quarter into which the CalDate belongs.

CalYear – (String) Name of year into which the CalDate belongs.

Since 14.0 - Caribou Lou.

Admin users are not allowed to delete any of the default Data Sources created by the system out of the box. This change is related to the following list of Data Sources.

Name

Label

Name

Label

Customer

Customer

Product

Product

cal

Calendar

ccy

Currencies

uom

Unit of Measures

Found an issue in documentation? Write to us.

Â