You can use any of the following menu commands to format the OLAP query results.
Use the Copy option to copy data for a measure or dimension directly to the clipboard.
You can apply extensive formatting options to the OLAP query results. The formatting options are the same as for relational query results and the details are covered in the chapter on Query Results.
The Grouping and Aggregation options are not available from the Results menu, or from the context menu. Instead, the grouping and aggregation options are defined by the administrator when creating the OLAP cubes using a third-party product.
Use the Drill Down option to view detailed data for a dimension and its corresponding measures.
Detailed information rather than summary information is revealed for the dimension.
Use the Drill up option to view summary data for a dimension and its corresponding measures.
Summary information is revealed for the dimension.
Use the Remove from Layout option to remove a column from the OLAP query results. The column is removed from the layout but not from accessible query results.
To remove a column from the query results layout:
To return the column to the layout:
The column is returned in the OLAP query results, the Layout Designer, and the Measures node of the Layout branch in the OLAP Query Results Explorer tree.