2 Replies Latest reply: Jun 12, 2013 7:38 AM by ayubjanishaik RSS

    Column Not Found when Using Multiple Excel Files as Data Sources

    940986
      Hi all,

      I'm using BI Publisher as part of OBIEE 11.1.1.6.9.

      I have 2 Excel files: AccountName.xls and AccountBalance.xls. I create 2 data sets using those 2 Excel files (Workbook is Local instead of Shared).

      AccountName (G_1) structure:
      Code_1
      Name

      AccountBalance (G_2) structure:
      Code_2
      Balance

      Code_1 from AccountName (G_1) is then linked/joined to Code_2 from AccountBalance (G_2).

      After saving, and I want to generate the XML sample file, I got error:
      XML Parsing Error: mismatched tag. Expected: </img>.
      Location: http://192.168.1.16/xmlpserver/servlet/xdo
      Line Number 2, Column 580:<table style='background=colo ...

      After checking the log in the FMW Enterprise Manager, the error says "Column Code_1 not found" and "Column Name not found". Any idea why and how to solve this issue?

      The thing is, if I only use 1 data set from each of those Excel files, I am able to generate the sample XML file. So, has anyone ever tried joining 2 Excel files as data source?

      Please help. Thank you very much!