This discussion is archived
2 Replies Latest reply: Jun 12, 2013 5:38 AM by ayubjanishaik RSS

Column Not Found when Using Multiple Excel Files as Data Sources

940986 Newbie
Currently Being Moderated
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!

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points