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 17-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 17-1 Smart View Functions and Supported Providers

Function	Description	Supported Providers
HsGetValue	Retrieves data from a data source.	Oracle Hyperion Financial Management Oracle Essbase Oracle Hyperion Planning Planning Planning Modules Financial Consolidation and Close Tax Reporting Narrative Reporting
HsSetValue	Sends values to the data source.	Financial Management Essbase Oracle Hyperion Planning Planning Planning Modules Financial Consolidation and Close Tax Reporting
HsGetSheetInfo	Retrieves detailed information about the current worksheet.	Provider-independent
HsCurrency	Retrieves the entity currency for the selected members.	Financial Management
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.	Financial Management Essbase Planning Planning Modules Financial Consolidation and Close Tax Reporting
HsLabel	Displays the label for the default member.	Financial Management
HsGetText	Retrieves cell text from the data source.	Financial Management
HsSetText	Sends cell text to the data source.	Financial Management
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.	Financial Management Essbase Oracle Hyperion Planning Planning Planning Modules Financial Consolidation and Close Tax Reporting Narrative Reporting