Integrating Stored Processes into Information Maps can improve process performance as well as provide extra flexibility and complete query generation control. In order to showcase how powerful this combination is, I am presenting this topic during a SAS Talks webinar session this Thursday, December 16th. The scope of the example will be to replace implicit with explicit queries to a RDBMS, however combining stored processes with information maps can prove useful in other arenas as well.
Some Examples of Possible Stored Process use within Information Maps:
- Connecting to RDBMS http://blogs.sas.com/content/bi/2009/06/12/utilizing-sql-pass-thru-within-sas-information-maps-to-improve-web-report-studio-performance/
- Querying an OLAP Cube to allow for prompting (pre 9.2) http://support.sas.com/documentation/cdl/en/olapug/59574/HTML/default/viewer.htm#a003076738.htm
- Utilizing existing SQL queries rather than going through the Information Map Relationship tab builder http://support.sas.com/kb/39/432.html
- Taking prompted values into account to refine the resulting database query http://support.sas.com/kb/33/146.html
I'm sure with some creativity, you can think of other reasons to join these two components together for performance improvements. Register for the webinar & join me this Thursday to discuss how & why to use Stored Processes more often!