Using Functions

If you are familiar with the contents of your database, you can use the Smart View functions described in Table 15 to perform operations on specific data in Excel cells. Table 15 lists each function, a brief description, and the supported providers.

Note:

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

FunctionDescriptionSupported Providers
HsGetValueRetrieves data from a data source.
  • Financial Management

  • Essbase

  • Planning

  • Hyperion Enterprise (private connection only)

HsSetValueSends values to the data source.
  • Financial Management

  • Essbase

  • Planning

  • Hyperion Enterprise (private connection only)

HsGetSheetInfoRetrieves detailed information about the current worksheet.Provider-independent
HsCurrencyRetrieves the entity currency for the selected members.
  • Financial Management

  • Hyperion Enterprise (private connection only)

HsDescriptionDisplays the description for the default member.
  • Financial Management

  • Essbase

  • Hyperion Enterprise (private connection only)

HsLabelDisplays the label for the default member.
  • Financial Management

  • Hyperion Enterprise (private connection only)

HsGetTextRetrieves cell text from the data source.
  • Financial Management

  • Hyperion Enterprise (private connection only)

HsSetTextSends cell text to the data source.
  • Financial Management

  • Hyperion Enterprise (private connection only)

HsGetVariableRetrieves the associated value for a substitution variable.
  • Essbase