Blog

  • Home
  • SAS BI
  • Overview of SAS Web Report Studio - SAS BI

Overview of SAS Web Report Studio - SAS BI

  • (4.0)
  • | 1728 Ratings

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.

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.

Users can interact with the report by performing operations such as drilling, sorting, filtering, ranking, exporting, and group break navigation using the Table of Contents. This is feasible because SAS Web Report Studio stores reports in the common SAS Report Model XML format.

Interaction with SAS Application Servers

SAS Web Report Studio can use any or all of the following application servers:

Interaction with SAS Application Servers

SAS Web Report Studio
Which browsers are supported?

  • Internet Explorer 5.5 or newer

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:
https://localhost:8080/SASWebReportStudio
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.

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

Report

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

Related Page:: Learn SAS OLAP Cube Studio Interface from SAS BI.

The below demonstration shows how to use SAS Web Report Studio to create a report.

SAS Web Report Studio

1. Open an Internet Explorer window and enter the following URL: https://localhost:8080/saswebreportstudio
2. Enter the user name and password provided by your instructor.

SelectLog On Button

After logging on, the main window of SAS Web Report Studio is displayed.

There are many options from the main window, including the ability to view an existing report, create a new report, and set SAS Web Report Studio preferences.
3. Begin creating a new report by selecting

Create Edit Button

Url

The default interface is the Report Wizard – you can switch to the Report Builder by selecting

Report Builder

Notice that this is the first of five steps to create a report.
To navigate between the steps, choose either Path or Creating report
Step 1 of the Report Wizard – Select data for the report
4. Select a data source for the report; select the information map Orion Star Gold Customer Order Information.

Select  to display the Data Source Information window.

When a data source has been selected, the data items are displayed. Select the desired data items and use to move them to the Selected Data Items: list.
5. Select the following fields:

  • Customer Age Group
  • Customer Country
  • Customer Gender
  • Total Retail Price for This Product.

SAS Web Report Studio

Total Retail Price for This Productto advance to the next step (step 2).

Step 2 of the Report Wizard – Sort or filter data (optional)
6. Change the sort order to Ascending for the following columns:

  • Customer Age Group
  • Customer Country
  • Customer Gender.

Code

If there are any filters in the information map they will be available in the filter box the data item(s) the filter is based on.

Code

A new filter can be created by selecting for the selected data item, this opens the Create new filter window. Create new filter window

7. Select Preview Data to view the results of the query.
8. The Preview Data window displays a listing of the query results:

Preview Data

Code

 Select to export the data to Microsoft Excel.

9. Select Close Windowto close the Preview Data window.
10. Select Play to advance to the next step (step 3).
Step 3 of the Report Wizard – Create group breaks (Optional)
11. Select Customer Gender as a Group break.

SAS Web Report Studio

The default for group breaks is to have a new page for each value. This option produces a table of contents to navigate to each page of output.
Select Play to advance to the next step (step 4).
Step 4 of the Report Wizard – Select a table, graph, or both
Tables and graphs can be created for the desired report. If the Graph check box is not available, it is because a measure is not identified in the data.
12. Select the Table check box (if not already selected).
    a. Enter Sales by  Gender,  Age,  and  Country as the Title for the Table.
13. Select the Graph checkbox.
    a. Enter Retail Price  Analysis as the Title for the Graph.
    b. Select Pie for the graph type.
    c. Specify Total Retail Price for This Product as the variable to set the segment size.
    d. Specify Customer Age Group as the variable to set the segments.

SAS Web Report Studio

Select Play Button to advance to the next step (step 5).
Step 5 of the Report Wizard – Define the header and footer
14. Enter Orion Star  Marketing  Data  Mart as the Text for the Report header.

SAS Web Report Studio

Select Paly Button to exit the Report wizard and create the reports.
The report is displayed in the browser. Because the report is grouped by Customer Gender, a table of contents area is displayed on the left to enable users to page between the values.

SAS Web Report Studio

SAS Web Report Studio

Scroll to see both the graph and the table.
15. View information for the next group by selecting Males in the Table of Contents.

SAS Web Report Studio

Across the top of this report preview there are a set of buttons.

Modify Returns to Report wizard for modifications
Options  Provides a choice to either left-align or center the report, and to choose between different styles for the report  
Print      Opens the print properties window
Save Allows report to be saved
Create  New          Invokes Report wizard to start on a new report


The icons at the top of each section provide additional functionality for the section.

Edit    Edit options
Export    Export table/graph
Information    Table/graph information


Save the Report

16. Select Save Button to save the report.
17. Select My folders and specify Customer Sales  Analysis as the Report  name.

Related Page:: Learn New Features of SAS Enterprise Guide 3 from SAS BI.

SAS

Select Save to save the report.

Copy the Report

18. Select the Choose Report tab at the top of the Web Report Studio window, and then select My Folders.

SAS Web Report Studio

19. The Actions button to provides the ability to issue various commands for the selected report.

Actions

20. Select the actions button Drop Down for the Customer Sales Analysis report and select Copy.
21. In the Copy Report window, select Shared folders and then Reports.
      
Copy Report

Select Ok to perform the copy.
22. Choose Shared Folders to verify that the report was copied to this common report area.

Web Report Studio

23. Select the actions button Drop Down for the Customer Sales Analysis report and select Rename.
24. Type in Shared Customer  Sales  Analysis.

Rename Report

Select Ok to rename the file.
The list of reports is displayed showing the new name of the report.

Change SAS Web Report Studio Preferences

25. Select Preference

Preferences

26. Select the Report Creation tab and supply default header text of Orion  Star  Marketing  Data  Mart.

Preferences

SelectOk

27. Select Log off to close out of SAS Web Report Studio.


Subscribe For Free Demo

Free Demo for Corporate & Online Trainings.

Vinod M
About The Author

Vinod M is a Big data expert writer at Mindmajix and contributes in-depth articles on various Big Data Technologies. He also has experience in writing for Docker, Hadoop, Microservices, Commvault, and few BI tools. You can be in touch with him via LinkedIn and Twitter.


DMCA.com Protection Status

Close
Close