Cognos Analytics

Expand all | Collapse all

hard coding in cognos

  • 1.  hard coding in cognos

    Posted Wed July 01, 2020 08:37 AM
    What is mean by hard coding in cognos report.

    Priyanka Joshi

  • 2.  RE: hard coding in cognos

    Posted Wed July 01, 2020 08:42 AM

    Hi Priyanka

    It could mean many things... typically, users would "hardcode" sql-statements directly into the report.... or include Javascript code as part of the customcontrols to enhance the report or functionality... it's hardcoded then because you can't change it from parameters, you would need to go into each report to change it...


    Torben Noer
    Offering Manager, Cognos Analytics and Planning Analytics

  • 3.  RE: hard coding in cognos

    Posted Thu July 02, 2020 09:08 AM
    Torbin pretty much covered it. Hard coding is where a user is not allowed to change something, typically where a prompt/parameter/filter might be used. An example would be a filter that is coded as [Country] = 'United States' instead of [Country] = ?Country parameter?. You could also have a hard-coded sql statement where a developer directly types in a SQL statement instead of using the framework package in the report. I've done this where the framework is complex (coming directly from a transactional system) and the joins needed to be done in a very specific way.

    If at all possible, I try to refrain from hard coding because, in many cases, it makes the report less useful to a wide audience.

    Jonathan McKnight