Traditional web-based reporting with SAS BI tools

report refresh - running sas code

Reply
Occasional Contributor
Posts: 16

report refresh - running sas code


Hello,

I am pretty new by web report and I want to know if the refresh bottom could actually make the sas code run again.

I made a project in EG and exported the report to web studio. I can see it there but I would like to web report run the project again and display the new values when I refresh the report (refresh bottom). When I refreshed the report now this is not happening, is it possible to have something like that?

Thanks!

Daniela

Frequent Contributor
Posts: 120

Re: report refresh - running sas code

I don't really understand how you export the report to wrs, but one way to do this is to create a stored process from the EG-projekt and then use that sp in an information map. This imap is then usen in wrs and the sp will run everytime you refresh the report.

Check:http://support.sas.com/kb/33/146.html

Occasional Contributor
Posts: 9

Re: report refresh - running sas code

When you run a report from EG, it creates a static report, just an image of rows and columns.  If you are publishing a report to Information Delivery Portal, then you want to directly access the source data, and use Information Maps and Web Report studio to build the report.  That said, if it is a very complex report, you may be stuck.

So, is the data set upon which all this is based registered in the SAS metadata repository?  That would be the first necessary step.

Once the data set is registered in the repository, you can then build an information map off the data set.  This lets you create calculated columns, make joins among multiple tables, format column headings, etc.  Information maps can only be built off registered data sets.

Next, use the information map as the data source for a report in Web Report Studio.  Build the report that you want to display to your users from the information map.  Save the report.

Finally, add the report to a portlet in Information Delivery Portal as either a report portlet (where the user will be able to see the report when they open the page) or as an item in a collection portlet.

There are a lot of concepts involved here - registering a data set in the metadata repository, information map studio, etc.  However, this approach will result in a truly dynamic report directly linked to the source data set. Every change in the source data set will be reflected in the web report.

Occasional Contributor
Posts: 7

Re: report refresh - running sas code

Instead of doing all these once your development is completed create the stored process then call it from  WRS. So, when you tried to refresh from WRS automatically it will refresh the data in back end.

Occasional Contributor
Posts: 16

Re: report refresh - running sas code

Many Thanks!!

Ask a Question
Discussion stats
  • 4 replies
  • 438 views
  • 3 likes
  • 4 in conversation