Skip to Content
0
Former Member
May 24, 2010 at 01:43 PM

0IC_C03 and how is 0TOTALSTCK calculated??

722 Views

Hello!

I want to know how 0IC_C03 cube works. Because i get strange results. I want users to track stock on any day they chose (as I understand this cube provides this functionality).

So far I have initialy loaded DS

- 2LIS_03_BF (compress, NO marker update ticked)

- 2LIS_03_BX (compress, NO marker update not ticked)

- 2LIS_03_UM (compress, NO marker update ticked)

As I know so far is that this cube is somehow special and to get total stock on given day it calculates it on the fly.

I ubderstand for example: 0TOTALSTCK is defined with aggregation as LAST and calcualted with 0RECTOTSTCK - 0ISSTOTSTCK.

With report 0IC_C03_Q0013 I get correct result for total stock for last loaded day (as this day is also the opening that comes with BX datasource). But to get stock on other days I get strange results.

I will give short example from listcube table:

0CALDAY 0ISSTOTSTCK 0RECTOTSTCK Z_STOCK z_stock_kum

29.12.2009 0 5160 5160 5160

20.1.2010 200 0 -200 4960

25.1.2010 1000 0 -1000 3960

26.1.2010 320 0 -320 3640

11.2.2010 1000 0 -1000 2640

16.2.2010 200 0 -200 2440

18.2.2010 120 0 -120 2320

24.2.2010 1000 0 -1000 1320

25.2.2010 0 12000 12000 13320

2.3.2010 280 0 -280 13040

22.3.2010 1000 0 -1000 12040

19.5.2010 0 12040 12040 24080

Z_stock and z_stock_kum are excel calculated (to check that stock is calculated OK). At beginig I have 5160 stock and at the end I have 12040 stock. To me, this data seems correctly written to table as how I understand this cube works.

In report 0IC_C03_Q0013 I get following presentation if I include characteristic 0CALDAY:

-


0CALDAY 0TOTALSTCK

28.12.2009 -12.040 KG

29.12.2009 -6.880 KG

....

19.01.2010 -6.880 KG

20.01.2010 -7.080 KG

...

24.01.2010 -7.080 KG

25.01.2010 -8.080 KG

26.01.2010 -8.400 KG

...

10.02.2010 -8.400 KG

11.02.2010 -9.400 KG

...

14.02.2010 -9.400 KG

15.02.2010 -9.400 KG

16.02.2010 -9.600 KG

17.02.2010 -9.600 KG

18.02.2010 -9.720 KG

19.02.2010 -9.720 KG

....

23.02.2010 -9.720 KG

24.02.2010 -10.720 KG

25.02.2010 1.280 KG

26.02.2010 1.280 KG

27.02.2010 1.280 KG

28.02.2010 1.280 KG

01.03.2010 1.280 KG

02.03.2010 1.000 KG

....

21.03.2010 1.000 KG

22.03.2010 0 KG

23.03.2010 0 KG

...

18.05.2010 0 KG

19.05.2010 12.040 KG

TOTAL 12.040 KG

-


(I replaced inbetween same values with dots)

If I then restrict 0CALDAY<=Variable_Date I don't get corect result. For example on 0CALDAY<=31.03.2010 I get result 0 and it should be 12040. What am'I doing wrong?

Please help!!

Sorry for strange editing, but does this forum support any more userfirendly editing for long texts?

tnx Gorazd

Edited by: Gorazd Firm on May 24, 2010 3:50 PM