In Cognos 8 Framework Manager, I have 2 views - the database view and the business view. I do NOT want to rename any fields in my database view, so I will always merge into a query subject before any table makes it to the Business View.
If I merge a table that has relationships into a new Query Subject for the Business view, Cognos will ask if I want to "Recreate these relationships" in the merged query subject.
If I select "Yes", it will create another relationship object, such that there are now 2 relationships - one with the original database view item and one with the new merged query subject item.
If I select "No", it will not create another relationship object, but the underlying relationship still exists, because the new query subject references the database view table, which has a relationship.
My question is this: Why does it matter? Why would I want to select Yes or No? If the relationship is underlying, what is the benefit of recreating it, and having two relationship objects?
I ask because I would rather NOT have relationships in my Business View unless there is a good reason to - this is just too confusing. I'd rather keep all relationships in the database view. Please advise/
