Sheet Information Support in EPM Cloud and Oracle Hyperion Planning
Cloud data source types: Planning, Planning Modules, Enterprise Profitability and Cost Management, Financial Consolidation and Close, FreeForm, Tax Reporting
On-premises data source types: Oracle Hyperion Planning
Table 14-20 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 |