Author Topic: Using Case statements in List in Cognos Analytics  (Read 411 times)

Offline fakxy

  • Full Member
  • ***
  • Join Date: Aug 2020
  • Posts: 7
  • Forum Citizenship: +0/-0
    • cognoise.com
Using Case statements in List in Cognos Analytics
« on: 23 Oct 2020 02:22:42 am »
Hello All,

I am preparing a list report. I am trying to use a data item and need to group the list on that. I am using a case statement for that data item. But when I am trying to group on that, it is throwing an error.

 "XQE-PLN-0040 The query is not supported. Tuple-based value expressions are not supported as grouping items in list reports. Data item name = 'CEU EEU SEU Group' , valueset name = '7'.

Cognos Version - 11.1.7
Model - DMR

Any quick help is highly appreciated.

Regards,
Fakeha