Oracle Analytics Publisher

Home› Oracle Analytics› Oracle Analytics Forums› Oracle Analytics Cloud and Server› Oracle Analytics Publisher

Categories

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

generate tabs in xpt template split by dimension

Received Response
39
Views
4
Comments
Jay Blotner
Jay Blotner Rank 2 - Community Beginner
in Oracle Analytics Publisher

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.

Tagged:

Answers

  • Carl Bequilla-Oracle
    Carl Bequilla-Oracle Rank 1 - Community Starter

    Hi @Jay Blotner,

    You may refer to this documentation below specifically on the section 6.7.1.1 Splitting the Report into Multiple Sheets. The example in there is for departments but you should be able to modify it to suit your requirement.

    https://docs.oracle.com/cd/E28280_01/bi.1111/e22254/create_excel_tmpl.htm#ext_multsheets
  • Jay Blotner
    Jay Blotner Rank 2 - Community Beginner

    @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:

    1. I will try to figure out if there is a way to rename the tabs to match the business unit.
    2. 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.
  • Kevin M-Oracle
    Kevin M-Oracle Rank 6 - Analytics Lead

    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
    Jay Blotner Rank 2 - Community Beginner

    @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.

    Report2 Screen Capture for Oracle_Forum.png