KB485832: Calendar Builder Report

Description

Calendar Builder Report is an internal Strategy report. It creates Lookup tables in warehouse DB. It is automatically run by Strategy's Engine for the database connection, for which smart-time-attributes are created. The report automatically is available in below location. The Report is by default hidden and you can unhide it, if needed.
Location:  Project Builder/Reports/

Prerequisites

1. Data Engine version in project must be set to version 2021 or above.
2. Write-back privilege to Warehouse database.

Sql generated by Calendar Builder to create Pushdown tables 

• Before execution, Calendar builder report has templatename for each Table, which is like : MSTR<random_name>15M
• The Template name is converted to an actual dynamic name every time the report is run. For Example  MSTR<random_name>15M becomes MSTRHF0028MHQ1DCL00115M
• You may notice DROP TABLE MSTR<random_name>15M. This SQL is not executed on warehouse and calendar builder will not drop any tables created.
• Lookup tables are created with range of CurrentYear -2 and CurrentYear +1
• Sample list of Tables created in Warehouse DB:

1. MSTRHF0028MHQ4BML00GDAYOFWK
2. MSTRHF0028MHQ4CVL00HHROFDAY
3. MSTRHF0028MHQ3Y6L007DAY
4. MSTRHF0028MHQ41RL009WK
5. MSTRHF0028MHQ44JL00BMNTH
6. MSTRHF0028MHQ47EL00DQTR
7. MSTRHF0028MHQ4A7L00FYR
8. MSTRHF0028MHQ3LTL005HOUR
9. MSTRHF0028MHQ2V8L00330M
10. MSTRHF0028MHQ1DCL00115M

Related KB Articles:

• Manually Execute Calendar Builder Report
• Troubleshooting Calendar Builder Report
• Restrict write-back access of Calendar Builder Report
• Set Table prefix for Smart Time Lookup Table
• What are Smart Time Attributes