What does the Refers To setting apply to when creating a Cube View Connection?

What does the Refers To setting apply to when creating a Cube View Connection?

• A. The initial cell within a spreadsheet that a Cube View will start at
• B. The name of the Cube View users are making a Cube View Connection with
• C. The range of cells that the Cube View Connection will be applied to
• D. The sheet tab where the connection will be created

Answer: (A)

The Refers To setting defines where in the worksheet the Cube View’s data will begin to be placed. It acts as the anchor—the top-left cell from which the Cube View will populate rows, columns, and measures. This is about the starting point of the output on the sheet, not the name of the Cube View, not the entire data range, and not the sheet tab where the connection is created. By choosing the initial cell, you control where the Cube View starts filling in results, ensuring the output aligns with your layout.

The Refers To setting defines where in the worksheet the Cube View’s data will begin to be placed. It acts as the anchor—the top-left cell from which the Cube View will populate rows, columns, and measures. This is about the starting point of the output on the sheet, not the name of the Cube View, not the entire data range, and not the sheet tab where the connection is created. By choosing the initial cell, you control where the Cube View starts filling in results, ensuring the output aligns with your layout.