10 Oracle Airlines Data Model Utility Scripts

Calendar Population Scripts

The Calendar population scripts include the following packages:

• calendar_population_header.sql

• calendar_population_body.sql

Running these packages does the following:

1. Prepares necessary changes for the OADM_SYS schema.

2. Creates the Calendar_Population package that contains the following procedures:

   • RUN(in_setup_start_date, in_setup_no_years) is the main procedure to populate everything about calendar.

   • RBIW_Base_Time_Tables_ddl creates the base table needed to support multiple hierarchies: Business or Calendar.

   • RBIW_Populate_Time_Hier_Bsns(in_setup_start_date, in_setup_no_years) sets up the data in base table for the Business hierarchy as specified in setup or install section.

   • RBIW_Populate_Time_Hier_Clndr(in_setup_start_date, in_setup_no_years) sets up the data in base table for the Calendar hierarchy as specified in setup or install section.

   • RBIW_Time_hier_Star sets up the Time hierarchy reporting layer tables.

   • RBIW_Time_Views sets up the Time hierarchy reporting layer views, star and hybrid snowflake views.

   • RBIW_Populate_Time_Transform populates the Time transformation tables using the base Time tables or views created above. It populates transformation data for both hierarchies: Business and Calendar.

How to Populate Calendar Data

To populate calendar data:

1. Log in to OADM_SYS user.

2. Execute the following SQL statement:

   exec Calendar_Population.run(date,num_years);
   

   where, date is the start date with which you want to populate calendar data. It is of type CHAR and should be input in the format 'YYYY-MM-DD' (for example,'2005-05-18'). num_years is the number of years to populate calendar data, which should be INTEGER.