ITPub博客

首页 > Linux操作系统 > Linux操作系统 > about aggregation and non-cumulative of key figure

about aggregation and non-cumulative of key figure

原创 Linux操作系统 作者:solisnail 时间:2011-08-27 16:57:44 0 删除 编辑

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/,如需转载,请注明出处,否则将追究法律责任。

请登录后发表评论 登录
全部评论

注册时间:2011-04-07

  • 博文量
    18
  • 访问量
    22098