Cognos Analytics

Cognos Analytics

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

 View Only
  • 1.  getConfigurationEntry( entryString options

    Posted Mon July 08, 2024 09:27 AM

    Hi All.

    Does anyone know where I could find a list of options that the getConfigurationEntry( macro function can take?

    For example # getConfigurationEntry ( 'serverLocale'  ) #

    serverLocale is one option, but what are the others - or where do I find a list. Thanks.



    ------------------------------
    Marc Reed
    ------------------------------


  • 2.  RE: getConfigurationEntry( entryString options

    Posted Mon July 08, 2024 01:25 PM

    Hi Marc,

    In <install>/configuration/cogstartup.xml
    look for the crn:parameter  elements at the top level, the name attribute can be used in this getConfigurationEntry function.
    E.g.  use serverTimeZoneID  defined as:
        <crn:parameter name="serverTimeZoneID">
            <crn:value xsi:type="cfg:timeZone">America/New_York</crn:value>
        </crn:parameter>



    ------------------------------
    Kind regards,
    Henk Cazemier
    ------------------------------



  • 3.  RE: getConfigurationEntry( entryString options

    Posted Tue July 16, 2024 01:58 PM

    Hi,

    I'm using for defining environment that my server is running. It is usefull, as my database schemas change in one enviroment to another.

    So, bellow Enviroment setting in Cognos Configuration of all installations, I have created a new property called ambiente (environment in Portuguese) that set the database schema in FM Models. Ambiente can be DEV, QA, PROD, in our case.

    At datasource in our FM we define schema as follows: #substitute('''' ; '' ; substitute('</crn:value'''; '' ; csv(grep('crn:value$' ; split('>' ; grep('ambiente' ; split('crn:parameter' ; getConfigurationEntry('advancedProperties' )))))))) + '_schema_name'#



    ------------------------------
    JEAM COELHO
    Cognos Solution Architect

    LinkedIn: https://www.linkedin.com/in/jeamcoelho/
    ------------------------------



  • 4.  RE: getConfigurationEntry( entryString options

    Posted 12 hours ago

    Hi,

    Thank you @Jeam Coelho, your post was very useful for me.

    Did you try to use qs.getConfigurationEntry1 which seem to be something needed with advanced properties? The documentation is quite lite on this topic? @HENK CAZEMIER, do you have any documentation you would share with us?

    Best regards,



    ------------------------------
    Patrick Neveu
    BSL Consulting
    IBM Champion
    ------------------------------