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/------------------------------