Oracle Analytics Publisher

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

Data not being picked by XML generated by the Data Model

Accepted answer
21
Views
5
Comments

Hi,

Suppose , I have a column called attachment name in my data model along with other columns . But remaining columns have data , but attachment name column there's no data for the first five rows and then there is data in 6th row and 7th row . It's not consecutive. It might be present for those invoices where the end-user has decided to attach an image.

Since it's not in the first five rows, it's not being picked up in XML.

What do I do?

I would really appreciate any help.

Thanks

Best Answer

  • Jorge Marañón-Oracle
    Jorge Marañón-Oracle Rank 3 - Community Apprentice
    Answer ✓

    Hello Jayashree,
    You can find it on the Data Model Properties (Left side panel).
    There is a section "XML Output Options", there's the "Include Empty Tags for Null Elements" checkbox.

    Jorge

Answers

  • Kevin M-Oracle
    Kevin M-Oracle Rank 6 - Analytics Lead

    If you just need a sample data set, increase the rows in the DM data tab view 10 or 20….

    Then view and export.

    Rgds,

    Kevin

  • User_HYV61
    User_HYV61 Rank 1 - Community Starter

    Hi Kevin,

    Thanks for the reply.

    Tried that too , didn't work

    Is there checkbox for "Include Empty Tags for Null Elements" in XML Output options at the properties level of a data model? Is this option still available in the current version of fusion?

    thanks,

    much appreciated,

    Jayashree

  • Kevin M-Oracle
    Kevin M-Oracle Rank 6 - Analytics Lead

    Hi Jayashree,

    Yes that checkbox is still available and valid.

    Kevin

  • User_HYV61
    User_HYV61 Rank 1 - Community Starter
    edited May 23, 2025 4:27AM

    Hi Kevin,

    Could you guide me through it? Where do I find the properties in the 25b version.

    Thanks so much again