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

Resolved: Import only relationships in existing FM Model

Started by SGD, 20 Sep 2011 09:11:52 PM

Previous topic - Next topic

SGD

Hi,

Our DBA has created new relationships between few tables in Oracle database. FM model is already been created and works fine.

I want to import only newly created relatioships in my existing FM Model, how can I achieve this?

Thanks in advance.
Regards,
S.G.D.

cognostechie

Do it manually. You should do it like that anyway instead of  letting FM create the relationship by itself. By the way, you should create relationship in the model only if it applies to the model and not just because the DBA created it in the DB. All relationships in the DB need not be in the model.

SGD

Hi Cognostechie,

Thanks for your reply.

Yes, I have applied relationships manually in FM Model.

Those relationships were actually important for reporting purpose eg. Date Dimension & Fact table. Earlier it was overseen by DBA hence he had to update database Model accordingly.
Regards,
S.G.D.