Support for Sheet Information in Cloud EPM

Without connecting to a data source, if you open a new blank sheet or a saved sheet and launch the Sheet Info dialog, it displays the Sheet Type information as Empty. No other details are available for display without establishing a connection for the sheet.

Once connected to a data source, the Sheet Information is supported as follows for various artifacts as per different connection scenarios.

Note:

For a Function sheet, the Sheet Info dialog only displays the Sheet Type as Function. No other details are available for display for a Function sheet.

Table 15-5 Sheet Information Supported by in Cloud EPM

Connection Status Form Ad Hoc Smart Form Rules Functions
Set Active Connection for this Worksheet Yes Yes Yes Yes No
Set as Default Connection, before associating with active connection N/A N/A N/A N/A N/A
Set as Default Connection, after associating with active connection Yes Yes Yes Yes No
Last Retrieved Yes Yes No No No