General OBIEE

Get Involved. Join the Conversation.


    Gaston van de Weijer
    Reference Relationship in BI Publisher
    Topic posted October 22, 2019 by Gaston van de Weijer, tagged BI Publisher, BI Publisher Report Templates, Report Output 
    33 Views, 4 Comments
    Reference Relationship in BI Publisher


    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? 




    • Brad Tuckett

      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!)

      • Gaston van de Weijer

        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?

    • Fiona Guy

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

      • Gaston van de Weijer

        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?