Compare (Minus/Except) on data sets
What I have:
I would basically like to do a minus (or except) on the data so that my report only displays the data that doesn't match. I know there are workarounds with Microsoft i.e. linked servers or exporting the data set from one server to another and uploading it to a temporary table and performing the query. But is there any way to do this within BI publisher?
Microsoft SQL Server 2008
IBM DB2 for iSeries
Connections setup in BI Publisher
Data Model with data sets from both DBs
What I am wanting:
I currently am exporting data from the Microsoft DB loading it to a table on the iSeries and doing a comparison that way. However, I have end users that will be the ones wanting the output and I am not wanting to have to manually export and import the data every time they want to run a report. That's why I'm hoping the BI Publisher can handle this. Or maybe someone has another suggestion?
0