Cognos Analytics

Cognos Analytics

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

 View Only

  • 1.  Combining data from pivot tables

    Posted Tue August 31, 2021 12:21 PM
    Hi Everybody,
    I am creating report from different metrics on two pivot tables.
    How could I combine this data? I need to compare values with the same time ranges.

    Thanks!
    Br
    Andrzej

    ------------------------------
    Andrzej Wolak
    ------------------------------

    #CognosAnalyticswithWatson


  • 2.  RE: Combining data from pivot tables

    Posted Wed September 01, 2021 01:38 AM

    Hi Andrzej,

    depending on how your data is ready to be linked I suggest to use a join oir union in the queries pane:


    Keep in mind that if both queries return measure values, a join works only if both queries return data on the same grain level. You have to set the right cardinality depending on your data:

    And at least: if you need those data combined together many times I also suggest to create a Framework Manager model or a Data Module where all these data modifications take place.



    ------------------------------
    Robert Dostal
    Team Leader BI
    GEMÜ
    Ingelfingen
    ------------------------------

    Original Message


  • 3.  RE: Combining data from pivot tables

    Posted Thu September 02, 2021 02:46 AM
    Robert, 
    Thanks for your help!
    Br
    Andrzej

    ------------------------------
    Andrzej Wolak
    ------------------------------

    Original Message


Related Content