Deleting Pivot Grid Models

Pivot Grid administrators use the Delete Pivot Grid Models page (PTPG_ADMN_DELETE) to delete the models and all their associated views in the database.

Image: Delete Pivot Grid Models page

This example illustrates the fields and controls on the Delete Pivot Grid Models page. Definitions for the fields and controls on this page follow this example.

Delete Pivot Grid Models page

Field or Control

Definition

Keyword

Click to perform a free-text search on model name and title.

Delete Non Default Views

Click to access the Delete Non Default Views page, where you can view and delete non-default views that are associated with the models.

Delete Model(s)

Click to delete the selected Pivot Grid models.

Note: An error message appears if any selected model or view is referenced in pagelets or in related content. You have to remove the references in the Pagelets or Related Content components before you can delete the model or views.

To delete specific Pivot Grid models and all associated views in the database:

  1. Select Reporting Tools, Pivot Grid, Pivot Grid Administration, Delete Models.

  2. Click the Search button to display all Pivot Grid models that you have authorization to delete.

  3. Select the models that you want to delete.

  4. Click the Delete button to delete the selected models and their associated views.

    If any selected model is referenced in an exported pagelet, an error message appears asking you to delete the pagelet reference.

Note: A search run without any search condition on the Delete Pivot Grid Models page yields a maximum of 1000 search results. If you are looking for a search result which is not already displayed within the 1000 rows, then use a search condition to refine your search.

Note: When you delete a Pivot Grid model that was created using a component as the data source, you have the option to either delete or not delete the query that is associated with the component.