Cognos Analytics

Cognos Analytics

Connect, learn, and share with thousands of IBM Cognos Analytics users! 


#Product
#Analytics
#CognosAnalytics
#Analyticstools
#TechXchange Partner
#TechXchange Session
#TechXchange Presenter
#AI
 View Only
  • 1.  Data Item Expression: Expression Definition Validate not working

    Posted 12/23/19 09:08 AM
    Has anyone ever ran into this issue before? Basically creating a data item and using the expression Definition box (the builder). When clicking on Validate, it will always say no Errors. I can type in gibberish, click validate and still say no errors.
    This happens on new reports, old reports. The expression validate is not functioning.

    Running 11.0.13.1

    No Errors


    ------------------------------
    Jason Kwong
    ------------------------------

    #CognosAnalyticswithWatson


  • 2.  RE: Data Item Expression: Expression Definition Validate not working

    Posted 01/07/20 10:33 AM
    @Jason Kwong The data item needs to be referenced/used in the report, For example, if you add it to a list and validate, you will get an error. ​

    ------------------------------
    DENNY NAREZNY
    ------------------------------



  • 3.  RE: Data Item Expression: Expression Definition Validate not working

    Posted 01/07/20 10:39 AM
    Thanks for the response.
    We have added it to the report, went back in to validate and still checks out as no error.

    Working with IBM support, they are not able to replicate it on their instance. So something is screwed up on my instance.
    They tried multiple versions of 11 and all of them are able to validate correctly from the start and after adding to the report.


    ------------------------------
    Jason Kwong
    ------------------------------



  • 4.  RE: Data Item Expression: Expression Definition Validate not working

    Posted 01/07/20 10:52 AM
    Can you attach a copy of your report spec?

    ------------------------------
    DENNY NAREZNY
    ------------------------------



  • 5.  RE: Data Item Expression: Expression Definition Validate not working

    Posted 06/11/21 01:06 PM
    @Jason KwongDid you find the reason and a solution? I have the same effect on different environments in 11.0.13 and 11.1.7.​

    ------------------------------
    Michael Haaß
    ------------------------------



  • 6.  RE: Data Item Expression: Expression Definition Validate not working

    Posted 06/03/20 04:34 PM
    I'm so glad I came across this post Jason.  I am using 11.1.6 and have the same problem.  It doesn't validate but when I click OK instead of validate the calculation does in fact work.

    ------------------------------
    Jeremy Aude
    Channell Commercial Corporation
    Rockwall TX
    ------------------------------