in progress
http://cognospaul.com/2014/01/02/creating-data-entry-page-cognos/
Category: Cognos Analytics
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
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
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
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
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
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
Cognos analytics temp folder files unable to delete
At cognos Server- UDA and TMP files are few files which get created when a report is been run. These files will be deleted automatically after the report run is finished.
We might be in a situation when this files go big and not getting deleted after the session. At that time you can delete them manually. But if you are not able to delete manually (assuming you are having admin rights) then you need to check at cognos connection if any reports are running at background. Make sure there are no reports running in background, if they are then notify user and kill them.
An other option is to kill few services at task manager(not the cognos server related) and check whether the temp files are deleted or not.
topic:
cognos analytics uda files unable to delete
cognos analytics UDA Temp Files
resource:
http://www-01.ibm.com/support/docview.wss?uid=swg21358858
https://www.ibm.com/support/knowledgecenter/SSEP7J_11.0.0/com.ibm.swg.ba.cognos.tg_bitshoot.doc/c_cognos8runsoutoftempspace.html
cognos analytics mobile configuration steps
cognos – You don’t have access to this asset. It might have been disabled, deleted or your permissions might have been reduced. Verify the state of the asset at its expected source location. You can remove the asset from your recent items by tapping OK.
Cognos analytics user gets a below error message –
No Access
You don’t have access to this asset. It might have been disabled, deleted or your permissions might have been reduced. Verify the state of the asset at its expected source location. You can remove the asset from your recent items by tapping OK.
User will get this access error request when they are trying to access the report from recently run reports which they had lost access to.
Once access given they shouldn’t see this error.
Save cognos report to file system / Bursting Cognos Reports to File System
Save cognos report output to a server/network drive.
Bursting Cognos Reports to File System
To achieve bursting first we should make sure all the below steps are completed and tested.
Steps:
part A: Configure Cognos Configuration.
1. Create a shared folder. Make sure that cognos servers are having access to this folder by checking properties, security of that folder
2. Go to Cognos Configuration –> actions–> General –> Archive file location –> type : file://\\servername\directory or file:///
3. Click test to make sure your syntax and access to that folder are accessible.
4. Go to “Data Access”–> Content Manager–> “Save report output to a file system” –> Change the value to “True”.
5. Restart the cognos service.
6. Save cognos configuration and restart the service.
7. Make above changes to all the content managers.
Part B: Creating File system at Cognos Connection
1. In Cognos administration, go to Configuration –> dispatcher and services
2. top right hand side click on “Define File system Location”
3. New — > provide name, File system location (this would be sub folder under file system location)
4. click Finish
You can create more file system locations to save reports in different folders in same main folder. This way you will have multiple folders at your file system location.
Part C: Saving the report to file system location.
1. at cognos connection go to required report — > “run with options” –> Advanced Options –> Run in the background –> You will see a new option on your right near delivery- “Save to the file system”. check this box and click on ” Edit the file system options”.
2. select/provide required location, Conflict Resolution, Name.
3. Click OK and then Run.
4. you would see new report in the new folder you mentioned
after above steps are completed and tested as required we can re-do Part-C by checking Bursting Option which would help the report to Burst to required folder.
Sources:
http://www-01.ibm.com/support/docview.wss?uid=swg21342666
http://www-01.ibm.com/support/docview.wss?uid=swg21381810
Cognos analytics image location
If you want to insert any new image in your report then you should place that image at following folder
install_location\webcontent\bi\images
Before Cognos analytics, images were placed at location –
install_location\webcontent\images
When migrating from cognos 10 to 11 make sure to copy your images and place it at appropriate folder.
Data Engineering and BI BLOG 