Before exporting consolidation metadata, ensure that an administrator has configured for extended analytics as follows:
If you use an Oracle database, you must 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 box
Enable EA Consolidation Tables is selected on the Extended Analytics Database Configuration dialog box before the database tables are created.
See Chapter 3 of the Oracle Hyperion Strategic Finance Administrator's Guide.