BEx Query on Multiprovider

Hello BW Guys,

I am creating a BEx Query on a Multiprovider (ZHR_MULTI) which include one Infocube (ZHR_HRM1) and one Infoset (ZHR_HRM5).

The infoset contains 'Employees Master Data' and the infocube contains some master data and 2 Key Figures (Headcount and Movements). The requirement is to create a query on multiprovider using the 'Employee Master data' (which is in Infoset) based on a key figure 'Headcount' (which is in Infocube).

When i tried to run the query, I don't get any data for 'Headcount'. Can anybody help in this.

Regards

Rajat