1 Reply Latest reply: Jun 11, 2017 7:08 PM by Fei Xu RSS

    how to load SQL Functions into Sense?

    Fei Xu

      Can anyone help me with this please?


      I have had a look at this discussion at Call a function in SQL LOAD but still don't understand.

      I would like to use an example so if I have a SQL function called v_PNL, how can I load the data into Sense? What is the script in Sense data load editor?



      v_PNL (@nmonth int, @year int, @lastYear int)

      SELECT * from v_PNL (11, 2017, 2016)






      Thank you very much!