Multiprovider--- restricted key figure
i have a doubt like when creating a query on a multiprovider
for eg - a multiprovider is made up of base IC A & B and
can we have a restricted key figure --- by taking the key figure from A Infocube and restricting it by B Infocube Characterstic.
is it possible becoz i have a production order no in one infocube and issue quantity in another infocube so i want to restrict the quantity to the production order.
thanks and regards
no, you can't, you won't get any row data by doing so.
both cube has any common characteristics ?
multiprovider works as union, e.g
charcubeA charcubeB qtyA qtyB
A - 5 -
- X - 10
to get 5 and 10 in same row,
you should have charcubeA value exist in both cube A and B, or remove charcubeA charcubeB from row in reporting,
hope this helps.