Oracle Transactional Business Intelligence Idea Lab

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

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

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
3 votes

Submitted · Last Updated

Comments

  • Glen Ryen
    Glen Ryen Rank 4 - Community Specialist

    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

  • Lokanath_Reddy
    Lokanath_Reddy Rank 1 - Community Starter

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

    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

  • Lokanath_Reddy
    Lokanath_Reddy Rank 1 - Community Starter

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

    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

  • User_CTDSJ
    User_CTDSJ Rank 1 - Community Starter

    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.

  • User_CTDSJ
    User_CTDSJ Rank 1 - Community Starter

    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

  • user2277494
    user2277494 Rank 1 - Community Starter

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