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