nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Oracle Communities

Oracle Analytics and AI

Child Item

Home
Oracle Analytics and AI
Oracle Analytics and AI Labs
More Solutions Idea Labs
Oracle Transactional Business Intelligence Idea Lab

Child Item

Left Outer Join in OTBI

Siddhesh_Nisal

Hi,

There are scenarios in OTBI where we want to all the details of Department which are not mapped to any of the person at Assignment level. so obviously it is not getting picked by the subject area.

Logical SQL can be built but the problem is maintainability of this custom SQL.

Better Left Outer join can be introduced at the OTBI level or segregate Department and other workforce structure from Assignment Real Time.

Regards,
Siddhesh Nisal

Find more posts tagged with

Submitted

OTBI

OTBI Reports

OTBI (Oracle Transactional Business Intelligence)

Status: Submitted

Comments

There are no comments yet