1 Reply Latest reply: Nov 14, 2012 4:54 PM by 973870 RSS

    Problem Joining Excel Files in Data Model OBIEE 11.1.1.6

    user10174749
      Good afternoon --

      I am attempting to build a data model in BI Publisher in OBIEE 11.1.1.6. 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.