Creating Functions from Multiple Connections

You can create a function sheet by adding functions from different cubes and data sources.

For adding functions from multiple data source connections, you can connect to the required data sources before you start creating the function sheet or even during the process.

To add functions from multiple data source connection on the same sheet:

  1. Open a new sheet and connect to a data source.
  2. Select a cube and, in the connection dialog that displays, select Set as Connection for Functions, then type a name for the connection, and then click OK.
  3. In the sheet, select the cell in to which you want to enter the function.
  4. Add a function either by creating it manually or by using the Function Builder.

    See Creating Functions Manually and Creating Functions in the Function Builder.

  5. To add a function from another cube on the same sheet, repeat the above steps from step 2 to step 5.
  6. To add a function from another data source on the same sheet:
    1. Connect to the other data source, if not already connected. In the Extensions menu, select Smart View for Google Workspace, and then select Connect under Start.

      For more information, see Connecting to Data Sources.

    2. Once connected, set it as an active connection in the sheet. In the Extensions menu, select Smart View for Google Workspace, and then select Active Connections under Start.

      For more information, see Setting Active Connection for a Sheet.

    3. In the sheet, select the cell in to which you want to enter the function.
    4. Add a function either by creating it manually or by using the Function Builder.

      Note:

      In case of multiple-grid ad hoc sheets having grids from multiple connections, the HsGetSheetInfo function retrieves the sheet properties only for the first connection, irrespective of the connection that is currently active on the sheet. This is a limitation.

  7. To run the functions and view the values, refresh the sheet.

    All functions from all the connected data sources are refreshed at once.

    Review the functions for errors and refresh the sheet again.