Migrating BIP Definitions Using ADS
PeopleSoft provides Application Data Set (ADS) definitions to migrate Business Intelligence Publisher definitions from one environment to another as a project file.
For information on using Data Set Designer and other functionality of data sets, see Lifecycle Management Guide.
The following definition types can be added to projects in Application Designer:
BIP Data Source Definitions
BIP File Definitions
BIP Report Definitions
BIP Template Definitions
If the data source for the BIP report is PS Query, Connected Query, or Composite Query, then the query, connected query, or composite query definition should also be included in the project.
Note: Because BI Publisher is based on managed objects, all updates to your data need to be performed using the PeopleSoft BI Publisher Pure Internet Architecture pages, PeopleSoft Application Designer, or BI Publisher PeopleCode APIs.
See Understanding Related Language Tables, PeopleSoft Pure Internet Architecture Fundamentals.
The following ADS definition tables can be used for migrating BIP Definitions.
|
ADS Definition |
Description |
|---|---|
|
BIP_DEFINITION |
Table for BIP definitions. |
|
BIP_TEMPLATE |
Table for BIP templates. |
|
BIP_DATA_SOURCE |
Table for BIP data sources. |
|
BIP_FILE_DEFINITION |
Table for BIP file definitions. |
The BIP_DEFINITION uses the following tables.
|
Table |
Description |
|---|---|
|
PSXPRPTDEFN |
Stores BIP Report Definitions. |
|
PSXPRPTDEFNDEL |
Stores BIP Report Definitions for report deletions. |
|
PSXPRPTDEFNLNG |
Stores BIP Report Definitions related language information. |
|
PSXPRPTOUTFMT |
Stores BIP Report output formats. |
|
PSXPRPTPROP |
Stores BIP Report properties. |
|
PSXPRPTSCOPEFLD |
Stores BIP Report burst security field mapping information. |
|
PSXPRPTSRCHKEYS |
Stores BIP Report Definition search keys. |
|
PSXPRPTTMPL |
Stores BIP Report template relationships. |
|
PSXPRPTTMPLCTRL |
Stores BIP Report template control tables. |
|
PSXPRPTVIEWER |
Stores BIP Report viewer tables. |
The BIP_TEMPLATE uses the following tables.
|
Table |
Description |
|---|---|
|
PSXPTMPLDEFN |
Stores BIP Template Definitions. |
|
PSXPTMPLDEFNDEL |
Stores BIP Template Definition for template deletions. |
|
PSXPTMPLDEFNLNG |
Stores BIP Template Definition related language information. |
|
PSXPTMPLFILEDEF |
Stores BIP Template file definitions. |
|
PSXPTMPLTRINFO |
Stores BIP Template translation information. |
The BIP_DATA_SOURCE uses the following tables.
|
Table |
Description |
|---|---|
|
PSXPDATASRC |
Stores BIP Data Source definitions. |
|
PSXPDATASRCDEL |
Stores BIP Data Source deletions. |
|
PSXPDATASRCLNG |
Stores BIP Data Source related language information. |
|
PSXPSCHEMAFLMN |
Stores BIP Data Source sample schema file information/data. |
|
PSXPSMPLDTMN |
Stores BIP Data sample XML data file information/data |
The BIP_FILE_DEFINITION uses the following tables.
|
Table |
Description |
|---|---|
|
PSFILEDEFN |
Stores BIP File definitions. |
|
PSFILEDATA |
Stores BIP File data information. |
|
PSFILEDEL |
Stores BIP Data File deletions. |