Text only | Text with Images

COGNOiSe.com - The IBM Cognos Community

IBM Cognos 10 Platform => Cognos 10 BI => Report Studio => Topic started by: EarthDog on 03 Apr 2015 05:06:02 AM

Title: Newbie cannot make simple aggregation work correctly on crosstab
Post by: EarthDog on 03 Apr 2015 05:06:02 AM
I have a simple nested crosstab that has 2 measures. I need to see the average on them. I do not need any totals.

What i get is repeating results. Its like he is ignoring the levels in my crosstab. I have 2 levels.

-Both measures are defined as 'fact' in FM model
-Both measures have average as rollup function and Automatic as Rollup Aggregate function
-Query auto Group & Summarize option is Yes

Generated SQL does NOT contain GROUP by clause...

The attachment shows the situation.

It seems that the numbers are repeated..

Title: Re: Newbie cannot make simple aggregation work correctly on crosstab
Post by: EarthDog on 03 Apr 2015 06:08:48 AM
It seems that i am getting correct results if i disable the  auto Group & Summarize option in query..

Something must be fundamentally wrong  but i dont know what...
Title: Re: Newbie cannot make simple aggregation work correctly on crosstab
Post by: EarthDog on 04 Apr 2015 04:54:21 AM
anyone?
Title: Re: Newbie cannot make simple aggregation work correctly on crosstab
Post by: EarthDog on 04 Apr 2015 08:13:06 AM
So embarrassed  ;D

I was missing FM model joins...
Title: Re: Newbie cannot make simple aggregation work correctly on crosstab
Post by: bdbits on 07 Apr 2015 10:39:44 AM
Happens to everyone, sooner or later.  8)
Text only | Text with Images