You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

Count number of employees submitted response in PERSON EFF (OTBI Count)

Hi All,

We have developed a Person EFF, and we require an OTBI report that can count the number of employees who submitted their response in the Person EFF (Self Identification as shown in Screen Shot 1).

We need data in two columns:

  • Business Unit Name
  • Number of employees submitted a response

We need to count the number of employees whose Effective Start date under Self Identification is not null, as shown in the Screen Shot 1

However, as seen in Screen Shot2, we are receiving the same number for each business unit.

Screen Shot1


Screen Shot2


XML Code:

<saw:report xmlns:saw="com.siebel.analytics.web/report/v1.1" xmlns:xsi="

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!