Mar 24, 2014

Data table with stored procedure (with parameter) in spotfire

You can use stored procedure in information link instead elements in Information Link, Note: we cannot find the parameters in information link when you create but, when you add this info link through "Data on Demand" it prompt you to assign parameter values. Steps below Information Designer: 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) File ->Add On-Demand data Table -> choose Information link ->define Input for each parameter (fixed value/property/expression/marking etc)