Print Page - Absolute Cell value for Crosstab

Title: Absolute Cell value for Crosstab
Post by: stancho on 24 Jan 2011 07:38:27 PM

Hi all,

I have the following crosstab:

(http://stancho.com/cognos/crosstab-nodes.png)

ExecValueTotal = total of ExecValue for AB and BC.
I have Data Item1. Data Item1 expression is '[ExecValueTotal]'
but it shows the value of ExecValue (because it is filtered by AB or BC).
How can I set the Data Item1 expression to be the absolute value of the cell: ExecValueTotal?

Thanks,
Stancho

Title: Re: Absolute Cell value for Crosstab
Post by: RobsWalker68 on 25 Jan 2011 06:10:01 AM

Hi,

Look at using the completeTuple function. This will allow you to exactly set the value regardless of the context implied by the crosstab edges.

Regards

Rob

Title: Re: Absolute Cell value for Crosstab
Post by: stancho on 26 Jan 2011 02:37:23 AM

Thanks Rob!
I'll try it!

Title: Re: Absolute Cell value for Crosstab
Post by: stancho on 26 Jan 2011 05:55:10 AM

Rob I played with completeTuple function but:

if I set the expression of Data Item1 to:
completeTuple ([ExecValueTotal]) I get the total of ExecValueTotal column (577... + 581...) on every line.

I tried also something like completeTuple([ExecValueTotal], [MeassureDate]) .. (MeassureDate is the name of years).
also completeTuple([ExecValueTotal], [MeassureDate], currentMember([MyProject][Data][MeassureDate]) ) .. but always get errors... I saw these examples in the Tips for completeTuple function.

Any ideas?
Stancho

Title: Re: Absolute Cell value for Crosstab
Post by: RobsWalker68 on 26 Jan 2011 07:59:14 AM

Hi Stancho,

Actually, just try the tuple function so define data item 1 as:

value(tuple(AB,Quantity)) + value(tuple(BC,Quantity))

Cheers

Rob

COGNOiSe.com - The IBM Cognos Community

IBM Cognos 10 Platform => Cognos 10 BI => Report Studio => Topic started by: stancho on 24 Jan 2011 07:38:27 PM