Setting Active Connection for a Sheet

You can connect to different cubes on different sheets within the same worksheet by setting the active connection for each sheet.

You can set active connection for a cube on a sheet by using the Set Active Connection for Worksheet option in the right-click menu in Smart View Home panel.

To set active connection:

1. Open a new sheet.
2. In Smart View Home panel, select the required cube by clicking in the empty area next to the cube name.
3. Right-click the cube and select Set Active Connection for Worksheet.
4. In the Smart View ribbon, click Refresh to refresh the sheet.

   The active connection to the cube is now set and the grid is placed on the sheet. You can open the Sheet Info dialog box to verify the connection details.