1 Reply Latest reply on Nov 14, 2012 10:54 PM by 973870

    Problem Joining Excel Files in Data Model OBIEE

      Good afternoon --

      I am attempting to build a data model in BI Publisher in OBIEE When I upload a single Excel workbook as a data source, things work great. But if I import a second workbook that contains a mapping of a key value in the first spreadsheet to a detailed description and join on the key, nothing works. I receive an XML parsing error if connecting from the second workbook to the first, and an empty data set ("<DATA_DS></DATA_DS>") if I make the connection in the opposite direction.

      Any ideas out there? I have looked everywhere and apparently I am alone in having this problem?

      Best regards,
      Jason S.