General OBIEE

Get Involved. Join the Conversation.

Topic

    Stephanie Burghardt
    Excel report is grey and no data is visible
    Topic posted November 13, 2019 by Stephanie Burghardt, tagged BI Publisher, BI Publisher Report Templates 
    32 Views, 4 Comments
    Title:
    Excel report is grey and no data is visible
    Summary:
    When generating an Excel with BI Publisher the file is grey and no data is visible.
    Content:

    After generating an Excel file with the BI Publisher the sheet is grey and the data is not visible. But the data is there and can be seen in the small field in the header. After saving and reopening the file the sheet looks normal.

    What is wrong here?

    Version:
    Oracle BI Publisher 12.2.1.1.0 (build:20160526.2332)
    Image:

    Comment

     

    • Noelle Bartlam

      Stephanie

      A couple of additional questions:

      1)  How are you generating the output?  Meaning, is this an export of a report viewed online, an output of a scheduled job, etc.

      2) What version of excel are you using?

       

      Thanks

      Noelle

      • Stephanie Burghardt
        Hi Noelle,
        
        1.) The report is generated in an application using the BI Publisher as an interface.
        
        2.) The Excel version which is used is the 14.0.7237.5000 (32 bit).
        
    • Fernando Ponte

      Hi.

      Does this started happening after and update in the report or started happening with no changes applied? It can be the Report Template got "corrupted" in some way or a formatting was changed?

      Are you able to create a new Report template on the same report (not duplicate the current one) and check the export again?

      Cheers

      Fernando

    • Rajasekhar Bandaru

      Hi

      1.Are you able to view data properly while Editing Datamodel-->Click on Data tab

      2. Can you please download sample data xml and upload to the Template using BI Template Builder and check.