Specify Additional Tables to Copy from Servigistics
The copy of data from Servigistics to PAI includes data from many tables in Servigistics. In addition to the standard data extracts provided, you can specify additional tables to be copied, and then create reports and dashboards using that data.
Use these instructions to specify the additional tables for copying data from Servigistics to PAI.
1. Use SQL to populate the IPCS_ANALYTICS_CUSTOM_TABLE_INFO table on the server where Servigistics was installed. This table contains the information about the additional tables to be included in the copy of data from Servigistics to PAI when the AutoPilot processes run.
2. Add a row to the table for each table to be included in the copy of data. The layout of the table is as follows:
|
Column
|
Description
|
||
|---|---|---|---|
|
AnalyticsCustomTableInfoId
|
A unique numeric identifier for the record.
|
||
|
TableName
|
The name of the table to be included in the copy of historical data.
|
||
|
AnalyticsCategory
|
The AutoPilot job that is run for the type of data in the table. Valid entries are:
• GENERAL — General data to be archived by the General Analytics Data Loader AutoPilot process
• FORECAST — Forecast related data to be archived by the Forecast Analytics Generator AutoPilot process
• PLAN — Planning related data to be archived by the Planning Analytics Generator AutoPilot process
|
||
|
StorageType
|
The method of storing the data. Valid entries are:
• FLUSH_FILL — All data is deleted from the PAI table before loading new data
• SLICE — Data is archived based upon the current slice. If records already exist in the PAI table for the current slice, those records are deleted before loading the data
• DAY — Data is archived based upon the current date. If records already exist in the PAI table for the current date, those records are deleted before loading the data
|
||
|
disabled
|
An indicator of whether the table is not to be included in the archiving of data. Valid entries are:
• n — Indicates that the copy of data for this table is not disabled. Tables with disabled = n are included in the copy of historical data from Servigistics to PAI
• y — Indicates that the copy of data for this table is disabled. Tables with disabled = y are not included in the copy of historical data from Servigistics to PAI
|
||
|
OracleConstraintMode
|
The method for handling a constraint before inserting data into a table. Valid entries are:
• DROP – Primary Key constraint is dropped before inserting data, and the constraint is recreated after inserting data
• LEAVE – Primary Key constraint is not dropped before inserting data
• null – Defaults to LEAVE when the StorageType is either SLICE or DAY
|
3. Commit the changes to the IPCS_ANALYTICS_CUSTOM_TABLE_INFO table.
4. Run the corresponding AutoPilot processes.