Cognos Analytics

Hello All,

I use the $machine macro function in my reports to display Dispatcher server name that handled the report.

Is there a macro that would allow me to also include the port number? for situations were same server has more than one Dispatcher installed.

Thanks!



#CognosAnalyticswithWatson

Hi Richard,
The following macro expression:
#sq(getConfigurationEntry('externalDispatcher'))#
gives you something like:
'http://laptop-p52henkc:9400/p2pd/servlet/dispatch'
Is that something that you can work with?

// Henk

------------------------------
HENK CAZEMIER
------------------------------

Original Message:
Sent: Wed January 29, 2020 03:34 PM
From: Richard Mabjish
Subject: Session macro for server name & port #


Hello All,

I use the $machine macro function in my reports to display Dispatcher server name that handled the report.

Is there a macro that would allow me to also include the port number? for situations were same server has more than one Dispatcher installed.

Thanks!



#CognosAnalyticswithWatson

@HENK CAZEMIER​

Thank you Henk, this is exactly what I needed, it works great. 
I did not know this function even existed, is there a documentation you can refer me to see what else is available?
Original Message:
Sent: Wed January 29, 2020 11:03 PM
From: HENK CAZEMIER
Subject: Session macro for server name & port #

Hi Richard,
The following macro expression:
#sq(getConfigurationEntry('externalDispatcher'))#
gives you something like:
'http://laptop-p52henkc:9400/p2pd/servlet/dispatch'
Is that something that you can work with?

// Henk

------------------------------
HENK CAZEMIER

Original Message:
Sent: Wed January 29, 2020 03:34 PM
From: Richard Mabjish
Subject: Session macro for server name & port #


Hello All,

I use the $machine macro function in my reports to display Dispatcher server name that handled the report.

Is there a macro that would allow me to also include the port number? for situations were same server has more than one Dispatcher installed.

Thanks!



#CognosAnalyticswithWatson

Hi Richard,
In the expression editors of Cognos Analytics there is function list that describes the available macro functions.
Here is a screen shot of the web-based modeling tool when defining a calculation.
I hope this answers most of your questions, but please feel free to reach out for further info.
// Henk


------------------------------
HENK CAZEMIER
------------------------------

Original Message:
Sent: Fri January 31, 2020 09:32 AM
From: Richard Mabjish
Subject: Session macro for server name & port #

@HENK CAZEMIER​

Thank you Henk, this is exactly what I needed, it works great. 
I did not know this function even existed, is there a documentation you can refer me to see what else is available?
Original Message:
Sent: Wed January 29, 2020 11:03 PM
From: HENK CAZEMIER
Subject: Session macro for server name & port #

Hi Richard,
The following macro expression:
#sq(getConfigurationEntry('externalDispatcher'))#
gives you something like:
'http://laptop-p52henkc:9400/p2pd/servlet/dispatch'
Is that something that you can work with?

// Henk

------------------------------
HENK CAZEMIER

Original Message:
Sent: Wed January 29, 2020 03:34 PM
From: Richard Mabjish
Subject: Session macro for server name & port #


Hello All,

I use the $machine macro function in my reports to display Dispatcher server name that handled the report.

Is there a macro that would allow me to also include the port number? for situations were same server has more than one Dispatcher installed.

Thanks!



#CognosAnalyticswithWatson

Hi Richard,

as follow up to what @HENK CAZEMIER stated.

here comes the list (C11.0.13LTS):
/opt/IBM/cognos/crn0/configuration : fgrep "<crn:parameter" cogstartup.xml

<crn:parameter name="edition"> <crn:parameter name="releaseType"> <crn:parameter name="licenseType"> <crn:parameter name="advancedProperties" opaque="true"> <crn:parameter name="enableInternalNS"> <crn:parameter name="hostName"> <crn:parameter name="serverLocale"> <crn:parameter name="serverTimeZoneID"> <crn:parameter name="defaultFont"> <crn:parameter name="emailEncoding"> <crn:parameter name="bvMaxAttachmentSize" disabled="true"> <crn:parameter name="deploymentPath"> <crn:parameter name="doReportSpecUpgrade"> <crn:parameter name="data"> <crn:parameter name="mapFileLocation"> <crn:parameter name="temp"> <crn:parameter name="encryptTemporaryFiles"> <crn:parameter name="formatSpecificationLocation"> <crn:parameter name="sortMemory"> <crn:parameter name="networkConfiguration"> <crn:parameter name="gateway"> <crn:parameter name="gatewayNamespace"> <crn:parameter name="gatewayCMSPNName"> <crn:parameter name="overrideNamespace"> <crn:parameter name="gatewayDispatcherURIList" opaque="true"> <crn:parameter name="controllerServerURI"> <crn:parameter name="externalDispatcher"> <crn:parameter name="internalDispatcher"> <crn:parameter name="disp_sharedsecret"> <crn:parameter name="jmxPort"> <crn:parameter name="jmxCredential"> <crn:parameter name="rsvpExecutionMode"> <crn:parameter name="sdk"> <crn:parameter name="contentManagers" opaque="true"> <crn:parameter name="retrieveConfigUser"> <crn:parameter name="retrieveConfigPassword"> <crn:parameter name="retrieveConfigNamespaceID"> <crn:parameter name="DSSOAPServerURI" disabled="true"> <crn:parameter name="fontPaths"> <crn:parameter name="brsPDFEmbeddableFonts"> <crn:parameter name="brsPDFNonEmbeddableFonts"> <crn:parameter name="rsPDFEmbeddableFonts"> <crn:parameter name="rsPDFNonEmbeddableFonts"> <crn:parameter name="feedbackPort"> <crn:parameter name="CFS" opaque="true"> <crn:parameter name="configGroupName"> <crn:parameter name="configGroupPassword"> <crn:parameter name="configGroupContactPort"> <crn:parameter name="configGroupContactHost"> <crn:parameter name="configGroupMemberSyncPort"> <crn:parameter name="configGroupMemberCoordinationPort"> <crn:parameter name="pmpService" opaque="true" disabled="true"> <crn:parameter name="pmpMaxMemory" disabled="true"> <crn:parameter name="pmpShutdownPort" disabled="true"> <crn:parameter name="pmpGatewayURI" disabled="true"> <crn:parameter name="pmpExternalURI" disabled="true"> <crn:parameter name="pmpSessionTimeout" disabled="true"> <crn:parameter name="pmpForceQualifiedPaths" disabled="true"> <crn:parameter name="pmpNotificationsProvider" disabled="true"> <crn:parameter name="pmpBVEnable" disabled="true"> <crn:parameter name="pmpBVURI" disabled="true"> <crn:parameter name="pmpSCEnable" disabled="true"> <crn:parameter name="pmpBIFolderName" disabled="true"> <crn:parameter name="pmpAppDefPath" disabled="true"> <crn:parameter name="pmpUserPrefPath" disabled="true"> <crn:parameter name="pmpResourcePath" disabled="true"> <crn:parameter name="pmpDispatcherURI" disabled="true"> <crn:parameter name="pmpTrustedUser" disabled="true"> <crn:parameter name="pmpNamespace" disabled="true"> <crn:parameter name="pmpTm1Clients" opaque="true" disabled="true"> <crn:parameter name="pmpProvisionURI" disabled="true"> <crn:parameter name="pmpProvisionAllowInstall" disabled="true"> <crn:parameter name="pmpProvisionAllowUpdate" disabled="true"> <crn:parameter name="pmpInsightPublishEnable" disabled="true"> <crn:parameter name="pmpsvcPingTime" disabled="true"> <crn:parameter name="tm1ExcelService" opaque="true" disabled="true"> <crn:parameter name="advancedProperties" opaque="true" disabled="true"> <crn:parameter name="tm1AdminServer" opaque="true" disabled="true"> <crn:parameter name="tm1AdminNonSSLPortNumber" disabled="true"> <crn:parameter name="tm1AdminSSLPortNumber" disabled="true"> <crn:parameter name="tm1AdminSupportNonSSLClients" disabled="true"> <crn:parameter name="tm1AdminDHFile2048" disabled="true"> <crn:parameter name="tm1AdminDHFile1024" disabled="true"> <crn:parameter name="tm1AdminDHFile512" disabled="true"> <crn:parameter name="tm1AdminSSLCertificate" disabled="true"> <crn:parameter name="tm1AdminSSLCertRevocationFile" disabled="true"> <crn:parameter name="tm1AdminExportSvrSSLCert" disabled="true"> <crn:parameter name="tm1AdminSvrSSLExportKeyID" disabled="true"> <crn:parameter name="tm1AdminSSLCertificateID" disabled="true"> <crn:parameter name="tm1AdminSSLPrivateKeyPwdFile" disabled="true"> <crn:parameter name="tm1AdminSSLPwdKeyFile" disabled="true"> <crn:parameter name="tm1AdminSSLCertAuthority" disabled="true"> <crn:parameter name="tm1AdminIPVersion" disabled="true"> <crn:parameter name="tm1AdminActivityInterval" disabled="true"> <crn:parameter name="tm1AdminInactivityTimeout" disabled="true"> <crn:parameter name="tm1AdminSvrCertificateVersion" disabled="true"> <crn:parameter name="mdmService" opaque="true" disabled="true"> <crn:parameter name="mdmDefaultPort" disabled="true"> <crn:parameter name="mdmSSLPort" disabled="true"> <crn:parameter name="mdmUseSSL" disabled="true"> <crn:parameter name="mdmShutdownPort" disabled="true"> <crn:parameter name="mdmSessionTimeout" disabled="true"> <crn:parameter name="MDCSettings" opaque="true" disabled="true"> <crn:parameter name="mdcServerHost" disabled="true"> <crn:parameter name="mdcServerPort" disabled="true"> <crn:parameter name="MDCAdapters" opaque="true" disabled="true"> <crn:parameter name="mdcAdapterEnabled" disabled="true"> <crn:parameter name="mdcAdapterId" disabled="true"> <crn:parameter name="IPF" opaque="true"> <crn:parameter name="logServerPort"> <crn:parameter name="enableTCPConnection"> <crn:parameter name="workerThreads"> <crn:parameter name="appenderName"> <crn:parameter name="appenderMaxSize"> <crn:parameter name="appenderRollOver"> <crn:parameter name="useUTF8Encoding"> <crn:parameter name="server"> <crn:parameter name="user"> <crn:parameter name="name"> <crn:parameter name="SSLencryptionEnabled"> <crn:parameter name="CBS" opaque="true"> <crn:parameter name="asvIsEnabled"> <crn:parameter name="ansIsEnabled"> <crn:parameter name="brsIsEnabled"> <crn:parameter name="cmIsEnabled"> <crn:parameter name="disIsEnabled" disabled="true"> <crn:parameter name="dssoapIsEnabled" disabled="true"> <crn:parameter name="dmsIsEnabled" disabled="true"> <crn:parameter name="dlsIsEnabled"> <crn:parameter name="dispIsEnabled"> <crn:parameter name="emIsEnabled"> <crn:parameter name="gsIsEnabled"> <crn:parameter name="htsIsEnabled"> <crn:parameter name="idVizIsEnabled"> <crn:parameter name="jsIsEnabled"> <crn:parameter name="mdsIsEnabled"> <crn:parameter name="cmmIsEnabled" disabled="true"> <crn:parameter name="migsrvIsEnabled" disabled="true"> <crn:parameter name="mobIsEnabled"> <crn:parameter name="msIsEnabled"> <crn:parameter name="pasIsEnabled" disabled="true"> <crn:parameter name="pdsIsEnabled" disabled="true"> <crn:parameter name="pjsIsEnabled" disabled="true"> <crn:parameter name="pwsIsEnabled" disabled="true"> <crn:parameter name="ppesIsEnabled" disabled="true"> <crn:parameter name="xtscrnIsEnabled"> <crn:parameter name="qsIsEnabled"> <crn:parameter name="ccsIsEnabled"> <crn:parameter name="warpIsEnabled"> <crn:parameter name="repoIsEnabled"> <crn:parameter name="rmdsIsEnabled"> <crn:parameter name="vgsIsEnabled"> <crn:parameter name="dispatcherPingTimeout"> <crn:parameter name="dispatcherStopWaitTime"> <crn:parameter name="dispatcherMaxMemory"> <crn:parameter name="wlpProperties" opaque="true"> <crn:parameter name="coreThreads"> <crn:parameter name="maxThreads"> <crn:parameter name="CPS" opaque="true"> <crn:parameter name="webcontent"> <crn:parameter name="applications"> <crn:parameter name="cps_namespaceID"> <crn:parameter name="cps_sharedSecret"> <crn:parameter name="CDS" opaque="true" disabled="true"> <crn:parameter name="DS_DATA_DIR" disabled="true"> <crn:parameter name="DS_LOG_DIR" disabled="true"> <crn:parameter name="CDSNet" opaque="true" disabled="true"> <crn:parameter name="DS_NET_LOG_DIR" disabled="true"> <crn:parameter name="CDSNetClient" opaque="true" disabled="true"> <crn:parameter name="DSNET_CLIENT_LOG_SEVERITY" disabled="true"> <crn:parameter name="DS_NET_DEFAULT_PORT" disabled="true"> <crn:parameter name="DS_NET_DEFAULT_PROTOCOL" disabled="true"> <crn:parameter name="DSNET_DFLT_PWD" disabled="true"> <crn:parameter name="DS_NET_PORT" disabled="true"> <crn:parameter name="DS_NET_PROTOCOL" disabled="true"> <crn:parameter name="DS_NET_PWD" disabled="true"> <crn:parameter name="CDSNetServer" opaque="true" disabled="true"> <crn:parameter name="CDSNetSOAPServer" opaque="true" disabled="true"> <crn:parameter name="DSNET_SOAP_SERVER_LOG_SEVERITY" disabled="true"> <crn:parameter name="CDSNetSocketServer" opaque="true" disabled="true"> <crn:parameter name="DSNET_PWD" disabled="true"> <crn:parameter name="DS_NET_SOCK_PORT" disabled="true"> <crn:parameter name="DSNET_SOCKET_SERVER_LOG_SEVERITY" disabled="true"> <crn:parameter name="PLANNING" opaque="true" disabled="true"> <crn:parameter name="analystMaxSize" disabled="true"> <crn:parameter name="BIInstallLocation" disabled="true"> <crn:parameter name="PlanningServer" opaque="true" disabled="true"> <crn:parameter name="PlanningWindowServiceListeningPort" disabled="true"> <crn:parameter name="PlanningWindowServiceShutdownPort" disabled="true"> <crn:parameter name="OracleODBCDriver" disabled="true"> <crn:parameter name="AAA" opaque="true"> <crn:parameter name="inactivityTimeout"> <crn:parameter name="allowSessionSharing"> <crn:parameter name="restrictAccessToCRN"> <crn:parameter name="renewTCFlag"> <crn:parameter name="advancedProperties" opaque="true"> <crn:parameter name="tenantIdMapping" opaque="true"> <crn:parameter name="tenantBoundingSetMapping" opaque="true"> <crn:parameter name="allowAnon"> <crn:parameter name="disableCM"> <crn:parameter name="id"> <crn:parameter name="authModule"> <crn:parameter name="selectableForAuth"> <crn:parameter name="advancedProperties" opaque="true"> <crn:parameter name="tenantIdMapping" opaque="true"> <crn:parameter name="tenantBoundingSetMapping" opaque="true"> <crn:parameter name="CRYPTO" opaque="true"> <crn:parameter name="cryptoStandardConformance"> <crn:parameter name="localCSK"> <crn:parameter name="CSKPath"> <crn:parameter name="CSKPathPassword"> <crn:parameter name="CSKLifetime"> <crn:parameter name="SSLMutualAuthentication"> <crn:parameter name="SSLConfidentiality"> <crn:parameter name="SSLProtocols" opaque="true"> <crn:parameter name="JVMTrustStorePassword"> <crn:parameter name="digestAlgorithm"> <crn:parameter name="signingKeyPairAlgorithm"> <crn:parameter name="certificateLocation"> <crn:parameter name="cognosCryptoConfidentialityAlgorithm"> <crn:parameter name="cognosPDFConfidentialityAlgorithm"> <crn:parameter name="cognosCryptoCiphersuite" opaque="true"> <crn:parameter name="keystoreFilePassword"> <crn:parameter name="serverCommonName"> <crn:parameter name="distinguishedNameOrganization"> <crn:parameter name="distinguishedNameCountry"> <crn:parameter name="thirdPartyCA"> <crn:parameter name="certificateAuthorityServiceCommonName"> <crn:parameter name="certificateAuthorityServicePassword"> <crn:parameter name="certificateAuthorityServiceCertificateLifetime"> <crn:parameter name="sanDNSName"> <crn:parameter name="sanIPAddress"> <crn:parameter name="sanEmail"> <crn:parameter name="Replication" opaque="true"> <crn:parameter name="pdcEnableReplication"> <crn:parameter name="pdcPeerPort"> <crn:parameter name="pdcRMIPort"> <crn:parameter name="advancedProperties" opaque="true"> <crn:parameter name="CAF" opaque="true"> <crn:parameter name="caf_enabled"> <crn:parameter name="caf_validDomainList" opaque="true"> <crn:parameter name="caf_tpXSSCheckingUsed"> <crn:parameter name="tm1Server" opaque="true" disabled="true"> <crn:parameter name="tm1sConfigDirectory" disabled="true"> <crn:parameter name="tm1sConfigDirectory" disabled="true"> <crn:parameter name="tm1sConfigDirectory" disabled="true"> <crn:parameter name="tm1sConfigDirectory" disabled="true"> <crn:parameter name="tm1sConfigDirectory" disabled="true"> <crn:parameter name="mdmDB" opaque="true" disabled="true"> <crn:parameter name="server" disabled="true"> <crn:parameter name="user" disabled="true"> <crn:parameter name="name" disabled="true"> <crn:parameter name="mdmNotification" opaque="true" disabled="true"> <crn:parameter name="smtpMailServer" disabled="true"> <crn:parameter name="SmtpAccount" disabled="true"> <crn:parameter name="DefaultSender" disabled="true"> <crn:parameter name="defaultReplyTo" disabled="true"> <crn:parameter name="CM" opaque="true"> <crn:parameter name="outputCMReportToFile"> <crn:parameter name="advancedProperties" opaque="true"> <crn:parameter name="server"> <crn:parameter name="user"> <crn:parameter name="name"> <crn:parameter name="SSLencryptionEnabled"> <crn:parameter name="MOB" opaque="true"> <crn:parameter name="NC" opaque="true"> <crn:parameter name="smtpMailServer"> <crn:parameter name="smtpAccount"> <crn:parameter name="defaultSender"> <crn:parameter name="SSLencryptionEnabled"> <crn:parameter name="HTS" opaque="true"> <crn:parameter name="PLACDS" opaque="true"> <crn:parameter name="ContributorDataServer" opaque="true"> <crn:parameter name="PLACDS_sharedSecret"> <crn:parameter name="server"> <crn:parameter name="user"> <crn:parameter name="name"> <crn:parameter name="SSLencryptionEnabled">

I tried out some of these and all showed reasonable information. 
# sq(getConfigurationEntry ( 'gateway' )) #
# sq(getConfigurationEntry ( 'hostName' )) #
# sq(getConfigurationEntry ( 'internalDispatcher' )) #
# sq(getConfigurationEntry ( 'gatewayDispatcherURIList' )) #
# sq(getConfigurationEntry ( 'networkConfiguration' )) #
# sq(getConfigurationEntry ( 'serverLocale' )) #
# sq(getConfigurationEntry ( 'retrieveConfigPassword' )) #

I believe you are looking for:
# sq(getConfigurationEntry ( 'internalDispatcher' )) #

I could not find the portnumber as standalone in the configuration. So an idea could be to configure "advancedProperties" to provide that information.

Hope this helps.​

------------------------------
Ralf Roeber
Managing Partner
Amvara Consulting
------------------------------

Original Message:
Sent: Fri January 31, 2020 09:32 AM
From: Richard Mabjish
Subject: Session macro for server name & port #

@HENK CAZEMIER​

Thank you Henk, this is exactly what I needed, it works great. 
I did not know this function even existed, is there a documentation you can refer me to see what else is available?
Original Message:
Sent: Wed January 29, 2020 11:03 PM
From: HENK CAZEMIER
Subject: Session macro for server name & port #

Hi Richard,
The following macro expression:
#sq(getConfigurationEntry('externalDispatcher'))#
gives you something like:
'http://laptop-p52henkc:9400/p2pd/servlet/dispatch'
Is that something that you can work with?

// Henk

------------------------------
HENK CAZEMIER

Original Message:
Sent: Wed January 29, 2020 03:34 PM
From: Richard Mabjish
Subject: Session macro for server name & port #


Hello All,

I use the $machine macro function in my reports to display Dispatcher server name that handled the report.

Is there a macro that would allow me to also include the port number? for situations were same server has more than one Dispatcher installed.

Thanks!



#CognosAnalyticswithWatson

@HENK CAZEMIER

Is there a list of the arguments that could be used with getConfigurationEntry?​

besides 'serverloacal' and 'externalDispatcher' ....

Thanks!

Original Message:
Sent: Wed January 29, 2020 11:03 PM
From: HENK CAZEMIER
Subject: Session macro for server name & port #

Hi Richard,
The following macro expression:
#sq(getConfigurationEntry('externalDispatcher'))#
gives you something like:
'http://laptop-p52henkc:9400/p2pd/servlet/dispatch'
Is that something that you can work with?

// Henk

------------------------------
HENK CAZEMIER

Original Message:
Sent: Wed January 29, 2020 03:34 PM
From: Richard Mabjish
Subject: Session macro for server name & port #


Hello All,

I use the $machine macro function in my reports to display Dispatcher server name that handled the report.

Is there a macro that would allow me to also include the port number? for situations were same server has more than one Dispatcher installed.

Thanks!



#CognosAnalyticswithWatson

Hi Richard,
The list changes a bit from release to release.
In essence any crn:parameter entries at the top-level of the <install>/configuration/cogstartup.xml  on the cognos server can be retrieved this way.
Note that some of those entries are more complex than a simple string.

// Henk

------------------------------
HENK CAZEMIER
------------------------------

Original Message:
Sent: Mon February 03, 2020 10:01 AM
From: Richard Mabjish
Subject: Session macro for server name & port #

@HENK CAZEMIER

Is there a list of the arguments that could be used with getConfigurationEntry?​

besides 'serverloacal' and 'externalDispatcher' ....

Thanks!

Original Message:
Sent: Wed January 29, 2020 11:03 PM
From: HENK CAZEMIER
Subject: Session macro for server name & port #

Hi Richard,
The following macro expression:
#sq(getConfigurationEntry('externalDispatcher'))#
gives you something like:
'http://laptop-p52henkc:9400/p2pd/servlet/dispatch'
Is that something that you can work with?

// Henk

------------------------------
HENK CAZEMIER

Original Message:
Sent: Wed January 29, 2020 03:34 PM
From: Richard Mabjish
Subject: Session macro for server name & port #


Hello All,

I use the $machine macro function in my reports to display Dispatcher server name that handled the report.

Is there a macro that would allow me to also include the port number? for situations were same server has more than one Dispatcher installed.

Thanks!



#CognosAnalyticswithWatson

Additional comments can be enabled for SQLs generated by Cognos to include details like user name, dispatcher etc.
The details are available in native SQLs generated by cognos in audit tables.

------------------------------
Sudheen Kulkarni
------------------------------

Original Message:
Sent: Wed January 29, 2020 03:34 PM
From: Richard Mabjish
Subject: Session macro for server name & port #


Hello All,

I use the $machine macro function in my reports to display Dispatcher server name that handled the report.

Is there a macro that would allow me to also include the port number? for situations were same server has more than one Dispatcher installed.

Thanks!



#CognosAnalyticswithWatson

This is from 10.1, but back in the day we had access to complete documentation on all available Calculation Components like this.  It's pretty important stuff, hopefully IBM will bring that back
https://www.ibm.com/support/knowledgecenter/en/SSEP7J_10.1.0/com.ibm.swg.im.cognos.ug_fm.10.1.0.doc/ug_fm_id23945macro_functions.html
again, these are OLD, but I would imagine the bulk of these components are still available.

------------------------------
Albert Valdez
albert@intelalytics.com
------------------------------

Original Message:
Sent: Thu January 30, 2020 01:02 PM
From: Sudheen Kulkarni
Subject: Session macro for server name & port #

Additional comments can be enabled for SQLs generated by Cognos to include details like user name, dispatcher etc.
The details are available in native SQLs generated by cognos in audit tables.

------------------------------
Sudheen Kulkarni

Original Message:
Sent: Wed January 29, 2020 03:34 PM
From: Richard Mabjish
Subject: Session macro for server name & port #


Hello All,

I use the $machine macro function in my reports to display Dispatcher server name that handled the report.

Is there a macro that would allow me to also include the port number? for situations were same server has more than one Dispatcher installed.

Thanks!



#CognosAnalyticswithWatson

Thank you 

@HENK CAZEMIER , @Ralf Roeber, @Albert Valdez

The ability to capture values from ​​​cogstartup.xml at runtime is very powerful , I will be putting it to a good use.


Original Message:
Sent: Tue February 04, 2020 12:37 PM
From: Albert Valdez
Subject: Session macro for server name & port #

This is from 10.1, but back in the day we had access to complete documentation on all available Calculation Components like this.  It's pretty important stuff, hopefully IBM will bring that back
https://www.ibm.com/support/knowledgecenter/en/SSEP7J_10.1.0/com.ibm.swg.im.cognos.ug_fm.10.1.0.doc/ug_fm_id23945macro_functions.html
again, these are OLD, but I would imagine the bulk of these components are still available.

------------------------------
Albert Valdez
albert@intelalytics.com

Original Message:
Sent: Thu January 30, 2020 01:02 PM
From: Sudheen Kulkarni
Subject: Session macro for server name & port #

Additional comments can be enabled for SQLs generated by Cognos to include details like user name, dispatcher etc.
The details are available in native SQLs generated by cognos in audit tables.

------------------------------
Sudheen Kulkarni

Original Message:
Sent: Wed January 29, 2020 03:34 PM
From: Richard Mabjish
Subject: Session macro for server name & port #


Hello All,

I use the $machine macro function in my reports to display Dispatcher server name that handled the report.

Is there a macro that would allow me to also include the port number? for situations were same server has more than one Dispatcher installed.

Thanks!



#CognosAnalyticswithWatson