1 Reply Latest reply on Dec 8, 2016 8:29 PM by Mahfooj Khan

    Refresh Extract - With Custom SQl & Date parameter used

    Santhosha BG

      Hello Everyone,

       

       

      I have used Custom SQL with UNION all to only required Column's from 3 tables. with few conditions in Custom SQL & DATE PARAMETER.

       

       

      Problem Statement.

      Now i have to create Extract with Refresh schedule.

      - Everyday data is appended

      - Customer can choose any date in last 2 years(now we have only 8 months data)

      - I'm stuck in creating extract or refreshing extract (In server it shows only for one date data, as Parameter is not auto update)

       

       

      Need your help.