IBM Cognos bi-add business logic for the model

Typical business logic, such as filters and computations, are often applied in the business view. In some cases, implementing these business logic makes sense, and its performance and maintenance costs are very low.

Add filter for Model

Two filter formats for IBM Cognos framework Manager (FM:

Embedded filter (embedded filters): it is created inside the query topic and their fields are restricted to the query topic. It is appropriate when the filter is used on only one query topic or dimension, after an embedded filter is created, it can be converted into an independent filter (stand-alone filters ).

Stand-alone filters: An Independent filter can be used throughout the Model. When the filter is required for multiple query topics or dimensions, or the used filter is more accessible to users, the independent filter is suitable.

Each embedded filter has a usage setting, which has the following options:

Always (always): all instances are used no matter whether the query item is in the query or not.

Optional (optional): the filter is not mandatory. You can enter a filter value or leave it empty.

Design Mode only (in design mode only): This option limits data only when tested in IBM Cognos FM or report design.

 

Add computing for the model

Computing can be used to query projects, parameters, and functions

There are two types of Computing:

Embed the calculation: embedded directly into the object. If you want to create a computing task for a query topic or dimension, you can use embedded computing, this calculation either queries the topic of the data source or queries the topic of the model. However, we recommend that you apply computing to the topic of the model query as much as possible, because this allows better maintenance and change management.

Stand-alone calculation: it is appropriate to create an independent calculation when you apply computing to more than one query topic and dimension; or if you need to execute aggregation before computing, it is also appropriate to perform independent computing. Such aggregation can be done by changing the general aggregation attribute of Independent Computing to computing.

 

Use macro commands to make the model dynamic

You can use session parameters, parameter maps, and macros to modify the query topic and other model attributes to dynamically control the returned data.

Session parameters: the session information is returned at runtime;

Parameter maps: a list of two key-value pairs;

Macros: A code segment that can be inserted into objects such as filters, computation, and familiarization. It can be evaluated during runtime. Macro commands are surrounded by # symbols.

 

 

Here we only talk about some conceptual things. The specific cases need to be produced in practice. I have also made some cases, but it takes a lot of time to sort them out or understand them, let's explore it by yourself.