Chapter 11 Using SAS Web Report Studio Section

Chapter 11 Using SAS® Web Report Studio

Section 11. 1 Overview of SAS Web Report Studio

SAS Web Report Studio n provides non-technical business users the ability to find, interact with, create, and share reports based on corporate data n is designed to meet the specific needs, skills, and experiences of decision makers at all levels of the organization who need self-service information quickly n is intended for users with little or no experience in other reporting tools or database technology. 3

SAS Report Model SAS® 9 provides the ability to save output to the SAS Report Model format using the SAS Output Delivery System (ODS). SAS Web Report Studio will be able to view ODS output stored in the SAS Report Model XML format. Reporting Applications Document/ Section Info Map SAS ODS Style Info Map Data Model Colors View Language XML Serialization SAS Report Table Embedded Data URL Formats Text Image Graph 4 Report Components within technologies and solutions

Interaction with SAS Application Servers SAS Web Report Studio can use any or all of the following application servers: 5 SAS Metadata Server Required to read and write metadata in a SAS metadata repository. SAS Workspace Server Required to execute SAS code and access data. SAS OLAP Server Required to access cube data and generate MDX queries. .

SAS Web Report Studio Which browsers are supported? n Internet Explorer 5. 5 or newer 6

Section 11. 2 Using SAS Web Report Studio

Using SAS Web Report Studio is started from your browser by entering a specific URL. On the classroom machines you use: http: //localhost: 8080/SASWeb. Report. Studio 8

Using SAS Web Report Studio The main window of SAS Web Report Studio includes links for n viewing an existing report n creating a new report n editing an existing report n setting preferences. 9

Using SAS Web Report Studio New reports can be created using the Report Wizard, which is uses a point-and-click interface to gather information to build the report. 10

Using SAS Web Report Studio Another option for creating reports is the Report Builder, which allows the information for the report to be entered on one screen. 11

Using SAS Web Report Studio This demonstration shows how to use SAS Web Report Studio to create a new report. 12 Define Data Libraries Create Stored Processes Register Source Tables View and Analyze Data Define Target Tables Create Information Maps Metadata Create ETL Jobs Create Reports Create OLAP Cubes Use the Information Delivery Portal