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

cognos analytics RAVE visualization customize

ibm cognos rave visualization

Below links provide good information about rave visualization and customization.

Below articles provide good information about rave

https://www-01.ibm.com/support/docview.wss?uid=swg21973160

https://developer.ibm.com/recipes/tutorials/rave-charts-vs-external-charts-in-cognos/?mhq=rave&mhsrc=ibmsearch_d

Click to access HowtoaddextensiblevisualizationtoCognosActiveReports-AllVisualizations.pdf

cognos analytics heat map display numbers with total
https://www.ibm.com/developerworks/community/forums/html/topic?id=8205c888-235e-4922-b2a2-2b5964b61862&mhq=heatmap%20display%20values&mhsrc=ibmsearch_a

at following url you can find rave visualization customizer / sample visualzations and rave visualization customize –
https://www.ibm.com/developerworks/community/groups/service/html/communityview?communityUuid=9685c9a6-3133-4823-85e8-f5f81268267a#fullpageWidgetId=W561990aafebc_4d8b_9af8_7c03c0081265

https://www.ibm.com/communities/analytics/cognos-analytics-blog/cognos-business-intelligence-cognos-analytics-all-visualizations/

https://www.ibm.com/developerworks/community/groups/service/html/communityview?communityUuid=9685c9a6-3133-4823-85e8-f5f81268267a#fullpageWidgetId=Wc1aa99476ad4_4458_9a7d_4f3a60bc90f5

heatmap display values with totals:
https://www.ibm.com/developerworks/community/forums/html/topic?id=8205c888-235e-4922-b2a2-2b5964b61862&mhq=heatmap%20display%20values&mhsrc=ibmsearch_a

few useful links

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

http://www-01.ibm.com/support/docview.wss?uid=swg21989490

https://www.ibm.com/support/knowledgecenter/en/SSEP7J_11.0.0/com.ibm.swg.ba.cognos.ug_cra.doc/t_asg_managing_visualizations.html

http://www-01.ibm.com/support/docview.wss?uid=swg21993750

https://www.ibm.com/communities/analytics/cognos-analytics-blog/cognos-business-intelligence-cognos-analytics-all-visualizations/

IBM Cognos analytics Product images don’t show in Event Studio

When trying to access Event studio , images/icons are missing. Errors show up when trying to accessing any icons.

Errors like below:

  • Object doesn’t support property or method ‘select Tab’ [getMessageFrame().selectTab(‘AgentTask-tasknumber’,’report’);]
  • ‘doAction’ is underfined[doAction(‘url’)]

 

Screenshot of Event Studio which is having missing images when accessed

event studio issue c11

Solution:

Mostly this issue is happening because of IIS configuration. To make sure this- open the dispatcher URL at server and check Event studio. Event studio should be working as  required. Now this tells us that there is some issue with IIS configuration.

Go through the event studio steps by following IIS configuration guide- Event studio section

https://www.ibm.com/support/knowledgecenter/en/SSEP7J_11.0.0/com.ibm.swg.ba.cognos.inst_cr_winux.doc/t_gateway_iis.html

Though you might have run the bat file given by IBM, It might still not do all of it correctly. Its better to double check.

When I had this issue. Event Studio  at URL Rewrite was missing 1 condition and Logical processing was set to “Match All”. I added that missing condition and changed Logical processing to “Match Any”

 

Following article talks about similar issue at UNIX server

https://www-01.ibm.com/support/docview.wss?uid=swg22010297

 

Cognos how to hide pages/fields based on output format

 

create a render variable with ‘Expression Definition:’ as

ReportOutput () in ( ‘spreadsheetML’) –this would give output only for excel output report
ReportOutput () in ( ‘PDF’) — this would give specified output only for pdf output report.
ReportOutput () not in ( ‘PDF’) — This will hide specified output for pdf output report

Values that you could pass are:
items: [xlsxData, CSV, spreadsheetML, HTML, layoutDataXML, PDF, XML, XLWA, MHT, rawXML, XHTML, singleXLS, HTMLFragment]
case sensitive: true
Source:
https://www.ibm.com/support/knowledgecenter/SSEP7J_10.2.1/com.ibm.swg.ba.cognos.ug_md.10.2.1.doc/c_crx_reportoutput.html

 

BME-EX-0047 Unable to read preferences for the requested interface. Please use another repository and/or ProjectAccess Interface.

I was getting following Cognos framework error while opening the model.

BME-EX-0047 Unable to read preferences for the requested interface. Please use another repository and/or ProjectAccess Interface.

I got this error for framework 11.0 after we had a patching on windows.

I reinstalled the software in same path with same version and it worked.
None of the framework models were effected.

 

source:

https://www.ibm.com/support/pages/node/260415