package

[Tool_Tip]

Dear all,

We have oracle package named as pack1.prod wherein we always pass one parameter as ID.

So, we have created our fact table in qliksense which has same ID and we need to pass this ID to this oracle package to get its respective values.

pack1.prod has column like ID, profit, margin so for each ID we have respective calculation on profit and margin now we want to display this profit and margin column to our fact table.

Fact table had ID column as well as some other dimensions tables.

So lets say we have 2000 unique ID into fact for which we need to get respective profit and margin by calling oracle package.

Kindly let us know how can we get it

[Tool_Tip]

Hi 

I tried to run the query as below :

select * from table (pack1.prod ('1464757576'));

it is working fine so its does mean permission issue.