Oracle has provided the default scripts to create the TIME tables needed for Usage Tracking. These scripts comes along with the installation and are located on the server on which the BI server resides.
Path to Scripts
Middleware\instances\instance2\bifoundation\OracleBIServerComponent\coreapplication_obis1\sample\usagetracking\SQL_Server_Time
Oracle has provided files for different databases which includes Oracle,Teradata,SQL and DB 2. Considering Oracle as our database run the following scripts on the DEV_BIPLATFORM in order.
Scripts for an Oracle Database:
Oracle_create_nQ_Calendar.sql
Oracle _create_nQ_Clock.sql
Oracle _nQ_Calendar.sql
Oracle _nQ_Clock.sql
The first two scripts will each create a table (S_ETL_DAY and S_ETL_TIME_DAY) and then the final two scripts will perform a number of insert SQL statements to populate them.
Path to Scripts
Middleware\instances\instance2\bifoundation\OracleBIServerComponent\coreapplication_obis1\sample\usagetracking\SQL_Server_Time
Oracle has provided files for different databases which includes Oracle,Teradata,SQL and DB 2. Considering Oracle as our database run the following scripts on the DEV_BIPLATFORM in order.
Scripts for an Oracle Database:
Oracle_create_nQ_Calendar.sql
Oracle _create_nQ_Clock.sql
Oracle _nQ_Calendar.sql
Oracle _nQ_Clock.sql
The first two scripts will each create a table (S_ETL_DAY and S_ETL_TIME_DAY) and then the final two scripts will perform a number of insert SQL statements to populate them.
No comments:
Post a Comment