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

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.

主站蜘蛛池模板: 陕西省| 聂拉木县| 内乡县| 台北市| 永春县| 玉林市| 滨州市| 大洼县| 麦盖提县| 当雄县| 友谊县| 旺苍县| 抚顺市| 汉中市| 芮城县| 章丘市| 博客| 乌兰浩特市| 永胜县| 稷山县| 郎溪县| 枣庄市| 黄冈市| 醴陵市| 武平县| 沁阳市| 绥棱县| 罗田县| 磐石市| 永德县| 郯城县| 平顺县| 资溪县| 民丰县| 宁波市| 宜宾县| 溧阳市| 历史| 石门县| 宜川县| 大足县|