Print Page - How to create DMR Model in Framework Manager step by step proccess.

Title: How to create DMR Model in Framework Manager step by step proccess.
Post by: gouravatalkar on 20 Sep 2010 10:34:00 PM

hi guys i have following tables with following column:

1) Product_table--> Product_key, Product_line,Product_family,Product_category,Product_name
2) Region_table--> Region_key, Region,Territory, Country
3) Store_table--> Store_key,region_key,Store_type,Store_city,Store_add,Store_manager
4) Period_table--> day_key,Full_date,year,Quarter,Month_name,month_no,
5)Sales_fact--> store_key,Product_key,day_key,Amount_sales,Unit_sales

I need to create a DMR Model with above data base i can create the relational model easily this data source contains snowflake schema

Please give me step by step process for creating it. so that next time with different data base i can create it.

Title: Re: How to create DMR Model in Framework Manager step by step proccess.
Post by: blom0344 on 22 Sep 2010 03:45:20 AM

FM user guide offers a detailed explanation on how to create dimensions and measures. In your case you can merge Regio and Store query subjects into a new query subjects to reduce snowflaking. However, DMR works equally well with snowflakes schemas, provided you set cardinalities right..

COGNOiSe.com - The IBM Cognos Community

IBM Cognos 8 Platform => COGNOS 8 => Framework Manager => Topic started by: gouravatalkar on 20 Sep 2010 10:34:00 PM