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

BI Publisher Report not returning SOME values for a column - data exists in the sample data.

Accepted answer
223
Views
12
Comments
JPorisVU
JPorisVU Rank 3 - Community Apprentice
edited June 20 in Oracle Analytics Publisher
DatawithValues.xml
OutputFromInternalTemplate.xlsx

We have a BI Pub report that is showing data not populating on some of the rows. The values exist in the code result, sample data, XML. However when added to the internal template builder, these certain rows do not return. I built a Word rtf template and the data returns without issue.

Has anyone else encountered this with the internal template builder and/or have any ideas as to what might cause this?

ETA: XML and Output

Tagged:

Best Answer

  • JPorisVU
    JPorisVU Rank 3 - Community Apprentice
    Answer ✓

    The Word Template workaround is a successful and accepted alternative, albeit with slightly limited functionality (i.e. no Interactive output option.) We will continue to monitor all reports to see if this issue recurs as a more widespread issue.

Answers

  • Mallikarjuna Kuppauru-Oracle
    Mallikarjuna Kuppauru-Oracle Rank 8 - Analytics Strategist

    Hi @JPorisVU

    What is your BIP version and are you using the template builder which comes as per BIP Desktop installation?

    Regards,

    Arjun

  • JPorisVU
    JPorisVU Rank 3 - Community Apprentice

    Hello Arjun

    We are on bipublisher_11.1.1

  • Mallikarjuna Kuppauru-Oracle
    Mallikarjuna Kuppauru-Oracle Rank 8 - Analytics Strategist

    Hi @JPorisVU

    Can you try below template as reference and let me know the result?

    BlankExcelTemplate.xls

    Regards,

    Arjun

  • JPorisVU
    JPorisVU Rank 3 - Community Apprentice

    We are good with an external template — I built it out in Word. It's the internal template builder that's causing the issue. Attaching the XPT file for reference.

    SampleXPT.zip

  • Mallikarjuna Kuppauru-Oracle
    Mallikarjuna Kuppauru-Oracle Rank 8 - Analytics Strategist

    Hi @JPorisVU

    Okay issue with Interactive report, did you saved the Data model sample data before column mapping at report level? can you double check .

    Regards,

    Arjun

  • JPorisVU
    JPorisVU Rank 3 - Community Apprentice

    Yup. Sample data saved. The example only includes ID rows that should be returning the values but aren't, but the values are returning for other IDs.

  • Mallikarjuna Kuppauru-Oracle
    Mallikarjuna Kuppauru-Oracle Rank 8 - Analytics Strategist

    Hi @JPorisVU

    I have tested your xml data and report is working as expected. seems like issue with your development end.

    Can you do below -

    1. Create DM using your XML data file.
    2. Save the DM data
    3. Create an Online report and see are you able to see as below?
    image.png

    Regards,

    Arjun

  • JPorisVU
    JPorisVU Rank 3 - Community Apprentice

    Still not working. This is making no sense with it not being every row. May I ask which version of BI Publisher you're using?

    Also — this is in OAC (Classic Home) not OTBI. Not sure if that would make a difference.

  • Mallikarjuna Kuppauru-Oracle
    Mallikarjuna Kuppauru-Oracle Rank 8 - Analytics Strategist

    Hi @JPorisVU

    I used the Oracle Analytics Cloud (OAC) - March 2024 (patchset) and i am able to see the data.

    Regards,

    Arjun

  • JPorisVU
    JPorisVU Rank 3 - Community Apprentice

    Thank you for confirming. Looks like we're on the May 2024 patch. I'm going to go through those notes to see if there's anything that might've have inadvertently triggered this.

  • Mallikarjuna Kuppauru-Oracle
    Mallikarjuna Kuppauru-Oracle Rank 8 - Analytics Strategist

    Hii @JPorisVU

    Any update on this Thread ? If you are fine with responses can you conclude the same after accepting the correct response.


    Regards,
    Arjun