The database schemas describe the database tables and the relations among them. Using the database schemas, you can plan for the size of the database.
The information in the Historical database schemas helps you understand the mapping between the imported business measures model and the database tables. The dashboards use the Historical database for multidimensional analysis and generating reports.
insert into <your WBI schema name>.dim_time( surrogate_key, year, month, day) with WBITIME (skey, ldate) as (select surrogate_key+1 as skey, COALESCE( DATE(SUBSTR(DIGITS(YEAR),7,4) || '-' || SUBSTR(DIGITS(MONTH),4,2) || '-' || SUBSTR(DIGITS(DAY), 4,2)) + 1 DAYS, DATE('YYYY-MM-DD of the first day you'd want to start from, in case the DIM_TIME table is empty.') )as ldate from sysibm.sysdummy1, <your WBI schema name>.dim_time where DATE( SUBSTR(DIGITS(YEAR) ,7,4) || '-' || SUBSTR(DIGITS(MONTH),4,2) || '-' || SUBSTR(DIGITS(DAY) ,4,2) ) = ( SELECT MAX( DATE(SUBSTR(DIGITS(YEAR),7,4) || '-' || SUBSTR(DIGITS(MONTH),4,2) || '-' || SUBSTR(DIGITS(DAY), 4,2))) FROM <your WBI schema name>.DIM_TIME ) UNION ALL SELECT parent.skey+1, ldate + 1 DAYS from WBITIME parent where YEAR(ldate + 1 days) < where YEAR(ldate + 1 days) < <YYYY 4 Digit YEAR FOR WHICH YOU DON't WANT DATA to end in> ) select a.skey, year(a.ldate), month(a.ldate), day(a.ldate) from WBITIME a WHERE a.ldate >= DATE('YYYY-MM-DD: The start of the range that should be inserted.') AND a.ldate <= DATE('YYYY-MM-DD: The end of the range that should be inserted.')