BIP - Display values horizontally or left to right — Oracle Analytics

Oracle Analytics Cloud and Server

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

BIP - Display values horizontally or left to right

Received Response
171
Views
5
Comments

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

image

Regards

Kriparam

Answers

  • Thomas Dodds
    Thomas Dodds Rank 8 - Analytics Strategist

    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
    Venkat Thota - BIP Rank 7 - Analytics Coach

    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
    Maraprik Rank 4 - Community Specialist

    Thanks Thomas, let me try this.

  • Maraprik
    Maraprik Rank 4 - Community Specialist

    Thanks 2807661, let me try this.

  • Venkateshkamaths
    Venkateshkamaths Rank 2 - Community Beginner

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