Cognos Analytics

Cognos Analytics

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


#Product
#Analytics
#CognosAnalytics
#Analyticstools
#TechXchange Partner
#TechXchange Session
#TechXchange Presenter
#AI
 View Only

  • 1.  how to join tables in framework manager

    Posted 04/28/22 09:46 AM
    Hello,
    I am working on creation of package in FM.I have 4 fact tables and one dimension table.How to join that.

    ------------------------------
    Priyanka Joshi
    ------------------------------

    #CognosAnalyticswithWatson


  • 2.  RE: how to join tables in framework manager

    Posted 04/28/22 12:56 PM
    Edited by System Admin 01/20/23 04:18 PM

    If there exists primary and foreign key information in your data base and you choose to include that in your metadata import (it's default setting is on) then relationships between your tables should exist.

    If not, then you can create them.

    Select the two query subjects you want to join and choose create relationship from the context menu.

    This will open the relationship editor.  You can then define what keys and the cardinality of the relationship between the tables.



    ------------------------------
    IAN HENDERSON
    ------------------------------



  • 3.  RE: how to join tables in framework manager

    Posted 04/29/22 05:01 PM

    Hi,

    I recommend this https://www.ibm.com/docs/en/SSEP7J_11.0.0/com.ibm.swg.ba.cognos.ug_fm.doc/ug_fm.pdf

    Page 56.



    ------------------------------
    JEAM COELHO
    Cognos Solution Architect

    LinkedIn: https://www.linkedin.com/in/jeamcoelho/
    ------------------------------



Related Content