Creating a relationship with the existing tables

The scenario describes the steps to create a relationship with any existing custom table.

Before you begin

  • Install and configure IBM® Cognos® Analytics server.
  • Install IBM Framework Manager.
  • Map the user and its required attributes through schema mapper in IVIG Console and run the data synchronization.

About this task

IBM Verify Identity Governance Cognos report model is divided into two basic namespaces: audit and configuration. Audit namespace provides the tables or query subjects that helps to generate the audit reports. Configuration namespace provides the configuration information that helps to generate configuration reports.

You can define the custom types or objects in IBM Verify Identity Governance. By default, IBM Verify Identity Governance provides the objects Person and Business Partner Person for a User entity. You can further define your own object classes that can be used as the custom person or custom Business Partner person types. For example, JKPerson.

The JKPerson is of a type User. Therefore, navigate to the User configuration namespace to merge the JKPerson.

Procedure

  1. Extract the ISIMReportingModel_6.0.0.6.zip to the local disk.
  2. Create a project in IBM Cognos Framework Manager and open .cpf file for the model customization.
    Note: Open an existing project if any customization is already done in IBM Verify Identity Governance metadata model.
  3. Navigate to the Database Layer.
  4. Hold the Ctrl key, and select the JKPerson and JKPerson_CN tables.
  5. Right click, and then select Create > Relationship.
  6. Set the Cardinality, and then click OK.
  7. Create a relationship between the JKPerson and JKPerson_SN tables
  8. A common entity such as User lists all types of the users.
    For example, Person, Business Partner Person, or JKPerson.

    To create a common entity, pick the common attributes in them. Assuming that the cn, sn, businesunit dn, and dn are the attributes that are must, create the JKPerson Must Attributes query subject that contains the attributes that are must. Rename an individual item to some business names. For example, CN to Full Name, SN to Last Name.

    Introduce one more data item as Type. The Type attribute indicates the type of a user such as JKPerson.

    1. Navigate to the Database Layer.
    2. Select the Database Layer.
    3. Right click, and then select Create > Query subject.
    4. Select the type as a Model query subject.
    5. Provide the name to the query subject.
      For example, JKPerson Must Attributes.
    6. Click OK.
      The Query Subject Definition window is displayed.
    7. Navigate to the Database Layer.
    8. Add JKPerson DN, Business Unit Dn from the JKPerson query subject.
    9. Add JKPerson_CN from the JKPerson_CN and JKPerson_SN from the JKPerson_SN.
    10. Add a Type data item to indicate the type of a user.
      1. Click Add link.
      2. Provide the Type as a name to the item.
      3. In the expression definition, add the JKPerson.
      4. Click OK.
  9. Edit the union definition for the User query subject and include newly added JKPerson Must Attributes query subject.
  10. Select User, right click, and test the results.
  11. Optional: Create a shortcut of User and use it in the namespace.
    For example, User Configuration.
    1. Select a User from the database layer.
    2. Right click, and select Create > Shortcut.
    3. Drag the shortcut to User Configuration namespace.
    4. Rename the shortcut query to JKPerson or some business name and use it as per the requirement.

Results

The relationship is created with the existing tables.