Semantic model vs custom dataset joins for manager headcount

Jestin Rajan

Hi everyone,

I’m building an Oracle Analytics dashboard and hitting limitations with dataset joins.

Setup:

* Dataset A: Recognition data (Office, Team, Compensation Manager) — includes some terminated employees

* Dataset B: Unique award recipients (same grain)

* Dataset C: Active headcount (Office, Team, Compensation Manager)

Requirement:

Show, by Compensation Manager,

recognized colleagues, total active headcount

Problem:

When joining on Office + Team + Compensation Manager, headcount drops because Dataset A doesn’t have all manager combinations / team codes / office codes. Adding dummy rows would blow up the data.

Questions:

1. Is the Semantic Model RPD the better approach for this multi-fact scenario?

2. Any documentation or step-by-step guide to bring custom datasets into the semantic model and implement this correctly?

(Note: I used AI to help refine this problem statement for clarity.)

Thanks in advance!