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

Regarding Relationships in FM

Started by saumil287, 08 Apr 2011 12:21:01 AM

Previous topic - Next topic

saumil287

Hi All,
I created a datasource in ms sql server and imported the metadata which is having the relationships. So I want to know whether it is necessary to create a star schema of the imported tables or should I directly create a package and publishes it
Yours suggestions is appreciated.
Thanks in advance

blom0344

It depends..

Are you importing a perfectly modelled starschema? Do you want to add calculations, do you want to change dataitem names?
Best practice would be to use a modelling layer to insulate changes between imported objects and those used for reporting