Calendar-dataset Works

Calendar-dataset

This is simple calendar dataset for analytics purposes.

The dataset consist of three persistent data classes:

• Days.cls
• Month.cls
• TimeTable.cls

And generator method that populates this classes

Days set consists of various date formats:

• ShortMonthName: Jan
• LongMonthName: January
• MonthYearNum: 197001
• MonthYear: Jan-1970
• MonthYearLong: January-1970
• WeekYearString: 1970-W1
• WeekYearNumeric: 1970-01
• Week: 01
• Years: 1970
• DayOfMonth: 1
• DayOfYear: 1
• DayName: Thursday
• MonthNumeric: 1
• FullDate: 1970-01-01 00:00:00
• MonthYearNumDay: 19700101

Month set consist of similar to days set dimensions except:

• Quarter: 1
• QuarterYear: Q1 1970

Time set consist of:

• FullTime: 00:00:00
• Hours: 0-24
• Munites: 0-59
• Seconds: 0-53
• HTimeStamp ($HOROLOG): 0-86399
• AmPmTimeStamp: 00:00:00AM/PM

How to use it:

You can build it as standalone app with docker compose

docker compose build --no-cache --progress=plain
docker compose up -d

Or (intendent method) install it with your package with IPM:

zpm "install calendar-dataset"

After installation run:

do ##class(data.generator).Generate()

And thats it! Three tables with date dimensions is ready to go!

(For additional parameters, such as a custom date range or preferred data sets, see the ClassMethod documentation.)