how to create across tab with two different measures?

[sergiord2016]

Hi .

I want to create a crosstab with twomeasures.

I have a problem , because although i have related the two measures with the dimensions of the crosstab when i add one measure the other disconects and when i put the other measure the other one disconects...

This is the crosstab with one measure working:



And now if i add the measure called "AOP" , the first measure disconects from dimeniones and puts the same quantity.



Please help me , COGNOS may have a solution to make a crosstab with measures related with common dimensions.

Thank you in advance.

[New_Guy]

Hi,
If you have 2 measures, you can nest different mesures below the different dimensions like below

   time      time
   dim1      dim2
   Measure1   Measure
row

Please make sure the data is hidden when you post in this forum.

Good luck
New guy   

[sergiord2016]

Hi,
If you have 2 measures, you can nest different mesures below the different dimensions like below

   time      time
   dim1      dim2
   Measure1   Measure
row

Please make sure the data is hidden when you post in this forum.

Thank you  , you are right  thats the solution...


Good luck
New guy

[sergiord2016]

I thought it was done but not.

I am sure that both measures (aop , import)  are related with two dimensions : services and time , but:

If i make a crosstab with both measures and dimension time , no problem:



If i make a crosstab with both measures and dimension service, no problem:



The problem is when i combine with the two dimensions... i don't know why the import measure shows like disconected from Service , and repeats for each service 2.255.497,6 for January (the total amount for january 2017) and 2.329.659,5 for February (the total amount for February 2017).



O have been making probes and no way...

The two measures are in different tables but both tables are related with dimensions service and time as you can see in the first two snapshot.

Coould you help me please?

Thanks in advance...

[sergiord2016]

i continue making probes...

I found that when i insert the measure called AOP in the crosstab the other measure disconects and repeats for eache service.

1) In this first step the measure Importe is ok:



2) In the second step , when i insert the measure called AOP then the measure1 breaks.



3) Always breaks , doesn't matter below the "0" (date dimension) or not:




Please help me! I guess it should be easy...

[CognosPaul]

What type of data source is this? It looks like there might be a data model problem. How many fact tables? Are the joins set up correctly?

[sergiord2016]

What type of data source is this? It looks like there might be a data model problem. How many fact tables? Are the joins set up correctly?

It was exactly that. A duplicate foreign key in the model.

Solved!