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

[gouravatalkar]

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.

[blom0344]

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