on 02-07-2008 1:18 AM
Hi all!!
I have this issue..
Im loading all the information about inventory in BW; all the information is right, but i have this situation:
Some values and quantities are between square brackets, this happend when consult information historical for example; I run my query from 01.10.2007 to 29.02.2008 and when display by month in the query I see:
Material 1 for October
Quantity 500 Value 2000
Material 1 for November
Quantity Value with square brackets
Material 1 for December
Quantity Value with square brackets
Material 1 for January
Quantity Value with square brackets
Material 1 for February
Quantity Value with square brackets
The same caracteristic is that in the months to november to february I dont have stock; the last month for this stock was october.
I revised the properties for negatives in query; and this not the problem, and the quantities are positve not negative.
I hope someone can help me
Greetings,
Mónica
Edited by: Mónica Elizondo on Feb 6, 2008 7:18 PM
Edited by: Mónica Elizondo on Feb 6, 2008 7:19 PM
Hi together,
although this discussion is very old maybe someone is searching for an solution.
OSS note 1501907 - Non-cumulative cubes, validity interval,non-cumulative logic describes the appearance of the square brackets.
Regards,
Daniel
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Monica,
Add one CKF in your query having formula as -1*qty.
If values in this ckf is coming without bracket then this may be th problem of -ve values.
regards,
Mahendra
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
73 | |
26 | |
10 | |
9 | |
7 | |
6 | |
4 | |
4 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.