Ranet OLAP pivot table toolbar includes the following commands:

CommandDescription
RefreshRuns the current MDX query and shows the result.
Navigate To BeginNavigates to the beginning of the pivot grid query history.
Navigate BackwardNavigates one item back in the pivot grid query history.
Navigate ForwardNavigates one item forward in the pivot grid query history.
Navigate To EndNavigates to the last item in the pivot grid query history.
On/Off Editing ModeEnables or disables editing of pivot grid cells.
Copy selected sells to ClipboardCopies the selected portion of the cell area to the clipboard.
Paste cells from ClipboardPastes cells from the clipboard to the cell area.
Use remitted recalculationEnables or disables the use of cache memory when editing cells. The changes are accumulated in the cache memory until they are sent to the server using the Save Changes command. Otherwise, the data are saved automatically after each change.
Recalculate table data with current changesSave changes – saves the cell changes accumulated in the cache memory. It sends the changes to the server. Then the server recalculates the cube data and returns an updated result to the client.
Restore table data in initial state or state before recalculationUndo changes - rolls back all cell changes accumulated in the cache memory, since the start of editing until the last save operation.
Restore default size for columns and rows membersRestores the default size for row and column members.
Hide Empty RowsEnables or disables the display of empty rows.
Hide Empty ColumnsEnables or disables the display of empty columns.
Go to Focused CellShows the focus cell. The command can be used, when the focus cell is outside the visible area.
Rotate axesSwaps the row area and the column area
Hide members and cells hiltsHides pop-up descriptions for cells, row members, and column members.
Export to Microsoft ExcelExports the pivot grid table data to an Excel file (*.xls).
ZoomCommand changes the pivot table display scale