- 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語言實現(原書第2版)
- 精通API架構:設計、運維與演進
- C語言程序設計立體化案例教程
- 算法訓練營:提高篇(全彩版)
- Mastering Android Development with Kotlin
- 運用后端技術處理業務邏輯(藍橋杯軟件大賽培訓教材-Java方向)
- C陷阱與缺陷
- Machine Learning for OpenCV
- The Statistics and Calculus with Python Workshop
- Python數據預處理技術與實踐
- HikariCP數據庫連接池實戰
- Elasticsearch實戰(第2版)
- Illustrator CS6中文版應用教程(第二版)
- 邊做邊學深度強化學習:PyTorch程序設計實踐
- Mastering PyCharm