Exporting and Importing Pivot Grid Models

Pivot Grid administrators can use the Generate Import/Export Scripts page (PTPG_ADMN_EXPIMP) to generate the import and export scripts for the selected models.

Navigation:

Reporting Tools > Pivot Grid > Pivot Grid Administration > Generate Scripts

This example illustrates the fields and controls on the Generate Import/Export Scripts page. Definitions for the fields and controls appear following the example.

 Generate Import/Export Scripts page

Field or Control

Description

Export with Personalizations

Select to export the generated script with personalizations or deselect to export the generated script without personalizations.

Note: The existing personalization of the Pivot Grid models in the target database are always cleared off after the import.

Generate Scripts

Click to access the Export/Import Models dialog box, where you can view the exported or imported scripts.

This example illustrates the fields and controls on the Export/Import Models dialog box with Data Mover Scripts.

 Generate Import/Export Scripts page - Data Mover Scripts

To generate the Export/Import scripts for migrating specific models in the database:

  1. Select Reporting Tools, Pivot Grid, Pivot Grid Administration, Generate Scripts.

  2. Search for and select Pivot Grid models for creating a script.

  3. Define the option to include or exclude personalization.

  4. Click the Generate Scripts button to create the scripts.