Relationships are used to create queries on multiple objects in a metadata model. Relationships can be bidirectional and without creating relationship, objects are individual entities with no use in metadata model.
Each object in metadata model is connected using primary or foreign key in the data source. You can create or remove relationships in the metadata model to meet the business requirements.
Cognos - Printing a Report
For example: Each customer has one customer id. For example: Each doctor has many patients.
For example: Each patient has many doctors. It is defined as the number of related rows for each of the two query subjects. The most common ways to define Cardinality is by using the primary and foreign key. You can import many to many relationships, optional relationships, and outer joins from the data source. In the Framework manager, a relation is represented by Merise notation.
What is a Framework Manager?
The first part of this notation represents the type of join for this relationship. To create a Relationship or to combine logically related objects which are not joined in metadata import.
You can manually create relationship between objects or can automatically define relationship between objects based on selected criteria. If this is a valid Relationship, the Framework manager wants to create a shortcut to the relationship.
Cognos Framework Manager Snowflake to Star Schema - Cognos Dimension Modeling
You can then click on the OK button. Once you create a relationship after the metadata import, you can also modify the relationship or Cardinality in the Framework manager. A Relationship shortcut is defined as the pointer to an existing relationship and to reuse the definition of an existing relationship.
Relationship Notation in Metadata Model
When you make any change to the source Relationship, they are automatically updated in shortcuts. Relationship shortcuts are also used to resolve ambiguous relationship between query subjects.
The Framework Manager asks whether you want to create a relationship shortcut whenever you create a relationship and both these conditions are true.
If this is a valid Relationship, Framework manager wants to create a shortcut to the relationship.
Cognos - Framework Manager
Click YES. A list appears of all relationships in which one end is a model object and the other end is either another model object or a shortcut to another model object.
A query subject is defined as a set of query items that have an inherent relationship.
A query subject can be used to customize the data they retrieve using a Framework Manager. Using the model query subject, it allows you to create more abstract and business view of data source.
You can also insert a data source reference, insert a macro, embed a calculation and embed a filter. When you edit any Relation database source, create or query a Relation database, then SQL is used in the background. It is possible to convert a model query subject to data source query subject.
You can select the type of SQL to be used when you define data source query subject. Cognos - Relationships in Metadata Model Advertisements. Previous Page. Next Page. Previous Page Print Page.