How to get Active employees in SAP analytics cloud

[former_member610804]

Hello all,

I have a employee table with EMPID,Date(Hire,Termdate).

How to get Active employees, New Hires,,avg tenure months from employee table in SAC.

For Eg Number of employees we will use calculated Editor and aggregate the Dimension.

I am not getting, where to write the formulas for Active employees and ......

Thanks

Vaman

[mfoeken · Accepted solution]

Hi Vaman,

You can create a calculated dimension in the story (or even in the model if you use an import scenario) to 'flag' whether an employee is active, by using an IF function combined with ISNULL.

Kind regards,

Martijn van Foeken | Interdobs

[former_member610804]

Hi Martin,

Thanks for the reply,

Yes we will use if condition in that calculation dimension,

generally we will write condition like IF(ISNULL([d/"HR_schema":TermDate]),"Inactive" ,"Active")

Am i right? if not please correct me.

In PowerBi we use like Active Employees:=CALCULATE([EmpCount],FILTER('HR Data',ISBLANK('HR Data'[TermDate])))

Thanks

Vaman.