How to use Stored Procedures in Infolinks (Data on demand)

This approach is good when you deal with a lot of data that you don't want to load everything in memory, but instead, load the data by chunks, depending on the user selection. This way, users can select what data to load when the analysis opens for the first time (for example last year sales) or while selecting markers on a visualization. 

From the Information Designer window:
  1. Data source: Expand Server->schema -> procedure name (right click)-> New -> Procedure (save)
  2. Library (Element tab): Saved procedure (right click)->New-> Information Link (Save)
From Spotfire Client
  1. File ->Add On-Demand data Table -> choose Information link ->define Input for each parameter (fixed value/property/expression/marking etc)
Previous
Next Post »