BookmarkSubscribeRSS Feed
Stephane
Quartz | Level 8
Hi,

Background : I build a program that simulate a customer behavior under constraints. At the end of the simulation the result data are loaded within an Oracle table. Several reports on WRS show these results.

Let say that a SP contains the simulation and finally update this ORACLE table. I imagine that I have to link this SP to the map of my reports. When my users will open the report, the SP will update the ORACLE table and the reports will be updated with the new data. Right ?

Now, let say that my SP needs input parameters that the users have to fill when they open the reports. This is my constraints.

Is it possible to have a SP+parameters linked to a map called by the report ? I mean, when my users will open the report on WRS, do WRS will show in a first step a page with the parameters to fill, execute the simulation based on these constraints and finally show the reports ?

Stéphane.
1 REPLY 1
Greg
Calcite | Level 5
Hi Stephane,

of course you can use a information map based on a Stored Process (with ou without parametres). If there is parameter(s), the user of your report will be prompt at the execution time.

Greg

hackathon24-white-horiz.png

2025 SAS Hackathon: There is still time!

Good news: We've extended SAS Hackathon registration until Sept. 12, so you still have time to be part of our biggest event yet – our five-year anniversary!

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.

SAS Training: Just a Click Away

 Ready to level-up your skills? Choose your own adventure.

Browse our catalog!

Discussion stats
  • 1 reply
  • 1052 views
  • 0 likes
  • 2 in conversation