Combining Multiple Manufacturing Subject Areas in OTBI

Summary:

We need to create a single OTBI report by combining data from the Manufacturing – Work Order Performance Real Time and Manufacturing – Work Order Definitions Real Time subject areas.

The requirement is to extract work order performance information along with work order definition details, such as Work Order, Work Order ID, Work Definition, Operation Name, Standard Operation Name, Resource Name, Actual Start Date, quantities, and other relevant manufacturing details.

However, when columns from both subject areas are added to the same OTBI analysis, the columns from the Work Order Definitions Real Time subject area are appearing blank or are not returning the expected values.