Mashup Between SQL and Excel Data Sources

Previous Member

Greetings,

 

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.

 

Thanks!

Ford 

Previous Member

Hi Ford Reid,

I guess you don't have the information of your Excel file in the database. That would mean you could replace your "VLOOKUP" with a simple SQL join. Now having put the obvious aside, let's look at the problem at hand.

 

When looking at the hierarchy and the Excel data Reader I am missing the "link". Ideally in that datareader you'd have one column from the SQL data source and another from the Excel data source so that the information can combine.

For example "SS Marking Source" + "TGS Source" (the latter with append) + your other columns DID, Source, Campaign, Sub-Type (all as append). If I'm missing something here let me know.

BR, Ray