Oracle Analytics Publisher

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

Issue with a BIP report output, where column headers & column values are mismatching

Accepted answer
75
Views
4
Comments
Ismail_70
Ismail_70 Rank 3 - Community Apprentice

Hi All,

I am facing an issue with BIP report output where The column header and column values are mismatching.

Example : A column Posting_Date the expected value is a date but i am getting a text.

Further I noticed that when we remove the Description column from report logic the data mismatch issue is not there, but we need description column as well.

So, can any one help me with your inputs. Thanks.

Best Answer

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

    Hi @User_R2WZN

    Download some sample xml data from data model and then try to use the BIP template viewer tool to validate your RTF template so that you can able to get some more information where its causing the issue.

    Regards,

    Arjun

Answers

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

    Hi @User_R2WZN

    Can you double check your data types of the columns used and mapping has done properly at design level?

    Regards,

    Arjun

  • Ismail_70
    Ismail_70 Rank 3 - Community Apprentice
    edited July 2024

    Hi @Mallikarjuna Kuppauru-Oracle ,

    Thanks for your input.

    I have created and new RTF template for the report and also tried with system generated template , but it is still an issue.

    Regards,

    Ismail.

  • Gayathri Ajith
    Gayathri Ajith Rank 1 - Community Starter

    Hello

    Can you please mention how did you resolve this?

    Thanks,

    Gayathri