Sheet Information Support in EPM Cloud and Oracle Hyperion Planning

Data source types: Planning, Planning Modules, Enterprise Profitability and Cost Management, Financial Consolidation and Close, FreeForm, Tax Reporting

Table 17-15 Sheet Information Supported by Planning

Connection Status Form Ad Hoc Smart Form VBA Rules Functions
Shared Connection Yes Yes Yes Yes Yes No
Private Connection Yes Yes Yes Yes Yes No
Private Connection—Set as Default Connection Yes Yes Yes Yes Yes No
No Connection, open new blank worksheet No No No No No No
No connection, open a saved worksheet Yes Yes Yes Yes Yes No
Set Active Connection for this Worksheet Yes (see Sheet Information Guidelines) Yes (see Sheet Information Guidelines) Yes (see Sheet Information Guidelines) Yes Yes No
Set as Default Connection, before associate with active connection Not applicable (see Sheet Information Guidelines) Not applicable Not applicable Yes Not applicable Not applicable
Set as Default Connection, after associating with active connection Yes (see Sheet Information Guidelines) Yes Yes Yes Yes No
Last Retrieved Yes Yes