Ranet OLAP pivot table toolbar includes the following commands:
| Command | Description |
|---|---|
| Refresh | Runs the current MDX query and shows the result. |
| Navigate To Begin | Navigates to the beginning of the pivot grid query history. |
| Navigate Backward | Navigates one item back in the pivot grid query history. |
| Navigate Forward | Navigates one item forward in the pivot grid query history. |
| Navigate To End | Navigates to the last item in the pivot grid query history. |
| On/Off Editing Mode | Enables or disables editing of pivot grid cells. |
| Copy selected sells to Clipboard | Copies the selected portion of the cell area to the clipboard. |
| Paste cells from Clipboard | Pastes cells from the clipboard to the cell area. |
| Use remitted recalculation | Enables 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 changes | Save 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 recalculation | Undo 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 members | Restores the default size for row and column members. |
| Hide Empty Rows | Enables or disables the display of empty rows. |
| Hide Empty Columns | Enables or disables the display of empty columns. |
| Go to Focused Cell | Shows the focus cell. The command can be used, when the focus cell is outside the visible area. |
| Rotate axes | Swaps the row area and the column area |
| Hide members and cells hilts | Hides pop-up descriptions for cells, row members, and column members. |
| Export to Microsoft Excel | Exports the pivot grid table data to an Excel file (*.xls). |
| Zoom | Command changes the pivot table display scale |