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

Issue creating RTF Template using Non-standard SQL Data Model

Received Response
14
Views
1
Comments
KDR
KDR Rank 4 - Community Specialist
edited Jul 31, 2025 4:47PM in Oracle Analytics Publisher

I have created a new Data Model in Fusion BI Publisher that uses Non-standard SQL and I have that functioning at intended.

image.png

However when I try to create the report template layout I am having an issue. After saving the Data Model and also saving Sample Data, If I select "Generate RTF layout based on selected Data Model." option I give it a name and then I receive this session expired error:

image.png

I've tried this in multiple browsers and the behavior is the same. When this happens the other navigation buttons become disabled and the only way to come out of here is by using the browser's back button.

The only way I can get a report template generated is from the Data Model itself by clicking 'Create Report' and then build a report from the template guide/wizard.

image.png

Is this some bug or how else am I able to generate an RTF template? I know using the Non-standard SQL type in the Data Model changes some of the XML structure of the output. If anyone can help me understand this I would appreciate it.

Alternatively if anyone has a sample data model and RTF template they are willing to share I may be able to gleam from that.

Tagged:

Answers

  • Riyaz Ali-Oracle
    Riyaz Ali-Oracle Rank 6 - Analytics Lead

    Hi @KDR,

    Try the below:

    Instead of using the “Generate RTF layout” button, follow this approach:

    1. Create Report from Data Model
      Go to your Data Model.
      Click Create Report.
      Use the Report Wizard to generate a basic layout.
      Save the report and download the sample XML data.
    2. Design RTF Template Manually
      Open Microsoft Word with the BI Publisher Desktop plugin.
      Load the sample XML.
      Use Table Wizard or manual fields to design your layout.
      Save the .rtf file and upload it to the report definition.

    Thanks,
    Riyaz Ali