Oracle Analytics

Get Involved. Join the Conversation.


    Carley Howell
    BI Publisher - data in XML but not in template
    Topic posted October 16, 2018 by Carley HowellRed Ribbon: 250+ Points, last edited September 11, 2019, tagged Reporting 
    BI Publisher - data in XML but not in template

    Hi all,

    I'm having some problems with a BI Publisher report, where data is shown in the "View Data" tab for the columns I want to use and in the exported XML that I'm using to build the report (see point 1 in attachment), but won't come through to the template (see point 2 in attachment).

    Despite there being data in the XML for these metrics, when previewing the template, all values are 0.0 (this is due to an IFNULL value that has been entered on the "Structure" tab in the data model, without that it was returning nulls) (see point 3 in attachment).

    The repeating group I am using also seems to be causing some issues, without it at least some data is returned (see point 4 in attachment) however, as soon as it is added, we go back to the output shown in point 3. The repeating group can be seen in point 5 in the attachment. This is set up in the same way we have used in other versions of this report, all of which work as expected.

    The strange thing is that we have multiple versions of this report which all use a SQL query and RTF template that is 99% the same as this one with the problems, and they all work fine. Only difference is the dimension we are looking at is at a lower level in the hierarchy.

    Has anyone had a similar problem? 

    Many thanks for any help!