about aggregation and non-cumulative of key figure

Note some message about the key figure:non-cumulative and ggregation, which was set in the key figure tab 'Aggregation' 。

Non-cumulative ： It set the field which will not be cumulative depending on some characteristic values, instead it is considered with the reference to time(always date:0calday). For example: as a inventory scenario, the inventory cube stores the material movement:

Date	qty
2011-01-01	100
2011-01-02	10
2011-01-03	-20
2011-01-04	50
2011-01-05	-50
2011-01-06	30

we get the balance qty as below:

Date	Balance
2011-01-01	100
2011-01-02	110
2011-01-03	90
2011-01-04	140
2011-01-05	90
2011-01-06	120

There are two types of non-cumulative key figures: Delta Movement Key Figure and Seperate Inflow and Outflow Key Figure.

When a non-cumulative key figure becames part of a cube, it becames a non-cumulative cube. We can set the validity table by Extras->Maintain non cumulative value in administrator workbench, the table was auto maintained, you can edit it in RSDV. For the example, the validity of the date was from 2011-01-01 to 2011-01-06. If request the query not in the validity, the result would be blank.

I still confused about the Aggregation:

1.Aggregation(standard). Set the key figure how to aggregated.

2.Exception Aggregation. Set the key figure aggregated with the reference characteristic.

There were also BEx aggregation too.

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/22792542/viewspace-705962/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/22792542/viewspace-705962/