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

Complex crosstab with calculated measure and coalesce()

Started by Rosanero4Ever, 06 Apr 2016 12:57:19 AM

Previous topic - Next topic

Rosanero4Ever

Hi all,

I have to create a crosstab based on a relational package as the structure in the attached image.
All works well except the summary of the measures. In fact, calculated measures total are wrong!!
I verified that it happens only with crosstab and coalesce function. I use BI 10.2.2 and FP4 (latest) but I don't want to believe is thus difficult create a simple calculations using a crosstab.... :'( :'(
I use coalesce because measures are considered from different fact tables.
I tried automatic, calculated and total aggregation without success.
Can anybody help me, please?