Oracle Analytics Cloud and Server

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

Oracle R12.1.3 XML Publisher XLS Template

Received Response
426
Views
10
Comments

Summary

Oracle R12.1.3 XML Publisher XLS Template

Content

Hi,

 

We have patched Oracle R12.1.3 to allow XML Publisher XLS Template.

And followed BI Publisher: How to create Multisheet in Single Excel file using Excel Template (Doc ID 1352000.1)

The template works and can generate multiple sheet in run time.

Now the user want to add a "static/fixed sheet", a kind of summary.

Like:

Summary Sheet > Supplier Site 1 Sheet > Supplier Site 2 Sheet > Supplier Site 3 Sheet > Supplier Site 4 Sheet > ... > Supplier Site N Sheet >

 

Is it possible?

is there any documentation that explain this?

Tagged:

Welcome!

It looks like you're new here. Sign in or register to get started.

Answers

  • Rank 3 - Community Apprentice

    We already have that in the template.

    Now I want it to generate add 1 fixed sheet.

    The goal is to have 1 fixed sheed and N dynamic sheet.

  • Rank 7 - Analytics Coach

    You mean to say you want each supplier site data in different tab?

    If this is your requirement then you can achieve this by below step

    image

    1. Specify XDO_SHEET_? group name. By specifying group on this excel will generate those many tabs. e.g. in your case you want separate tab for each supplier site.

    2. Specify XDO_SHEET_NAME_?. By specifying this name will generate for each tab. in the above example tab name will be name of the supplier site.

    Regards,

    Brajesh

  • Rank 3 - Community Apprentice

    Thank you Brajesh, I will try your suggestion.

    Before I read your reply I had added the sheet name in column C,  it works in BIPublisher Excel Plugin.

    However, when I uploaded the template into eBS, the summary sheet also repeated N times, probabbly the server component is not certified with that feature.

    I didn't pay attention on the scope, so I will rebuild the template using you suggestion.

    2018-02-16_11-11-28.png

  • Rank 7 - Analytics Coach

    The goal is to have 1 fixed sheed and N dynamic sheet. : What is the issue? we can create one fix sheet and then in new tab we can create sheet for which we can define XDO_SHEET_?  and XDO_SHEET_NAME_? property

    only thing is while defining the name space provide the scope of the field as below

    image

  • Rank 3 - Community Apprentice

    I managed to create a proof of concept RTF template, and when previewed in Word BIPublisher Plugin as "Excel", the output is splitted into multiple sheets.

    However, when I upload the template into the server, the output is combined into one, the same behaviour as in the Word Plugin when "Excel2000" preview is used.

    The document mentioned the output must be in XLSX format, how I configure this?

  • Rank 3 - Community Apprentice

    I found EBS (BI Publisher) R12 : How To Get Excel Output In Multiple Worksheets From A RTF Template (Doc ID 2004454.1), according to which R12.1.3 is compatble.

    The challenge is, how to make it dynamic, because the number of sheets is not predetermined.

  • Rank 3 - Community Apprentice

    I modified the scope, unfortunately it doesn`t change the situation. The Summary sheet is renamed and repeated N times, no rows displayed, which is logic because it uses different group.

    2018-02-16_11-51-20.png

  • Rank 7 - Analytics Coach

    Could you please upload your excel and sample XML please...will try in both Desktop plugins as well as EBS...to find out if its version issue between instances if this is the case we need to raise SR with oracle support to get correct version. But before that we want to sure its version issue

  • Rank 3 - Community Apprentice

    I read some replies from Oracle staffs about the same issue on this forum, it seems the feature is not available on 12.1.3. I need to sanitize the data before I could upload the sample and template, so it will take some time.

  • Rank 1 - Community Starter

    Images are not visible.

Welcome!

It looks like you're new here. Sign in or register to get started.