topic Re: how to load SQL Functions into Sense? in App Development

how to load SQL Functions into Sense?

NZFei — Sun, 11 Jun 2017 21:18:25 GMT

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

Re: how to load SQL Functions into Sense?

NZFei — Sun, 11 Jun 2017 23:08:25 GMT

My colleague has figured it out.

The script should be:

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

Re: how to load SQL Functions into Sense?

gianpaolo_31 — Wed, 12 Dec 2018 05:45:19 GMT

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')
;

Re: how to load SQL Functions into Sense?

gianpaolo_31 — Tue, 15 Jan 2019 04:57:51 GMT

Hello Everyone,

Any help on this?

Thanks.