Reference Relationship in BI Publisher

Question

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

Benjamin Arnulf-Oracle · Answer

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

Gaston van de Weijer · Answer

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?

Gaston van de Weijer · Answer

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?