Reporting and Analytics for ERP

Get Involved. Join the Conversation.

Topic

    Thiru Vedantham
    Changes to BIP report are not reflecting
    Topic posted September 25, 2019 by Thiru Vedantham, tagged BI Publisher, Fusion Financial reporting, OBI Answers, OBIEE Answers, OTBI, Reports, Sample Reports 
    47 Views, 3 Comments
    Title:
    Changes to BIP report are not reflecting
    Summary:
    Changes to BIP report are not reflecting in the data. We have changed few columns in the Dataset but the report output displays old column data.
    Content:

    Changes to BIP report are not reflecting in the data. We have changed few columns in the Dataset but the report output displays old column data.

     

    For eg:

    we were displaying Party number which was changed to Supplier number. The output still shows party number.

    The table has correct data and the SQL returns the correct data when run separately as a SQL query.

     

    Following is one of the data sets in the data model:

     

     

    Version:
    Oracle Business Intelligence Product Version 11.1.1.9.0
    Code Snippet:

    Comment

     

    • Senthilrajan Vaithianathan

      Hi

      You need to update report as well, edit the report and add the additional columns.

      Or create a new report with all the columns.

      -Senthil

    • Santosh Kumar Bhairi
      You may want to check if the report template still references to old columns. If it is rtf template, check column properties as well.
    • Noelle Bartlam

      As you put in your original posting - "displaying Party number which was changed to Supplier number. "

      Modify your template and change the field in the template from Party number to the new Supplier number.

       

      Noelle