If you are unable to create a new account, please email support@bspsoftware.com

 

News:

MetaManager - Administrative Tools for IBM Cognos
Pricing starting at $2,100
Download Now    Learn More

Main Menu

Building Dimensional model

Started by Srik, 27 Sep 2007 04:51:17 PM

Previous topic - Next topic

Srik

Hi All,

How to build Dimensional model using framework Manager ? If someone can provide step by step it would be of great help.

Thanks in advance

Kanth.

phoenixfire

Hi...
--first of all...create a new project
--select a location
Dont worry about the repository thing right now...its a little advanced...u can learn it when u get  familiar with FM
--select the language for the project..u can change this or add more languages later..
--select the metadata source, then the database u need
and finish...
u created a model..

now...a few additional things...
-- its better to create two different views (these are nothing but folders) import view and business view.
Import view contains all the imported data source query subjects
Business view contains all the query subjects needed for the model. such as the ones created by you...etc...

In order to import data, you right click on the model, or the import view folder and click run metadata wizard...

Let me know if you need additional info...