Creating De-Normalized Model Query Subject from the Normalized Data Source in Cognos Framework Manager

Creating De-Normalized Model Query Subject from the Normalized Data Source in Cognos Framework Manager

Normalization is the process of organizing columns and tables of a relational database to reduce data redundancy, insertion anomaly, update anomaly and delete anomaly. Snowflake data sources are the best examples for Normalized data sources in which each dimension is defined as several related tables.

In the below example, “PRODUCT” dimension has a normalized structure with four physical tables. It means, each Product Line contains one (or) more Product Types. Each Product Type contains one (or) more Products. And, each Product contains multiple language descriptions.    

In Cognos Framework Manager, we can create a single logical de-normalized structure using a model query subject. While defining model query subject, choose the appropriate columns from all the four tables and make the dimension simplified for reporting.