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

 

Cognos Analytics v.11.1.3 / Reporting / Tuple functio not working

Started by dzvonva, 06 Nov 2019 05:05:05 AM

Previous topic - Next topic

dzvonva

can anyone say does tuple -functio in Cognos analytics v11.1.3 ?


For example, this query:

case
when (tuple([Last Month]; [12- 18 KK]; [Stock value €])>0 and tuple([Last Month]; [12- 18 KK];  [Stock rotation - year]) between 0,5000000001 and 1 or tuple([Last Month];  [18- 24 KK]; [Stock value €])>0 and tuple([Last Month]; [18- 24 KK]; [Stock rotation - year]) between 0,501 and 1)
then 'Group A'

when (tuple([Last Month]; [24 KK >]; [Stock value €])>0 and tuple([Last Month]; [24 KK >]; [Stock rotation - year]) <= 0,5)
then 'Group B'
end


gives an error:

RSV-VAL-0010 Failed to load the report specification. QE-DEF-0260 Parsing error before or near position:28 of: "case when(1=1) then when"QE.DEF.0261 RQP - Parsing text: case when(1=1) then when........

But the same report works fine in Cognos 10.