Posts

Showing posts from October, 2020

Explain about Cognos TM1 feeders

Image
 The IBM Cognos TM1 calculation engine uses FEEDERS to help manage sparsity in cubes with SKIP CHECK enabled. There may be rule calculations for certain cubes, but they are extremely small or dense and may not need SKIP CHECK,More info go through Cognos TM1 Course . Feeders FEEDERS classify the cells in a cube which may contain a measured value based on a rule and ensure that these values are included in the calculation of the aggregation. SkipCheck SKIP CHECK is a keyword entered at the top of a rule file that makes the sparse data consolidation algorithm of TM1 possible. Usually, cubes using SKIP CHECK would require FEEDERS, another keyword entered in a rule file later on. For more on SKIP CHECK, please refer to section 2.3. Why FEEDERS for use? OLAP cubes can be very sparsely populated as it is very important to handle data within TM1 cubes. Examples of problems facing the construction of the TM1 Cubes are below. Example 1- Cube Sales Take a sales cube with the following dimensions

Cognos TM1 rules editor

Image
  Using the rules of TM1, you can do the following. To calculate totals based on business rules, perform multiplication of cells. Override automatic consolidation of TM1 when necessary. Using data in one cube to measure or exchange data between cubes in another cube. Allocate the same values for multiple cells,More info go through  Cognos tm1 course  Blog. Cognos TM1 rules editor If you try to use the Rules Editor while .Net 3.5 SP1 is not properly enabled, errors can occur. You may use TM1 Server Explorer to access the Rules Editor. Right-click on the cube (the cube for which you want to define a rule) and select Build Rule from the menu If there are no rules associated with this cube already. If one or more rules already exist for this cube, you can pick Edit Rule. Upon savin g  the rules file, TM1 rules are compiled one by one. When it finds the first rule compilation error, TM1 ceases compiling rules. Compilation of Cognos TM1 For instance, you would perform the following steps if

IBM Cognos Transformer

Image
In this lesson, we will discuss The IBM Cognos Transformer IBM Cognos Transformer IBM Cognos Transformer is a simple tool for modeling dimensional hierarchies and levels for PowerCubes. We can use this data modeling tool or component to create a model, a business presentation of the information in one or more data sources. A model can contain any number of regular or calculated measures, together with logical groupings that use measure folders.     Cognos Transformer After you choose a supported product locale (language), add dimensional metadata, specify the measures(performance indicators) and apply custom views, you can create PowerCubes based on this model. You can deploy these cubes to support OLAP reporting and analysis.A regular measure is numeric data in a transactional data source. A calculated measure is new numeric data that is derived from other measures, functions, and constants, such as Profit, which is calculated from the measures Revenue and Cost.A measure folder can gr