If you are unable to create a new account, please email support@bspsoftware.com

 

News:

MetaManager - Administrative Tools for IBM Cognos
Pricing starting at $2,100
Download Now    Learn More

Main Menu

Count of employees turn up each day

Started by barrysaab, 18 Apr 2015 09:46:39 AM

Previous topic - Next topic

barrysaab

I have fact table which has measures employees present and employees absent and other keys etc date dimension ,There is also another table name employee which has all employees detail name,employee id etc .What I need to get is  daily employees turned up for work each dept wise,along following lines:

one  day information      
Organization   total emp     working cnt
IT                   3000            2148
Branch            2000            1567
      
Our Requirement is  we need Total employee count by Organization and count of employees who came to office daily.Any help  will be appreciated.
Boy! Cognos getting on to me!!!

barrysaab

Thanks,It is solved.Took two data items one for employees present and employee absent and wrote a case statement  by flagging the present and absent employees.
Boy! Cognos getting on to me!!!