I am getting sales data and inventory data in two flat files and wanted to see both inventory and sales data in the report.
So I have created a MultiProvider on both sales and inventory cubes.
In the report, I am restricting inventory data for actual and forecast quantity via transaction data coming within the inventory flat file.(Ex:Transaction 10)
In the same query, I wanted to see the sales quantity by restricting transaction data coming from sales file (Ex: Transaction 11).
That means object name is same for both Sales and Inventory cubes,but data is different.
I wanted my report to look like this.
Ex: Material Actual Qty Planned Qty Sales Qty
Currently I get Actual and Planned quantity but not the Sales quantity. Since transaction 11 data doesnt exist in Inventory flat file, I couldnt get sales quantity in the report.
Can someone shed some light ?