generate tabs in xpt template split by dimension

Question

Is there a way to split output into separate tabs based on a specific dimension, dynamically?

My specific example is that one of the report columns contained is a dimension called "Business Unit".

I want to have a separate tab created for each business unit that may arise in the output.

Generating tabs dynamically is important. For the "Business Unit" dimension values can change, become inactive, not show up since there may be no activity for a period, etc..

Thank all for your help.

Jay Blotner · Answer

@Carl Bequilla-Oracle

Hello, I followed the resource link you shared. Can you kindly assist further? My problem now:

I am now getting the separate tabs with labels but they are not populating data (even though there should be).

Only the first excel tab is capturing all the BUSINESS_UNIT

Here is the RTF with tag.

I am trying to break by dimension BUSINESS_UNIT per page , and the label of the tab should be BUSINESS_UNIT.

I initially did insert Repeating Group (and indicated BUSINESS_UNIT) and below tag gets me label.

Any further troubleshooting would be appreciated.

Kevin M-Oracle · Answer

The features for Excel output splitting data into worksheets is documented for RTF not XPT layouts.

See:

https://docs.oracle.com/middleware/bi12214/bip/BIPRD/GUID-A229808F-D2F6-458E-8E52-9E7FA156FF0E.htm#BIPRD3325

Rgds,

Kevin

Jay Blotner · Answer

@Carl Bequilla-Oracle

Thank you for the reply and documenation, however the reference material is for xls templates. I was looking for use of the online xpt template. I was able to figure it out. I inserted a repeating section group by Business Unit AND inserting a page break INSIDE the grouped repeating section.

Now, I have 2 items to figure out:

* I will try to figure out if there is a way to rename the tabs to match the business  unit. 
* Also, dropping a page break inside the grouping, I get them broken out by Business Unit per tab, but also get an extra blank tab at the end I need to get rid of.