About Functions

You can use supported functions in Smart View to retrieve and send data in specific cells in Excel sheet.

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

Table 17-1 Smart View Functions and Supported Providers

Function	Description	Supported Providers
HsGetValue	Used to create static reports which can then be formatted as required by retrieving application data into specific cells.	Planning Planning Modules Financial Consolidation and Close Tax Reporting Oracle Essbase
HsSetValue	Used to send a data value from a worksheet to a data source based on selected members of dimensions.	Planning Planning Modules Financial Consolidation and Close Tax Reporting Oracle Essbase
HsAlias	Used to display the alias of the specified dimension member.	Planning Planning Modules Financial Consolidation and Close Tax Reporting

In Smart View, you can use the Function Builder panel to add functions to cells on a sheet, or enter these functions manually into cells on the sheet, providing a connection name and the POV, and then retrieve data upon refresh.

Functions are validated only upon refresh.

If any function is invalid, then all functions on the sheet, including valid functions, will display #Error. For example, an invalid dimension or member name will result in an invalid function. Review functions for errors and correct them, and then refresh the sheet again.

Administrators: To implement functions for Oracle Smart View for Office (Mac and Browser) users, Service Administrators deploy a manifest file with the "Include Functions support" option enabled, described in Deploying and Administering Oracle Smart View for Office (Mac and Browser). Before sideloading a new manifest or deploying it to users, all users must clear their browser cache.