Managing Data in the Table Viewer

Replace a Hierarchy with an Unassigned Hierarchy

If there are hierarchies that are not assigned to the Rows or Columns roles, then you can replace a currently assigned hierarchy with an unassigned one.

To replace a hierarchy, right-click on a level heading and select Change assigned-hierarchy to

unassigned-hierarchy.

The old hierarchy is removed from the query, and the new hierarchy is added to the query in its place. If the new hierarchy was previously assigned to the Slicer role, then the old hierarchy is moved to the Slicer role.

Sort Data

You can sort data in the following ways:

To sort the values from least to greatest within each hierarchy, select Sort (Rows | Columns) DataAscending within Hierarchies.
To sort the values from least to greatest across all of the hierarchies, select Sort (Rows | Columns) DataAscending across Hierarchies.
To sort the values from greatest to least within each hierarchy, select Sort (Rows | Columns) DataDescending within Hierarchies.
To sort the values from greatest to least across all of the hierarchies, select Sort (Rows | Columns) DataDescending across Hierarchies.
To remove sorting, select Sort (Rows | Columns) DataRemove All Sorting.

Format the Measure Values

To change the format for a measure:

Right-click the measure heading and select Format.
In the Format dialog box, select the type of format from the Format type drop-down list.
From the selection box, select the format that you want to use. A description of the selected format is displayed.
Specify the width of the format in the Valid width range field. The width that you specify includes every character in the value. For example, $1,978.53 has a width of 9.
Specify the number of decimal places for the format in the Valid decimal range field. For example, 3.141593 has a decimal range of 6.

Note: The number of decimal places is limited by the width that you specify in the Valid width range field and the number of characters to the left of the decimal. For example, if you specify a width of 8 and a decimal range of 6, the value 346.734947 is represented as 346.7349.
Click OK to apply your format and return to the main SAS Web OLAP Viewer page.

Reorder Data Items

To move a hierarchy or the measures inward or outward, right-click the heading of a hierarchy level or measure, and then make selections as follows:

Reordering Tasks

Axis	Selection	Effect
Vertical	Move (level-name \| Measures)Left	Moves the hierarchy or the measures outward
Vertical	Move (level-name \| Measures)Right	Moves the hierarchy or the measures inward
Horizontal	Move (level-name \| Measures)Up	Moves the hierarchy or the measures outward
Horizontal	Move (level-name \| Measures)Down	Moves the hierarchy or the measures inward

You can also reorder your data items by dragging. To place a data item to the outside of a specific heading, drag it to the outer edge of that heading. To place a data item to the inside of a specific heading, drag it to the inner edge of that heading.

Change Axis Assignments

You can change axis assignments in two ways:

Move specific data items to another axis.
- To move a hierarchy to the horizontal axis, right-click the level heading and select Move level-name to Columns.
- To move a hierarchy to the vertical axis, right-click the level heading and select Move level-name to Rows.
- To move the measures to the horizontal axis, right-click any measure heading and select Move Measures to Rows.
- To move the measures to the vertical axis, right-click any measure heading and select Move Measures to Columns.
You can also move data items by dragging. Drag the data item to the new axis. If the resulting query is valid, then the table refreshes itself automatically.
Rotate the table.
- To rotate the table, right-click any level or measure heading and select Rotate Table. All axis assignments are reversed.

Hide Empty Data Values

You can hide rows and columns that only contain empty data. To hide empty values:

Select ViewPreferences from the main toolbar.
Select Suppress Empty Data to hide empty values.
Click OK to apply your changes and return to the main SAS Web OLAP Viewer page.

Note: Empty values are hidden only if all of the values in a row or column are empty values.