Inventory and sales data from flat files

Hello Friends,

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 doesn’t exist in Inventory flat file, I couldn’t get sales quantity in the report.

Can someone shed some light ?

Thanks

Priya