Oracle Audio Technologies Retail Data Warehouse 13 User Manual
Page 21
Data Population
Database Installation Guide 13
Create Time in RDW
If more time data is needed, modify the parameters below for the new time period and
run the module again. To minimize the load time for adding additional time, enter only
the first year to be added as the response for the first year prompt in number 5.
1.
If RMS is not being used as the source of the time calendar, move on to step 2. After
running time extraction in RMS (see RMS Operations Guide volume 3 for details), FTP
time_454.txt, start_of_half_month.txt, and wkday.txt from RMS install directory to
the RDW directory <base_directory>/rdw13.0/install.
2.
Login to the RDW database server as the UNIX user rdw13dev. Verify the RETL
executable is in the path of your UNIX session by typing which rfx at the UNIX
prompt.
3.
Change directories to <base_directory>/rdw13.0/install.
4.
Verify the C compiler is in the path of your UNIX session and the C compiler is in
your UNIX library path. At the UNIX prompt, enter:
which cc
5.
Compile the module cr_time_454, cr_time_13 and cr_time_g with a standard ANSI C
compiler. At the UNIX prompt, enter:
cc –g –I. –o cr_time_454 c_utils.c cr_time_454.c
cc –g –I. –o cr_time_13 c_utils.c cr_time_13.c
cc –g –I. –o cr_time_g c_utils.c cr_time_g.c
6.
Execute the cr_time.ksh module. At the UNIX prompt enter:
cr_time.ksh
7.
This script prompts for the calendar type. Choose 1 for 454 time, 2 for 13 period time
and 3 for 454 with Gregorian time.
8.
At the prompt enter the 4-digit year for the beginning and ending of the time
calendar
:
Please enter first year to be loaded:
Please enter last year to be loaded:
Note:
To determine the beginning and ending fiscal year,
refer to the text file modified above. Verify all months or
periods are included in the text file for the first year; no
partial years are allowed.
One text file is generated in the install directory for each dimension table.
9.
At the UNIX prompt, for 454 time calendar or 13 period time calendar enter:
time_load.ksh
time_trnsfrm_load.ksh
10.
At the UNIX prompt, for 454 time with Gregorian time calendar enter
time_load.ksh
g_time_load.ksh
time_trnsfrm_load.ksh
g_time_trnsfrm_load.ksh
11.
Change directories on the UNIX server to <base_directory>/rdw13.0/log. Review
the log file that was created or modified.
12.
Change directories on the UNIX server to <base_directory>/rdw13.0/error. Review
the error files that were created for time_load and time_trnsfrm_load. Review also