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 Oracle BI Administration Tool. See Specifying SQL Features Supported by a Data Source.
This section contains the following topics:
See Oracle Exalytics for specific instructions on setting up TimesTen sources.
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.