Skip to Content
avatar image
Former Member

How to read data from graphical calculation view with input parameters in SQL transform?

I have a graphical calculation view named "TestView" which uses two input parameters (


In my data flow, I am using a SQL transform with the below select statement. It works if i hardcode the dates like this.

SELECT column1, column2 FROM "_SYS_BIC"."TestView"('PLACEHOLDER' = ('$$START_DATE_FINAL$$','2016-08-01','$$END_DATE_FINAL$$','2016-08-10'))

But i want to replace the hard coded values with 2 options.

Option 1:

START_DATE_FINAL - this should be passed as sysdate-1

END_DATE_FINAL - this should be passed as sysdate

Option 2:

Similarly i need another job or this same job that should run on every 1st day of month to pull previous months data . for eg: if the job runs on 11/1/2016 it should pull data from the view where start date = 10/1/2016 and end date = 10/31/2016.

START_DATE_FINAL - 10/1/2016

END_DATE_FINAL - 10/31/2016

Can someone please help me how i can do this? I am very new to data services so i would appreciate if the solution is explained in detail steps. Thanks in advance!

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

0 Answers