cancel
Showing results for 
Search instead for 
Did you mean: 

How to pass variables ( NOT INPUT PARAMETER ) in script based calculation view - SAP HANA

Former Member
0 Kudos

HI,

I would like to know how to get total number of  employees for departments. How to achieve this in SAP HANA Script based calculation view ?

example :-  Select  Count(*) from emp where dept in ( <I need to pass the variable here > );

I would like to pass departments ( eg  'A','B','C','D') into the above sql ( In Script based calculation view )

Regards

Sayan Paul

Accepted Solutions (1)

Accepted Solutions (1)

former_member182302
Active Contributor
0 Kudos

Hi Sayan,

I just posted the answer in the other thread where you asked me.

One more thing, you cannot reference variable in a script based calculation view as it doesn't have something placeholder.

Regards,

Krishna Tangudu

Answers (0)