Introduction to SAS Web OLAP Viewer

About SAS Web OLAP Viewer

SAS Web OLAP Viewer is a Web-based application for viewing SAS OLAP data. It provides an easy-to-use interface from which you can select a data source, view the data, and customize your view with features such as sorting and filtering.

The Main SAS Web OLAP Viewer Page

SAS Web OLAP Viewer displays data on the main SAS Web OLAP Viewer page, using tables and graphs.
illustration of the OLAP Viewer page
The main SAS Web OLAP Viewer page can contain the following elements:
1 main menu bar and toolbar
contains file menus and buttons that enable you to manage viewer content, select panels, and open dialog boxes.
2 left panel
displays one of three panels:
Query
enables you to select which data items are used.
Navigator
enables you to drill down on a hierarchy member.
Bookmarks
enables you to manage your bookmarks and data explorations.
3 Drill Path viewer
displays the current navigation path, if you have performed any drill-down actions.
4 Applied Filters viewer
shows any filters that you have applied to the data.
5 table viewer
shows the data as a crosstabulation. The table viewer toolbar contains menus and buttons that enable you to manage the table viewer.
6 graph viewer
displays the data as a graph. There are several types of graphs, and you can display a graph viewer for each type. The graph viewer toolbar contains menus and buttons that enable you to manage the graph viewer.
Note: If your data set is very large (that is, it contains a large number of unique values), the graph viewer might display a message about "insufficient display space." To view the graph, either resize the graph viewer or reduce the size of the data query.

Data Viewing Tasks

From the main SAS Web OLAP Viewer page, you can perform the following tasks:
  • Subset your data by drilling down and filtering.
  • Save and restore bookmarked views of your data..
  • Search for data values.
  • Calculate new data items.
  • View ESRI maps.
  • Export your data view as a SAS report, Microsoft Excel file, or PDF document.
  • View the query code.
Note: You cannot use SAS Web OLAP Viewer to make changes to information maps or to physical data.