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:
we get the balance qty as below:
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/，如需转载，请注明出处，否则将追究法律责任。