on 01-27-2014 12:02 PM
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
84 | |
25 | |
12 | |
9 | |
6 | |
6 | |
5 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.