Author Topic: Substring function not working in Charts .  (Read 288 times)

Offline vasudev_jain

  • Full Member
  • ***
  • Join Date: Aug 2020
  • Posts: 6
  • Forum Citizenship: +0/-0
Substring function not working in Charts .
« on: 08 Oct 2020 01:46:34 am »
Hi Folks,

I am using function substring(dimension,16,4) in a chart in Cognos 11 DMR model (working fine in list ) , it is throwing error " Found an internal error:
java.lang.IllegalMonitorStateException" , when removing this function , report is running fine . so just wanted to know is there any way that i can substitute the substring function . By searching on net i also found the suggestion to use 'Report expression' for it , i tried but gave me the same error .

Can anyone please help on this.

Thank you

Regards
Vasu

Offline bus_pass_man

  • Statesman
  • ******
  • Join Date: May 2008
  • Posts: 428
  • Forum Citizenship: +43/-0
Re: Substring function not working in Charts .
« Reply #1 on: 08 Oct 2020 07:52:10 am »
Dimensions are not valid for the substring function.

If you select substring in the expression editor and press the I button on the top right you will see information about that function.  It will tell you what objects are valid for the expression. 

You will probably want to use an attribute, which is treated as a query item.

Offline vasudev_jain

  • Full Member
  • ***
  • Join Date: Aug 2020
  • Posts: 6
  • Forum Citizenship: +0/-0
Re: Substring function not working in Charts .
« Reply #2 on: 16 Oct 2020 01:28:44 am »
Thank Yo for the response . :)

We were using Cognos 11.0.13 in which i was getting the error mentioned before , now we are using Cognos 11.1.7  in which i am not getting issue and i see the relational functions working on dimensions when used in Charts .

Regards
Vasu