topic Re: report refresh - running sas code in SAS Web Report Studio

report refresh - running sas code

danirecchia — Wed, 06 Feb 2013 15:00:39 GMT

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

Re: report refresh - running sas code

FredrikE — Thu, 07 Feb 2013 15:08:12 GMT

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

Re: report refresh - running sas code

hulllc — Thu, 07 Feb 2013 17:39:04 GMT

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.

Re: report refresh - running sas code

SuneelReddy — Fri, 08 Feb 2013 06:56:14 GMT

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.

Re: report refresh - running sas code

danirecchia — Fri, 08 Feb 2013 12:09:39 GMT

Many Thanks!!