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

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
------------------------------

Robert, 
Thanks for your help!
Br
Andrzej

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

Original Message:
Sent: Wed September 01, 2021 01:37 AM
From: Robert Dostal
Subject: Combining data from pivot tables

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
------------------------------