Oracle Transactional Business Intelligence

Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture

Show Parent Data in Excel Template

Question
22
Views
0
Comments

Hi, everyone!

This could be an easy/tricky question but, so far, I couldn't find a solution.

I'm trying to build an Excel template. I need to display in a sheet all data from EMPS branch from this example:

However, in the same sheet, I need a column to display parent DEPARTMENT_ID from each EMPS record. I inserted a repeating group, but I don't know how to reference data from parent branch.

Any thoughts?

Thanks in advance!