Blog

Cognos Percentage calculation by total

percentage([Counts])
percentage(count (distinct [DataItem]))

Create a calculation by above syntax. Drag that column to cross-tab. You should be getting percentages of summary data.

Topics: Cognos Cross Tab & percent calculation in Total
cognos cross tab how to add percentage

https://it.toolbox.com/question/crosstab-percent-calculation-in-total-071706

cognos scheduled reports are stuck in wait state

in progress…

cognos notification test pass but email doesn’t come

Unable to send emails from Cognos Server but no errors appear in the cogserver.log file
https://www-01.ibm.com/support/docview.wss?uid=swg21339824

https://www.cognoise.com/index.php?topic=26364.0

https://it.toolbox.com/question/cnc-sds-0408-there-are-email-messages-waiting-to-be-sent-072011

CNC-SDS-0408 There are email messages waiting to be sent.

CNC-SDS-0410 The email message was not sent
https://www-01.ibm.com/support/docview.wss?uid=swg22012214

cognos analytics [Validate mail server properties.] [ ERROR ] The mail server cannot be reached.

Cognos Scheduled Jobs Randomly Stuck in ‘Waiting’ State
https://www-01.ibm.com/support/docview.wss?uid=swg21689979

Testing mail server connection: [ERROR] Mail server authentication failed
https://www-01.ibm.com/support/docview.wss?uid=swg21342280

How to get SQL from Tableau

Follow below steps:

select Help → Settings and Performance → Start Performance Recordingfrom the Tableau toolbar.

Then right click on the source in the Data toolbar and select ‘Refresh’. This will force Tableau to re-run the query.

Once the query completes, select Help → Settings and Performance → Stop Performance Recording from the Tableau toolbar.

This should result in a new Tableau window opening with a workbook called ‘Tableau — PerformanceRecording’

Right-click anywhere in the bar next to ‘Executing Query’ and select ‘View data’

Source of the article:
Below URL gives a very good idea about this
https://blog.openbridge.com/7-steps-to-export-sql-statements-from-tableau-7e51a2fd4277