Transcript SAS 9.1: BI Reporting

Chapter 11
Using SAS® Web Report
Studio
Section 11.1
Overview of SAS
Web Report Studio
SAS Web Report Studio
SAS Web Report Studio
 provides non-technical business users the ability to
find, interact with, create, and share reports based
on corporate data
 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
 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
Colors
Data
Model
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?
 Internet Explorer 5.5 or newer
6
Section 11.2
Using SAS
Web Report Studio
Using SAS Web Report Studio
SAS Web Report Studio is started from your browser by
entering a specific URL.
On the classroom machines you use:
http://localhost:8080/SASWebReportStudio
8
Using SAS Web Report Studio
The main window of SAS Web Report Studio includes
links for
 viewing an
existing report
 creating a
new report
 editing an
existing report
 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