0IC_C03 and how is 0TOTALSTCK calculated??
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