Managing Data in the Table Viewer :: SAS(R) Information Delivery Portal 4.2: Help

Replace a Hierarchy with an Unassigned Hierarchy (OLAP Data Only)

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 by Using the Sort Dialog Box (Relational Data Only)

You can sort your data by using up to three columns. To create a new sort:

Select DataSort on the main menu bar.
From the Sort by drop-down list, select the column that will be sorted first.
Select Ascending to sort the column from least to greatest, or Descending to sort the column from greatest to least.
Optionally, select the column that will be sorted second from the first Then by drop-down list, and then select Ascending or Descending.
Optionally, select the column that will be sorted third from the second Then by drop-down list, and then select Ascending or Descending.
Click OK to apply your changes and return to the main Visual Data Explorer page.

To remove the sorting, right-click any column heading and then select Remove All Sorting.

Sort Data by Using the Table Viewer

For OLAP 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.

For relational data, you can sort data in the following ways:

To sort the values from least to greatest for the selected column, select Sort ColumnAscending.
To sort the values from greatest to least for the selected column, select Sort ColumnDescending.
To remove sorting, select Sort ColumnRemove All Sorting.

Format the Measure Values

To change the format for a measure or measure column:

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 Visual Data Explorer page.

Reorder Data Items

Relational Data

To move a column, right-click the column heading and make one of the following selections:

Selection	Effect
Move ColumnLeft	Moves the column to the left
Move ColumnRight	Moves the column to the right

OLAP Data

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 (OLAP Data Only)

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 Visual Data Explorer page.

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