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.