Using Functions

Note:

In this chapter, references to Planning apply to both the on-premises and Oracle Planning and Budgeting Cloud Service versions of Planning.

If you are familiar with the contents of your database, you can use the Smart View functions described in Table 19 to perform operations on specific data in Excel cells.

Note:

When using the Smart View functions in Table 19, do not use the hash mark (#) or the semicolon (;) in member names, dimension names, or variable names. These characters are reserved for delimiters in the functions noted in this chapter.

Table 19. Smart View Functions and Supported Providers

Function	Description	Supported Providers
HsGetValue	Retrieves data from a data source.	Financial Management Essbase Planning Hyperion Enterprise (private connection only)
HsSetValue	Sends values to the data source.	Financial Management Essbase Planning Hyperion Enterprise (private connection only)
HsGetSheetInfo	Retrieves detailed information about the current worksheet.	Provider-independent
HsCurrency	Retrieves the entity currency for the selected members.	Financial Management Hyperion Enterprise (private connection only)
HsDescription	Displays the description for the default member.	Financial Management Essbase Hyperion Enterprise (private connection only)
HsLabel	Displays the label for the default member.	Financial Management Hyperion Enterprise (private connection only)
HsGetText	Retrieves cell text from the data source.	Financial Management Hyperion Enterprise (private connection only)
HsSetText	Sends cell text to the data source.	Financial Management Hyperion Enterprise (private connection only)
HsGetVariable	Retrieves the associated value for a substitution variable.	Essbase