About Functions

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

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

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

The following functions are supported in Smart View.

Table 13-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

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

HsAlias

Used to display the alias of the specified dimension member.
  • Planning
  • Planning Modules
  • Financial Consolidation and Close
  • Tax Reporting

HsGetSheetInfo

 Used to retrieves detailed information about the current sheet, one sheet property at a time.
  • Planning
  • Planning Modules
  • Financial Consolidation and Close
  • Tax Reporting

Guidelines for Using Functions

Consider the following guidelines while using functions in Smart View:

  • 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.

  • If a function sheet contains functions from different data source connections, then refreshing the sheet refreshes all the functions from all the connected data sources.
  • On a Functions-only sheet, ad hoc analysis cannot be performed and multiple grids cannot be inserted.