Create Aggregates on TimesTen Sources

These topics describe configuration steps and features related to aggregate creation on TimesTen sources.

To create aggregates with compressed tables in TimesTen, you must enable COMPRESSED_COLUMNS in the Features tab of the Database dialog in the Administration Tool. See SQL Features Supported by a Data Source.

This section contains the following topics:

See Oracle Exalytics for specific instructions on setting up TimesTen sources.

Enable PL/SQL for TimesTen

To create aggregates on TimesTen sources, you must ensure that PL/SQL is enabled for the instance, and that the PL/SQL first connection attribute PLSQL is set to 1.

You can enable PL/SQL at install time, or run the ttmodinstall utility to enable it post-install, see Oracle TimesTen In-Memory Database Installation Guide.

Enable Performance Enhancement Features for TimesTen

You can disable redo logging and run database checkpoints in the background to enhance performance.

Edit the obis.properties file located at BI_DOMAIN\config\fmwconfig\bienv\obis.
Add the following TimesTen variables:
- ORACLE_BI_TT_DISABLE_REDO_LOGGING=1
  
  The ORACLE_BI_TT_DISABLE_REDO_LOGGING=1 element disables redo-logging, enabling faster creation of aggregates.
  
  Set the ORACLE_BI_TT_DISABLE_REDO_LOGGING=1 element to 0 (zero), to disable the feature.
- ORACLE_BI_TT_BACKGROUND_CHECKPOINT_INTERVAL=10
  
  The ORACLE_BI_TT_BACKGROUND_CHECKPOINT_INTERVAL element changes how often TimesTen flushes its data to disk. If the element is missing, the default is every 10 seconds. If you explicitly set ORACLE_BI_TT_BACKGROUND_CHECKPOINT_INTERVAL=N, for example, to 10, the flush to disk occurs every N seconds, 10 as in this example. If you set ORACLE_BI_TT_BACKGROUND_CHECKPOINT_INTERVAL to 0 (zero) background flushing is disabled. Enabling background flushing speeds up creation of aggregates, by avoiding a large blocking flush at the end of the aggregate creation process.
Save and close the obis.properties file.
Restart the Oracle BI Server.