OTBI Analysis – Field Not Aligning to Data

David Oldfield

Hello,

I am attempting to create an Analysis within OTBI for Oracle Recruiting Cloud (ORC) - attaching the catalog file for reference.

Although, there is one field which is returning the expected data for each Candidate, but its not being aligned correctly with the other data/fields within the report.

For example, it should provide the result/grade obtained for each subject:

Instead, in just duplicates each of the results within each Course/Subject line as follows:

Does anyone have any ideas or suggestions on how I can resolve this issue?

Moving the field around the current data set does make any difference, nor does adding two fact fields from each of the corresponding work areas.

Appreciate the time and assistance.

ORC Report.zip

David

David Oldfield

Analysis XML.txt

Analysis XML

David Oldfield

Apologies, I have managed to resolve internally.

David