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

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.

主站蜘蛛池模板: 修文县| 凌云县| 将乐县| 盐源县| 纳雍县| 梧州市| 深州市| 井陉县| 云浮市| 鸡泽县| 囊谦县| 大丰市| 新巴尔虎右旗| 秦皇岛市| 沾益县| 灌阳县| 阳江市| 浮梁县| 铜山县| 楚雄市| 黄山市| 松原市| 寿宁县| 恭城| 大洼县| 松江区| 西和县| 永仁县| 休宁县| 光泽县| 灌南县| 平谷区| 阜康市| 乐都县| 壤塘县| 吉安市| 涡阳县| 萍乡市| 平谷区| 雅安市| 虞城县|