on 11-02-2016 8:19 PM
I have a graphical calculation view named "TestView" which uses two input parameters (
START_DATE_FINAL and END_DATE_FINAL)
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!
User | Count |
---|---|
86 | |
10 | |
10 | |
9 | |
6 | |
6 | |
6 | |
5 | |
4 | |
3 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.