BEx Ristrictions please

Dear BW Mates

<b>I am designing a query from a multiprovider which is based on DP and SNP cubes.

The user wants the values(stock quanties and etc) with territory wise. But from APO the values are maintained with Location and product wise. (Multiple plants are combined to one APO location.)

Ex. Territory: Benulux, again Benelux is a group of countries Belgium and Netherlands.

When I drag the Territory infoobject in rows and all key figures in columns, displays zeros for all territories.

Please suggest me..

Sudhakar.</b>