Using Functions

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

Note:

When using the Smart View functions in Table 18-1, as a best practice, 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 18-1 Smart View Functions and Supported Providers

Function Description Supported Providers

HsGetValue

Retrieves data from a data source.

  • Oracle Essbase

  • Planning

  • Planning Modules

  • Financial Consolidation and Close

  • Tax Reporting

  • Narrative Reporting

HsSetValue

Sends values to the data source.

  • Essbase

  • Planning

  • Planning Modules

  • Financial Consolidation and Close

  • Tax Reporting

HsGetSheetInfo

Retrieves detailed information about the current worksheet.

Provider-independent

HsAlias

Displays the alias of the specified dimension member.

  • Planning

  • Planning Modules

  • Financial Consolidation and Close

  • Tax Reporting

HsDescription

Displays the description for the default member.

  • Essbase

  • Planning

  • Planning Modules

  • Financial Consolidation and Close

  • Tax Reporting

HsGetVariable

Retrieves the associated value for a substitution variable.

Essbase

HsGetSharedConnectionURL

Use this to quickly identify the shared connection data source that is being used.

  • Essbase

  • Planning

  • Planning Modules

  • Financial Consolidation and Close

  • Tax Reporting

  • Narrative Reporting