Skip to Content
Former Member
Mar 26, 2015 at 01:46 PM

Pass parameter from calculation view to projection



The scenario I'm working on is the following:

I have created a SQL script calculation view that has an input parameter that is used to retrieve data - this SQL script is functioning well based on the value entered in the parameter

Now this SQL script calculation view is to be used in a graphical calculation view because the result sets need to be joined. However, I need to be able to enter the parameter value in the graphical calcualtion view and pass it down to the SQL script calcuation view. The parameter is not used to filter on a column, but is used to determine a 'decision path' in the SQL script in order to dynamically retrieve the correct values based on the parameter.

Any ideas on how this can be achieved? When I add the same parameter to the graphical view, it is not passed down to the SQL script calculation view.