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/------------------------------
Original Message:
Sent: Mon July 08, 2024 09:27 AM
From: Marc Reed
Subject: getConfigurationEntry( entryString options
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
------------------------------