Oracle Business Intelligence

Ability to display repeating section across the page (from left to right) in OTBI report.

Submitted
152
Views
8
Comments

Description

Currently in OTBI report (BI Publisher Report) we can only display the repeating section from top to bottom, need an option to display the repeating section from left to right.

Use Case and Business Need

Business needs a report to display the product build quantity at product group, yearly/quarterly level. For a given product family there will be multiple product groups and these product groups data should be display side by side for further analysis/presentations. 

Currently we can only display the repeating group from top to bottom, due to this users need to spend lot of time to make report in the required format manually. 

 

Original Idea Number: e91856d90b

Repeating_group_across_page.png

3 votes

Submitted · Last Updated

Comments

  • Glen Ryen
    Glen Ryen ✭✭✭

    Hi Lokanath,

    Have you looked into writing your own Logical SQL in OTBI, or creating a BI Publisher report based upon the OTBI Subject Area you're interested in seeing? There are ways to pivot rows to columns in SQL, so I believe this is something you should be able to accomplish today. It won't be end user drag-and-drop, but a good report developer should be able to get it done for you.

    Hope that helps,

    Glen

  • Hi Glen,

    Thanks for your reply.

    I have created BI Publisher report using data model (procedure call). I will try to pivot rows to columns and create report. Will post the update.

     

    Regards

    Lokanath

     

  • Glen Ryen
    Glen Ryen ✭✭✭

    BIPublisher gives you control over the SQL, so I think that should work for you. You may get better performance if you can extract the physical SQL from your original OTBI Analysis and pare that down to just the essential columns and base tables, but hopefully that's not a concern for you. Pulling from the OTBI Subject Area may ease maintenance, if not. Good luck!

    Glen

  • Hi Glen,

     

    Just wanted to clarify that I was not using the OTBI Analysis for report, was developing the report in BI Publisher only. I see there is no option/functionality available to repeat the group across the page with in BIP layout designer.   

    Thanks

    Lokanath

     

  • Glen Ryen
    Glen Ryen ✭✭✭

    Hi Lokanath,

    Ok, sorry for the confusion. You mentioned OTBI in the question, so that's what made me think you were pulling from a subject area. But if this is BIP only, you might have an option to do it in the layout. There is some pivot functionality there, but I haven't personally used it.

    What I was suggesting was modify your Data Model SQL - transpose your rows to columns there and the layout should be straightforward. Does that make sense?

    Glen

  • Hi Lokanath,

    we have a similar requirement in our project. can you pls let me know if it is possible to display the data across the page. if yes can you please share the sample RTF for reference.

  • Hi Lokanath,

    we too have a similar requirement in our project . can you please let me know if this is possible to display data across the pages. if yes can you please share the sample rtf which would be really helpful

    Thanks,

    Ilakkiya

  • Did anybody ever accomplish this task. I need it now.