Oracle Transactional Business Intelligence

Home› Oracle Analytics› Oracle Analytics Forums› More Solutions› Oracle Transactional Business Intelligence

Categories

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

Reference Relationship in BI Publisher

Received Response
211092
Views
5
Comments
Gaston van de Weijer
Gaston van de Weijer Rank 1 - Community Starter
in Oracle Transactional Business Intelligence

Content

Hi,

I created an interview which loads data about a certain order - it then needs to go into boxes and I need to create shipping labels

1. The user adds an instance 'the box' and enters dimensions and more information. 

2. I created a relationship from 'the box' to 'the item' called 'the debrief item in the box'

3. I added this relationship to the entity collect screen, so you can check which items will be in the box.

4. The data overview displays exactly what I want:

5. However, I cannot get this in BI publisher. I want an overview of items per box, however, I can't seem to pull this off. Once I create a 'for each' for every box, I can't add another 'for each' in there. I can't seem to add the items in this overview..

How do I create a report with BI publisher with a page for a box and a list of items in the box below? 

Version

19B

Tagged:

Answers

  • Brad Tuckett-Oracle
    Brad Tuckett-Oracle Rank 1 - Community Starter

    Currently there's no way to use relationships when adding fields to forms as OPA does not provide that data to BI Publisher.

    (Also you were correct to post this in the OPA forum - unfortunately comments have been locked on that topic so I cannot reply there!)

  • Fiona Guy-Oracle
    Fiona Guy-Oracle Rank 1 - Community Starter

    You could infer a new child entity though and populate it with the data you need. 

  • Gaston van de Weijer
    Gaston van de Weijer Rank 1 - Community Starter

    I was already afraid this was the case, even though the documentation states that I should name the relationship to use it in BI Publisher later on... guess a functionality that doesn't exist yet?

  • Gaston van de Weijer
    Gaston van de Weijer Rank 1 - Community Starter

    I've got an average experience with OPA but inferring entities is not one of my strong sides. 

    I'd assume that I'd have to create a child entity 'the packed item' (e.g.) and a rule that states that 'the debrief item is a member of the packed item if the debrief item is in the box' - or something like that? 

  • Benjamin Arnulf-Oracle
    Benjamin Arnulf-Oracle Admin

    I will try to find a product manager to look at this request.