Using Functions

Note:

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

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

Note:

When using the Smart View functions in Table 21-1, 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 21-1 Smart View Functions and Supported Providers

Function Description Supported Providers
HsGetValue Retrieves data from a data source.

  • Oracle Hyperion Financial Management

  • Oracle Essbase

  • Planning

  • Oracle Planning and Budgeting Cloud

  • Oracle Enterprise Performance Reporting Cloud

  • Oracle Hyperion Enterprise® (private connection only)
HsSetValue Sends values to the data source.

  • Financial Management

  • Essbase

  • Planning

  • Enterprise Performance Reporting Cloud

  • 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