Cognos Analytics

Hi Jens,
As far as I can tell, this code hasn't changed in years.

To set up the value a call is made in jave as this:   InetAddress.getLocalHost().getHostName()
In my environment testing 11.0.13 gives a short name as well.
If Cognos 11.0.13 and 11.1.7 are on different machines, is there something different in the setups of those machines ?

// Henk

Hi,

I have noted that using CQM, this macro returns server name and using DQM returns FQN.

In my case, we have different database schema names based on type of environment (dev, production, test, etc).

My solution for that was creating an environment parameter (Local Config > advanced configuration) in Cognos Configuration called "ambiente", what means "environment" in my language. And then, I put the prefix of database of related environment, kind of DEV_, PRD_, etc.

So, in my Cognos data sources (Framework Manager), I have used this macro to get this parameter value of Cognos Configuration at run time.

#substitute('''' ; '' ; substitute('</crn:value'''; '' ; csv( grep('crn:value$' ; split('>' ; grep('ambiente' ; split('crn:parameter' ; getConfigurationEntry('advancedProperties' )))))))) + 'SUFIX_DATABASE_NAME'#

Using this way, you might change your server name or add more servers to your environment with no problems.

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

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

Original Message:
Sent: Fri December 11, 2020 01:07 PM
From: Jens Bäumler
Subject: $Mashine Parameter returns a different value (CA 11.0.13 / 11.1.7)

Hi.

We are using a Cognos macro to read out the $Machine parameter. Now we have noticed a change between version 11.0.13 and 11.1.7:
Result:
11.0.13: servername.domain.de (fully qualified name)
11.1.7: servername

Does anyone know a way to get the full name again?

(We use the macro in the Framework Manager to control the database schema in different environments).

Thanks Jens

------------------------------
Jens Bäumler
Senior Consultant and Trainer
Apparo Group
------------------------------

Hello Jens,

we use "#$dbschema{$machine}#" in datasource > schema of FM model. All queries (of course) must then be without schema.

$dbschema is a parameter map, where we specify a machine name (with and without FQDN) and the corresponding dbschema.

Machine names parameter map:

Another alternative is setting in Open session commands of datasource in Cognos portal to use a "set current schema" 

example for DB2: <commandBlock><commands><sqlCommand><sql>SET CURRENT SCHEMA=FK1C_T1D</sql></sqlCommand></commands></commandBlock>

This of course requires that none of your queries holds information about schema like: select * from cognos.gosales

Hth, 

Ralf

------------------------------
Ralf Roeber

Original Message:
Sent: Fri December 11, 2020 01:07 PM
From: Jens Bäumler
Subject: $Mashine Parameter returns a different value (CA 11.0.13 / 11.1.7)

Hi.

We are using a Cognos macro to read out the $Machine parameter. Now we have noticed a change between version 11.0.13 and 11.1.7:
Result:
11.0.13: servername.domain.de (fully qualified name)
11.1.7: servername

Does anyone know a way to get the full name again?

(We use the macro in the Framework Manager to control the database schema in different environments).

Thanks Jens

------------------------------
Jens Bäumler
Senior Consultant and Trainer
Apparo Group
------------------------------

Hello Jens,

we use "#$dbschema{$machine}#" in datasource > schema of FM model. All queries (of course) must then be without schema.

$dbschema is a parameter map, where we specify a machine name (with and without FQDN) and the corresponding dbschema.

Machine names parameter map:

Another alternative is setting in Open session commands of datasource in Cognos portal to use a "set current schema" 

example for DB2: <commandBlock><commands><sqlCommand><sql>SET CURRENT SCHEMA=FK1C_T1D</sql></sqlCommand></commands></commandBlock>

This of course requires that none of your queries holds information about schema like: select * from cognos.gosales

Hth, 

Ralf

------------------------------
Ralf Roeber

Original Message:
Sent: Fri December 11, 2020 01:07 PM
From: Jens Bäumler
Subject: $Mashine Parameter returns a different value (CA 11.0.13 / 11.1.7)

Hi.

We are using a Cognos macro to read out the $Machine parameter. Now we have noticed a change between version 11.0.13 and 11.1.7:
Result:
11.0.13: servername.domain.de (fully qualified name)
11.1.7: servername

Does anyone know a way to get the full name again?

(We use the macro in the Framework Manager to control the database schema in different environments).

Thanks Jens

------------------------------
Jens Bäumler
Senior Consultant and Trainer
Apparo Group
------------------------------