Posts

Explain about Cognos TM1 Server certificate and its operation

Image
  IBM Cognos TM1 is an Analytical web Processing (OLAP) software tool that analyzes data stored during a database. IBM Cognos TM1 may be a client-server environment that stands for "Tables Manager 1". A TM1 developer also can build complete planning, budgeting, and forecast models in an analysis application. Its advice is to research the info consumption to eight dimensions. It consists of remote TM1 servers such as: TM1 Architect, Client, Web Client Perspectives What is a cube in TM1? A TM1 cube may be a multidimensional database containing a minimum of two dimensions and one fact. The data loaded into the cube, making use of a mediator process. Each cube can expand to look at all the sizes that structure the cube. There are few types of cubes in TM1 Standard  Control cubes can manage the data structures inside the cube. Virtual cubes can’t display the cube but it views the quality of it. Lookup cubes used when it starts searching for data structures to access its specified

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