Create an Excel PivotTable report from an OLAP cube | On the Data menu in Excel, click PivotTable And PivotChart Report. Click the External Data Source option and the Get Data button. In Microsoft Query, click the OLAP Cubes tab. |
Hide selected members on an axis | Click the drop-down arrow next to the dimension name (on the filter axis) or level name (row and column axis). Select or clear check boxes, and click OK. |
Move multiple measures from the row axis to the column axis in an Excel PivotTable report | Drag the row axis button to the column area. |
Move measures from the column axis to the rows axis in an Office PivotTable list | Select the caption bar, and in the property toolbox, expand the Totals section. In the Total Orientation drop-down list, select row. |
Remove the interactive buttons from an Excel PivotChart | On the PivotChart toolbar, click the report PivotChart menu and click Hide PivotChart Field Buttons. |
Publish an Excel PivotTable report as an Office PivotTable list | On the File menu in Excel, click Save As Web Page. Click Publish. Select PivotTable, select the Add Interactivity With check box, and select PivotTable Functionality. |
Show only a single level on an axis in an Office PivotTable list | Drag the dimension to the axis, and then drag away the unwanted levels. |
Add an Office PivotTable list to an HTML document | In FrontPage, point to Component on the Insert menu and click Office PivotTable. In the property toolbox, expand the Data Source section, select the Connection option, and click Connection Editor. Switch to the Provider tab, and select OLE DB Provider For OLAP Services 8.0. Then switch to the Connection tab, type the name of the server, and select the initial database. |
Restrict capabilities of the Office PivotTable list control | In FrontPage, select the control, and in the property toolbox, set values in the Advanced section. |
Create a local cube file based on an existing server cube | With an Excel PivotTable report selected, on the PivotTable toolbar, click the PivotTable menu, click Client Server Settings, and follow the instructions in the wizard. |
Create a local cube directly from a relational data source | In Excel, on the Data menu, point at Get External Data and click New Database Query. Use Microsoft Query to define the relational data source, and then—either in the last page of the Query Wizard or from the File menu in Microsoft Query—select Create An OLAP Cube From This Query and follow the instructions in the wizard. |