Cognos Analytics

 View Only

  • 1.  CA 11.1.2 Data Module Design

    Posted Mon August 12, 2019 04:46 AM
    I have a question around data module design.

    I have a Fact table of transactions.

    Within this table there is a field for Employee, this is joined via relationship using a GUID as a key to the Employee Dimension Table.

    So far all is working correctly.

    The new reporting requirement is that is some cases (not all) a secondary employee has joint ownership of a part of the action. 

    I have added a new field to the Fact table to hold the second employee GUID. 

    I already know I will have data issues if I try to join the Employee Table again.

    Can someone advise the best way to achieve this using Data Modules.

    ------------------------------
    Jonathan berry
    ------------------------------

    #CognosAnalyticswithWatson


  • 2.  RE: CA 11.1.2 Data Module Design

    Posted Mon August 12, 2019 09:47 AM
    We used to implement this as a role playing dimension in Framework Manager using Aliases.
    Data Modules don't have alias' at this point so you would just implement by creating another instance of the table and join to that.
    Here is a good blog on how to handle this.
    http://ibmblueview.com/data-module-alias/

    ------------------------------
    NORBERT Bracke
    ------------------------------

    Original Message