how to load SQL Functions into Sense?

[NZFei]

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!

Cheers

Fei

[NZFei · Accepted solution]

My colleague has figured it out.

The script should be:

SQL Select * from Databasename.dbo.FunctionName (variable1, variable2);

[gianpaolo_31]

Hi All,

I successfully executed the script but it returned no results.

Please help. Thanks.

Func:
Load *;
SQL select *
from DatabaseName.dbo.Report_ShipmentProfileReport
(null,null
,null,null,null,null,null,null,null,null,null,null,null,'2018-05-04','2018-05-31')
;

[gianpaolo_31]

Hello Everyone,

Any help on this?

Thanks.