BookmarkSubscribeRSS Feed
Sid
Calcite | Level 5 Sid
Calcite | Level 5
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
5 REPLIES 5
sbb
Lapis Lazuli | Level 10 sbb
Lapis Lazuli | Level 10
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.
RichardH_sas
SAS Employee
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.
AngelaHall
SAS Employee
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
reneeharper
SAS Employee
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!
cgerdvil
Calcite | Level 5
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.

sas-innovate-2024.png

Join us for SAS Innovate April 16-19 at the Aria in Las Vegas. Bring the team and save big with our group pricing for a limited time only.

Pre-conference courses and tutorials are filling up fast and are always a sellout. Register today to reserve your seat.

 

Register now!

How to Concatenate Values

Learn how use the CAT functions in SAS to join values from multiple variables into a single value.

Find more tutorials on the SAS Users YouTube channel.

Click image to register for webinarClick image to register for webinar

Classroom Training Available!

Select SAS Training centers are offering in-person courses. View upcoming courses for:

View all other training opportunities.

Discussion stats
  • 5 replies
  • 1327 views
  • 0 likes
  • 6 in conversation