Using Functions

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 Analytics Cloud - Essbase Oracle Planning and Budgeting Cloud Oracle Enterprise Planning and Budgeting Cloud Oracle Financial Consolidation and Close Cloud Oracle Tax Reporting Cloud Oracle Enterprise Performance Reporting Cloud
HsSetValue	Sends values to the data source.	Oracle Analytics Cloud - Essbase Oracle Planning and Budgeting Cloud Oracle Enterprise Planning and Budgeting Cloud Oracle Financial Consolidation and Close Cloud Oracle Tax Reporting Cloud
HsGetSheetInfo	Retrieves detailed information about the current worksheet.	Provider-independent
HsAlias	Displays the alias of the specified dimension member.	Oracle Planning and Budgeting Cloud Oracle Enterprise Planning and Budgeting Cloud Oracle Financial Consolidation and Close Cloud Oracle Tax Reporting Cloud
HsDescription	Displays the description for the default member.	Oracle Analytics Cloud - Essbase Oracle Planning and Budgeting Cloud Oracle Enterprise Planning and Budgeting Cloud Oracle Financial Consolidation and Close Cloud Oracle Tax Reporting Cloud
HsGetVariable	Retrieves the associated value for a substitution variable.	Oracle Analytics Cloud - Essbase