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

Lokanath_Reddy

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

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

Lokanath_Reddy

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

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

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

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

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

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

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