on 05-25-2006 2:58 AM
Hi all,
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
neelu
hi Neel,
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.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi A.H.P
thanks for the info...
but i am a bit confused...so i am giving my problem a bit more clear...
cube A -- 0PRODUCTION ORDER
CUBE B--- 0ISSUEQTY
IN MY REPORT I WANT TO HAVE THE QUANTITY FOR EACH PRODUCTION ORDER DISPLAYED IN A ROW...(WHICH IS NOT POSSIBLE AS YOU GUYS SAID)
I HAVE A MATNR IN THE BOTH THE ODS SO CAN I USE THIS MATNR CHARACTERSTIC TO GET THE QUANTITY FOR THE PRODUCTION ORDER IF YES PLEASE SUGGEST ME A WAY TO DO IT.
LIKE SHALL I RESTRICT THE CUBE B KF WITH MATNR ( IF YES TO WHICH MATNR IS IT TO THE CUBE A OR CUBE B)
PLEASE SUGGEST ME A WAY SO THAT I CAN HAVE A REPORT
THANKS AND REGARDS
NEELU
Neel,
I misinterpreted the question completely.I was wrong
-Doodle
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
83 | |
24 | |
12 | |
9 | |
7 | |
6 | |
5 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.