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