Print Page - issue with aggregate function

Title: issue with aggregate function
Post by: philelmousse on 08 Aug 2011 07:27:56 AM

Hello,

I have a crosstab with number columns and a percentage column.

I add a dataitem with that calculation : aggregate(currentMeasure within set [setCategory])

But when I run the report nothing is displayed in that row, only "--"

What could be the problem ?

Thanks

Title: Re: issue with aggregate function
Post by: philelmousse on 09 Aug 2011 09:33:37 AM

I have that warning when I validate the report :

OP-ERR-0264 Automatic aggregation of sets that include a calculated member or value calculation may return unexpected results. (found at position 1)
what is the workaround ?

Thanks

Title: Re: issue with aggregate function
Post by: philelmousse on 11 Aug 2011 08:49:02 AM

up please

Title: Re: issue with aggregate function
Post by: philelmousse on 15 Aug 2011 09:19:28 AM

My crosstab is like that :

Profit(number), Cost(number), Delta(number), Margin(%)
Member1
Member2
Member3(Member5-Member4)
Total

For the total I have this data item : aggregate(CurrentMeasure within set row1,row2,row3) but the Margin column is wrong. It makes to total of margins rows. I dont know why

Title: Re: issue with aggregate function
Post by: PRIT AMRIT on 15 Aug 2011 10:09:21 PM

Select the Margin(%) column. Define Under Properties- Data Item- Solve Order=2.

See if it helps?

Title: Re: issue with aggregate function
Post by: philelmousse on 16 Aug 2011 01:50:37 AM

yes it seems to work, thanks a lot.

COGNOiSe.com - The IBM Cognos Community

IBM Cognos 8 Platform => COGNOS 8 => Report Studio => Topic started by: philelmousse on 08 Aug 2011 07:27:56 AM