Creating Multiple-Grid Sheets

You can create a multiple-grid sheet by placing ad hoc grids from the same data source or different data sources.

For placing multiple grids from multiple data source connections, ensure that your service administrator has deployed the respective manifests for connecting to the required data sources. You should be able to see multiple Smart View ribbons for respective data sources, for example Smart View Planning and Smart View Tax Reporting, based on the naming set by your service administrator.

To create a multiple-grid sheet:

  1. Open a new sheet.
    Ensure that the sheet is blank and does not contain any existing data.
  2. Select a range of cells from any location in the sheet.

    You must select a range of cells, instead of only one cell.

  3. From the Smart View Home panel, perform an action:
    • Select a cube.
    • Select a form, right-click on it, and then select Ad Hoc Analysis.
  4. Select Yes in the prompt asking to change the sheet to support multiple grids.
    The ad hoc grid is added in the position of the selected range.
  5. To add another grid from the same data source on the sheet:
    1. Select a different range of cells.
    2. From the Smart View Home panel, select a cube, or select a form, right-click on it, and then select Ad Hoc Analysis.
      The ad hoc grid is added in the position of the selected range.
  6. To add a grid from another data source on the same sheet:
    1. Select a range of blank cells.
    2. Open the Smart View ribbon of the other data source and click Home to open the Smart View Home panel related to that data source.
      The second Smart View Home panel opens in a separate tab below the already open Smart View Home panel belonging to the first data source.
    3. From the Smart View Home panel, select a cube, or select a form, right-click on it, and then select Ad Hoc Analysis.
      The ad hoc grid is added in the position of the selected range.