Misalignment Candidate selection process phase and state between OTBI and UI

Summary:

Content (required):

Hello Guys,

We would create a report that show for each Candidate selection process Phases and States the correct number of application. By creating the analysis we see that the phase and the state are misaligned between UI and OTBI, Why it happen? Is there a way to find some documentation in order to solve the problem?

I m attaching the screenshots and the catalog files, I hope in your help.

Best Regards,

Giuseppe

Version (include the version you are using, if applicable):

Code Snippet (add any code snippets that support your topic, if applicable):