BIP - Display values horizontally or left to right

Maraprik

Summary

BIP - Display values horizontally or left to right

Content

Hey Gurus,

Version OBIEE 12c - 12.2.1.2.0

BIP 12c

DB -Oracle 12c

Question

Customer has a formatted report in Access which displays rows from left to right. It has a couple of fields which repeat from left to right as the values get populated. They want us to do this in BIP

Employee_ID  Location ID    Employee_ID  Location ID

11                     1212              14                  1215

12                     1213              15                  1216

13                     1214              16                  1217

How do we achieve this in the RTF.

Please let me know if you need more information please take a look at the screenshot

Regards

Kriparam

Thomas Dodds

Not positive how you'd do it via a template, but if you know the max number of rows that will fit on your page (vertically), you could 'cut' the row set by that number and run the data in chunks sorted...

Venkat Thota - BIP

one option is possible,

keep same table (copy) side by side , and place  <?if:count(G_1[position() mod 2=1])!=0?> in front of group in first table , do same for second table but use  <?if:count(G_1[position() mod 2=0])!=0?  in second table. it will display all odd positions in one side of table and even positions in 2nd table , by this you can split data side by side , Thanks

Maraprik

Thanks Thomas, let me try this.

Maraprik

Thanks 2807661, let me try this.

Venkateshkamaths

Instead of copy pasting one can use the sub template and call the same template in all the columns of main template.