Selecting a Page Member to View in Excel

 

 Change the Page member in Excel as follows:

1.   Double-click Page member cell—e.g., cell C3 (United States).

The Select A Member dialog box appears. Note the two tabs, you can find Members based on where they appear in the dimensional Hierarchy or in the Member list.

2.   Select Canada.

3.   Click OK, and then press F9 to update the worksheet.

The worksheet now shows data for the new Page Member, Canada. You can repeat this means of selection—via the Select A Member dialog box, which PowerOLAP has made available in Excel—to pick other countries in the Regions dimension. [Were this a four-, five- , etc. dimensional Cube, you could pick any number of Page members to view, multiplying your potential sheaf of reports manyfold!]