Thank you for clearing the confusion on wording @Gianni Ceresa. your interpretation is accurate.

Thanks for the whatever help you have provided here. I thought I provided all necessary details to the community to look in to and help with expert advice. I am referring here to OBI analyses(Subject Area) where both analysis are it's own report.

I have mentioned in my previous reply to @Christian Berg that the reports are using OTBI subject area.

I have created below report Report #1 Job Code Grade 0011200223003340044500556 where each job code has it's defined Grade information. now the Report #2 shows employee level information . Employee# Job Code Grade 123400112567800245 where the Grade values need an audit based on the Report #1 Grade value based on Job code…

Version : Oracle Business Intelligence 11.1.1.9.0 This is through OTBI Subject Area, which is similar to OBIEE analysis.