Analytics (with PAI 3.1.2.0) > Administration > Specify Additional Tables to Copy from Servigistics
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
3. Commit the changes to the IPCS_ANALYTICS_CUSTOM_TABLE_INFO table.
4. Run the corresponding AutoPilot processes.
Was this helpful?