Before exporting consolidation metadata, ensure that an administrator has configured for extended analytics as follows:
If using an Oracle database, ensure that you have these system privileges in Oracle:
ALTER ANY [INDEX/TABLE/SEQUENCE]
CREATE ANY [INDEX/TABLE/SEQUENCE]
DROP ANY [INDEX/TABLE/SEQUENCE]
Database Connectivity Enabled is enabled on the External Database dialog
Enable EA Consolidation Tables is selected on the Extended Analytics Database Configuration dialog before the database tables are created.
See Chapter 3 of the Oracle Hyperion Strategic Finance Administrator's Guide.