Traditional web-based reporting with SAS BI tools

Web Report studio

Reply
New Contributor Sid
New Contributor
Posts: 4

Web Report studio

Hi,

Can somebody tell me whether it is possible to run WRS on relational database?
I know it runs on informations maps. But we wanted to know whether it is possible to create reports from WRS without creating information maps?

We can run stored process in WRS...so can that stored process use SAS/Access to access data directly from relational database rather than Metadata server or Information maps??

Really would appreciate your inputs...kind of urgent as we are stuck at this point! Message was edited by: Sid
Super Contributor
Super Contributor
Posts: 3,174

Re: Web Report studio

I have no personal experience on this topic-point, however I believe you can use SAS Web Reporting Studio (WRS) indirectly with relational databases. You may find these links from the SAS support website http://support.sas.com/ useful - I found them using the SEARCH facility on the main webpage:

Designing Information Maps for Ad Hoc Reporting
Diane Hatcher, SAS, Cary, NC
http://www2.sas.com/proceedings/sugi29/104-29.pdf


http://support.sas.com/documentation/cdl/en/biwaag/61238/HTML/default/a002994053.htm

http://www2.sas.com/proceedings/sugi31/013-31.pdf


Scott Barry
SBBWorks, Inc.
SAS Employee
Posts: 149

Re: Web Report studio

Sure: if you didn't want to create information maps, you can write a stored process that uses SAS/Access to connect to the DBMS table(s) you need. That stored process can then be surfaced in Web Report Studio. You can also surface that stored process directly in the Information Delivery Portal as well.

It's only using the WRS report objects like list, crosstab, bar chart, etc. that need you to have an information map as the underlying data source. The advantage of using the Bar Chart report object as opposed to creating a stored process which displays a bar chart is that the one with the Bar Chart report object is much more interactive. I can filter, sort, change data items on the fly when viewing a Bar Chart report object. The only interactivity in a stored process comes from the parameters you define ahead of time.
SAS Employee
Posts: 238

Re: Web Report studio

In order to run any report in Web Report Studio (using the report objects such as list, crosstab, line graph, etc), you must have an Information Map. However that Information Map could point to a Stored Process or any Defined Library/Table in SAS Management Console (which could consist of any number of DBMS, including Teradata, Oracle, Base SAS, SQL, SAP, EXCEL, etc).

Zencos Consulting
http://www.zencos.com Message was edited by: sas-bi.blogspot.com
SAS Employee
Posts: 224

Re: Web Report studio

I'm moving this to the new Web Report Studio forum. I hope this new forum will be helpful for you and other Web Report Studio users.
Thanks for using the forums!
Occasional Contributor
Posts: 5

Re: Web Report studio

I created a view in base SAS then registered the view in metadata for use in an information map. When I create the report in WRS the data is as live as the DBMS is. The only down side is the larger the table gets the slower the view returns data. That's the closest you can get that I know of without using a Stored Process.
Ask a Question
Discussion stats
  • 5 replies
  • 311 views
  • 0 likes
  • 6 in conversation