Question:
I am loading cube 0PUR_C01 using 2lis_02_itm and 2lis_02_scl.
It appears to me that the “quantity” information is updated using 2lis_02_itm and the “value” information is updated using 2lis_02_scl. The two fields that are critical to me are the “Actual Goods Receipt Quantity” and the “Goods Receipt Value as at Posting Date”.
When I load the data using these two infosources, I get two sets of records in the cube(one set for each infosource)…the record set for 2lis_02_itm has the quantities and the record set for 2lis_02_scl has the values…
however… when I run my query…it only reports one of them (quantity OR value) and the other is 0. I think the query is only displaying the most recent of the two sets of records.
The update rules for the two fields are as follows:
D/S Field Update Type Source Key fig
2LIS_02_ITM Actual G/RQuan Addition 0CURR_GRQTY 2LIS_02_SCL Actual G/RQuan No Update
2LIS_02_ITM G/R Value as at Posting Date
Update Type: No Update
2LIS_02_SCL G/R Value as at Posting Date
Update Type: Addition routine mm_wewrt
I know that both values are in my infocube (I've seen them).
My main question:
How do I get both the Actual Goods Receipt Quantity and the Goods Receipt Value as at Posting Date to be reported on my query?
Answer:
Hey,
Did you activated the process keys in BW IMG in R3..?
Please have a look at OSS 353042.
Let me know if you need some more information
Regards
PR
Answer:
Ammulu,
Yes, the process keys have been activated. Thanks for the note number, it is very infomative.
I know that the values I want to report on are in the cube, the data is loading without errors. I don't understand why the query isn't reporting both of my values.
Example of data in cube (the first record is from 2lis_02_scl, the second record is from 2lis_02_itm):
Doc Num;0CALDAY;0GR_QTY;0GR_VAL
4500047890;02/06/2004;0;2682.50
4500047890;02/06/2004;37;0
Example of query:
Doc Num;0CalDay;0GR_QTY;0GR_VAL
4500047890;02/06/2004;37;0
Example of what I want the query to report:
DocNum; 0CALDAY;0GR_QTY;0GR_VAL
4500047890;02/06/2004;37;2680.50
Any other suggestions?
Sara
Answer:
Sara,
Initially these are two diffrent data sets from two info sources.
Did you checked how the dimensions were mapped to these infosources.
Any changes from BC..?
Give me some time please.
Regards
PR
Answer:
I figured out my problem...(sort of).
I had added the Requested Delivery Date to one of the extractor and not the other, and I was trying to run my query by Requested Delivery date. It wasn't displaying the values because it didn't have any mapping to a requested delivery date.
Thanks for your time and help.
Sara