- IBM Cognos TM1 Developer's Certification guide
- James D. Miller
- 167字
- 2021-08-06 19:59:04
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.
- Java逍遙游記
- The Supervised Learning Workshop
- Microsoft Exchange Server PowerShell Cookbook(Third Edition)
- 零基礎(chǔ)學(xué)Scratch少兒編程:小學(xué)課本中的Scratch創(chuàng)意編程
- 程序員考試案例梳理、真題透解與強(qiáng)化訓(xùn)練
- Django Design Patterns and Best Practices
- Mastering Ubuntu Server
- INSTANT Django 1.5 Application Development Starter
- Getting Started with Gulp
- C語言程序設(shè)計
- 學(xué)習(xí)OpenCV 4:基于Python的算法實(shí)戰(zhàn)
- Developing SSRS Reports for Dynamics AX
- SciPy Recipes
- 邊玩邊學(xué)Scratch3.0少兒趣味編程
- Python+Office:輕松實(shí)現(xiàn)Python辦公自動化