If you are unable to create a new account, please email support@bspsoftware.com

 

News:

MetaManager - Administrative Tools for IBM Cognos
Pricing starting at $2,100
Download Now    Learn More

Main Menu

Coalesce and crazy behavior

Started by Rosanero4Ever, 24 Feb 2016 10:53:23 AM

Previous topic - Next topic

Rosanero4Ever

Hi all,

I need to create a simple report with a crosstab with years in rows and two measures in cols.
Measures are considered from two different fact tables. So, because I have to sum these measures, I use coalesce() function in order to prevent null values in the calculated measure.
So, I write this calculated measure in the following way:
coalesce( [Measure1] + [Measure2];[Measure1] ; [Measure2])
Baucase the full join between the two fact tables doesn't produce null values, the sum shoud always consider 
[Measure1] + [Measure2]
but is not  the truth!!  :'( :'( :'( :'(
The result I have is Measure1 as the ([Measure1] + [Measure2]) is null but if I remove the coalesce in the sum, i.e. if I write the calculation without the coalesce:
[Measure1] + [Measure2]
all works well!
Does anyone can explain me what's wrong?
Please, help me...

[EDIT]:
I believe I found the root of the problem:
I use a relational package with DQM. I create the report starting from a list. Then I transform the list in a crosstab a s described above.
After this transformation, correct data displayed in the list become wrong in the crosstab!!!
I use Cognos BI 10.2. Do you know if this problem was fixed????

[SOLVED]
Converting to CQM all works well. Does anybody know any fix? I need DQM...

Rosanero4Ever

I already installed 10.2 FP4.... :-[