官术网_书友最值得收藏!

Aggregations

One of the key things to understand is that TM1 will quickly and efficiently aggregate numeric element values for your reporting.

For example, consider a simple calculation such as aggregating (or rollup) the values of a group of accounts into one amount. This is accomplished through aggregation. Aggregation is automatically applied in TM1 while building a dimension using something called hierarchies.

A hierarchy is a way to organize data at different levels of aggregation.

It is important to understand that aggregation calculations will be based upon each element's "weight". IBM refers to this as the element's weight factor. Weight factors determine the contribution of an element to a consolidation.

The default element weight is one.

Just about any weight factor can be assigned to an element and it is not uncommon for an element to have a negative weight factor, causing it to be subtracted from the total aggregation amount. Therefore, to show a negative value, a developer can assign a negative weight to an element.

主站蜘蛛池模板: 喀喇沁旗| 精河县| 河池市| 焉耆| 建昌县| 鄱阳县| 屯昌县| 建昌县| 宜黄县| 新密市| 利辛县| 漠河县| 阿瓦提县| 墨江| 凤山市| 建水县| 长泰县| 苍溪县| 彭山县| 奎屯市| 吉首市| 惠来县| 贺州市| 班玛县| 焉耆| 武城县| 太白县| 兴安县| 沙雅县| 奉节县| 北辰区| 和顺县| 奉化市| 怀集县| 鄱阳县| 阜南县| 策勒县| 新绛县| 大方县| 沁阳市| 大丰市|