Sheet Information Support in Planning

Data source types: Oracle Hyperion Planning, Oracle Planning and Budgeting Cloud, Oracle Enterprise Planning and Budgeting Cloud

Table 8-10 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 Example 8-1) Yes (see Example 8-1) Yes (see Example 8-1) Yes Yes No
Set as Default Connection, before associate with active connection Not applicable (see Example 8-1) Not applicable Not applicable Yes Not applicable Not applicable
Set as Default Connection, after associating with active connection Yes (see Example 8-1) Yes Yes Yes Yes No
Last Retrieved Yes Yes