Cognos Analytics

Cognos Analytics

Connect, learn, and share with thousands of IBM Cognos Analytics users! 

 View Only
Back to discussions
Expand all | Collapse all

Bridge tables as a double counting issue solution

  • 1.  Bridge tables as a double counting issue solution

    Posted Thu December 16, 2021 10:49 AM

    Hello!
    There is a M:M relationship between the FACT TABLE and the DIMENSION. In consequence, double-counting issue emerges. Bridge tables are used to fix this (This approach works for single-fact stream measures), however, we have multi-fact stream measures, that cause an error.
    How to make a bridge table solution work for multi-fact measures?

    The image below illustrates the structure created as a solution for the double-counting issue.
    The image below illustrates how datamodule was designed.



    Example:

    • Bridge table settings: query subject that executes the role of the bridge table has Cognos 'bridge' usage.
    • Test case: (f1.price / f2.price) + filter (Time Period = '2009') + filter (dim_id = 'ER34')
    • Error:


    ------------------------------
    Emil Arutiunov
    ------------------------------

    #CognosAnalyticswithWatson


Related Content