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

Cross subject area - on which facts are they joined?

Received Response
edited Jun 30, 2021 1:48PM in Reporting and Analytics for ERP 2 comments


Hi there

I have joined two subject areas 

- Expenses - Expense Transaction details real time
- Workforce Management - Work Relationship Real time

to get level 2 department from the Workforce management.

I think that I'm able to see that it's Person number from Workforce management SA and Employee Number from Expenses SA, that are joined... But I can't seem to find it documented anywhere...

I have issued the sql in the administration-part of OTBI and gotten the log on level 2... But it isn't obvious to me, which fact-columns are joined according to the log... 

I would think that there should be a where-clause somewhere, that says "where Employee Number = Person Number", but I cant find it...


Howdy, Stranger!

Log In

To view full details, sign in.


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