Cognos tutorias

  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 ...

  Filter: It is nothing but a condition to restrict the data to be displayed on the report There are two types of filters Model filter Report filter Model filter: If a filter is created at the time of designing model then it is called a model filter Model filters are reusable Report filter: A filter which is created at the time of generating the report is called a report filter Report filter is specific to that particular report only Again model filters are two types Stand alone filter Embedded filter   Stand alone filter: It is created at name space level it is available as a separate object in the model It can be applied for any query subject in the model Stand alone filters are two types Static filter Dynamic filter (or) parameterized filter (or) prompt   Static filter: If a filter condition is created with a static value that can’t be changed at run time than it is called a static filter   Syntax to create static filter: Query time (column) operator operand. EX: ...