Converting Data Explorations to Reports

Understanding the Conversion Process

In the November 2010 release of SAS 9.2, SAS Web OLAP Viewer is discontinued, and data explorations are now maintained as reports. When you upgrade your existing SAS 9.2 deployment, the SAS deployment tools automatically convert each bookmark in the data exploration to a report that you can view and edit using SAS Web Report Studio.
Note: If the automatic conversion fails, a warning appears in the Instructions.html file. To convert these data explorations manually, see “Manually Convert Data Explorations to Reports” in the SAS Intelligence Platform: Migration Guide.

Before You Convert

If a data exploration was created from an OLAP cube or SAS Information Map that is saved to a restricted directory (such as My Folder), then the converted report will not be available to other users at your site. Before converting a data exploration to a report, re-create this data exploration by using a SAS Information Map. Users of the final report must have permission to the directory where the information map is saved.
Note: If you have not applied the second or third maintenance release for SAS 9.2, then you cannot use the SAS Visual Data Explorer to save data explorations as reports. If you want to save your data explorations as reports before upgrading your SAS 9.2 deployment, use SAS Web OLAP Viewer 4.2 for Java. For more information, see SAS Note 34876 at

Differences between Data Explorations and Reports

Some reports might appear slightly different from the data exploration. Here are some examples of how the report and data exploration differ:
  • The colors in the report and data exploration are different.
  • Conditional images are removed from the reports.
  • The Percent of Total columns and rows are removed from the reports.
  • A color-mapped table is removed or replaced by a noncolor-mapped table.
    • If a data exploration contains a color-mapped table and a table, then the color-mapped table is removed.
    • If a data exploration contains only a color-mapped table, then the color-mapped table is replaced with a table.
  • If a data exploration contains a bar-line chart, then this chart might not display as expected. To work around this problem, open the report in SAS Web Report Studio. Right-click on the chart and select Assign Data. Then save the report.
  • To view the drill-to-detail data of a report, the associated information map must have the Drill-to-Detail option selected in SAS Information Map Studio.
  • If a data exploration displays data values in a graph, these data values are not automatically displayed in the graph in the converted report. To display these values in the graph in the report, open the graph properties and select the option for displaying data values.