I am currently trying to do a mash up with a transactional SQL table and do a V-Lookup type function to return additional fields from an Excel data source to populate for each record we capture in our CRM.
I've attempted to use Nexel, however, I'm doubtful that this is solution to this project. I've created 2 separate Cubes, one for each data source and have attempted various Hierarchy combinations. The current issue is that the Excel Data Source fields from my Data Reader are loading but not populated into the DataView.when combined with the SQL Cube.
Attached are various screen shots showing the current Hierarchy and Cube Structures.
Any assistance with this greatly appreciated.