Blogs

Blogs

Using Stored Processes to Improve Information Maps

4
By

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:

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!

Tags business intelligence Information Maps Stored Processes
Share

About Author

Angela Hall

Senior Technical Architect

Angela offers tips on using the SAS Business Intelligence solutions. She manages a team of SAS Fraud Framework implementers within the SAS Solutions On-Demand organization. Angela also has co-written two books, 'Building BI using SAS, Content Development Examples' & 'The 50 Keys to Learning SAS Stored Processes'.

4 Comments

  1. KD on

    Hi ,

    Great article indeed , but i have some implementation doubts.

    if i define the filter in the .sas STP code "a macro...&filter_var", how can i passe the user selected value from WRS to .sas code without defining it in the IMap.

    i have a requirement where the user will select from multiple / single value from one field and single or no value from other field.
    Base on these filter condition the a subset dataset should be created from the whole big dataset.

    This dataset should be again used information map studio to calculate a custom data element.

    the value of this custom data element with others will be used to render a graph.

    was wondering if all these can be done ? can you suggest any approach ?

    can this be alone done using only

    Thanks
    KD

    • Angela Hall
      Angela Hall on

      KD,
      When you define parameters on a stored process and then add this stored process to an information map, the tool (whether its within SAS Information Map Studio during your testing or through SAS Web Report Studio) automatically surfaces the parameters (or prompts) to the user.

      You don't have to believe me :) but SAS has an 'official' KB entry that explains how to do this too & its been available since SAS 9.1.3sp4.
      http://support.sas.com/kb/33/146.html

Back to Top