Common Profile Entries

Profile switches must be added under Oracle Analytics Publisher Common User and Oracle Analytics Publisher Common User Password rows. The following information is available for these profile switches:

Table 4-1 Common Profile Entries

Field Label	Default and Possible Values	Description
Persist data in Oracle Analytics Publisher Aggregate Temp Tables	Default: No Yes No	Yes: System persists or stores the data of Oracle Analytics Publisher aggregate temp tables for all the case series generated for aggregate reports generation. No: System does not persist data of Oracle Analytics Publisher Aggregate Temp tables.
Number of days for which data of Oracle Analytics Publisher Aggregate Temp Tables should be persisted	Default: NULL	Data of Oracle Analytics Publisher Temp tables is persisted for the number of days defined in this configuration. After the configured period (Number of days from the last modified date of case series), a database or system job purges the data that is no longer required (defined separately). You can override the number of days for persisting data of a particular aggregate case series while generating the report through the Oracle Analytics Publisher Console.

Field Label

Default and Possible Values

Description

Persist data in Oracle Analytics Publisher Aggregate Temp Tables

Default: No

Yes

Yes: System persists or stores the data of Oracle Analytics Publisher aggregate temp tables for all the case series generated for aggregate reports generation.

No: System does not persist data of Oracle Analytics Publisher Aggregate Temp tables.

Number of days for which data of Oracle Analytics Publisher Aggregate Temp Tables should be persisted

Default: NULL

Data of Oracle Analytics Publisher Temp tables is persisted for the number of days defined in this configuration. After the configured period (Number of days from the last modified date of case series), a database or system job purges the data that is no longer required (defined separately). You can override the number of days for persisting data of a particular aggregate case series while generating the report through the Oracle Analytics Publisher Console.

If Persist data in BIP Aggregate Temp Tables is set to No, the system does not persist data of Oracle Analytics Publisher temp tables.
If Persist data in BIP Aggregate Temp Tables is set to Yes and Number of days for which data of BIP Aggregate Temp Tables should be persisted is not defined, the system throws an error message when you save the value of these configurations. The following message appears:

Please enter the number of days for which data of Oracle Analytics Publisher Temp Tables should be persisted.

In a multi-tenant environment, you can view these configuration entries on the enterprise level.
As part of data persistence and purging, two parameters have been added in Oracle Analytics Publisher aggregate reports for overriding the default value. For example, you can choose not to persist data for a draft report run even if the default value is set to perist Oracle Analytics Publisher temp table data. The following parameters have been added in aggregate reports:
- Persist data of Temp Tables
- Number of Days for Data Persistence

For more information on these two parameters, refer Report Parameters and their Definitions.

Parent topic: Configure Changes for Oracle Argus Insight RPD Integration