topic Re: Web Report studio in SAS Web Report Studio

Web Report studio

Sid — Thu, 19 Mar 2009 16:35:34 GMT

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

Re: Web Report studio

sbb — Fri, 20 Mar 2009 13:26:13 GMT

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.

Re: Web Report studio

RichardH_sas — Mon, 23 Mar 2009 16:00:10 GMT

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.

Re: Web Report studio

AngelaHall — Sat, 07 Nov 2009 11:53:04 GMT

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

Re: Web Report studio

reneeharper — Mon, 09 Nov 2009 14:24:48 GMT

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!

Re: Web Report studio

cgerdvil — Tue, 10 Nov 2009 03:36:40 GMT

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.