cancel
Showing results for 
Search instead for 
Did you mean: 

Stock quantity and value with square brackets [ ]

Former Member
0 Kudos

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

Accepted Solutions (0)

Answers (2)

Answers (2)

daniel_halbauer
Explorer
0 Kudos

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

Former Member
0 Kudos

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

Former Member
0 Kudos

Hi Mahendra,

Thanks for the reply.

I aggregated the key figure, but the result is that obtein is in brackets too. Only with sig negative but in the brackets.

Thanks again,

Monica