cognos visualization library and customizer

IBM Vizualization Customizer : https://www.ibm.com/communities/analytics/cognos-analytics-
blog/cognos-business-intelligence-cognos-analytics-visualization-customizer/

1. Run VisCustomizer.jar
2. Open vis.sample.clusteredbar.zip from file menu
3. Amend the vizJSON part as you required .
4. Select Chart Type Definition tab
5. Change the values of Bundle Name text box  
6. Example : in place sbm any text you  can mention
7. vis.sample.clusteredbar.zip to vis.sample.clusteredbar.sbm.zip
8. Select String Resources tab 
9. Tag Metion : clusteredbar
10. Change the values of lblChartType=clusteredbar to lblChartType=clusteredbar-sbm
11. Validate Bundle button
12. Upgrade Definition  button
13. Generate Vis Bundle Definition button
14. click to save / save as
15. Give new name : vis.sample.clusteredbar.sbm.zip
16. import file to cognos

        2.3 : Select String Resources tab and change the values of lblChartType=Chord to lblChartType=Chord-sbm
        2.4 : Click on Validate Bundle button to check the validity of changes. (Valid message will appears).
         2.5 : Click on Upgrade Definition  button. (The definition was successfully upgrades message will appears).
               2.6 : Click on Generate Vis Bundle Definition button then click to save the file with new name  (ex: vis.sample.chord_sbm_10_2_2.zip.)
               2.7 : Import the file to your Cognos Environment then you will have two visualizations as below

==================================================

If you are facing some issue while open library file ?

1. Open VisCustomizer.jar
2. Remove validate check box then click on Draw chart.
3. then open library file

cognos Audit Milisecond to hour convert

Milisecond to hour calculate in cognos audit

[Audit].[Run Reports].[Execution time]/(1000*60*60)

Cognos report studio image file configuration IIS

Details find in link : https://www-304.ibm.com/support/docview.wss?uid=swg21506690

Configuring WebDav on IIS 7.5 to have access to your image on Report Studio:

 Verify in Server Manager that the following IIS components are installed:
- Webdav Publishing
- Windows Authentication

Go then on Default Web Site and activate Webdav and Windows Authentication (both are disabled by default):

 

 

Double click on WebDav Authoring Rules on Default Web Site level and then click on WebDav Settings…

- Modify "Allow Anonymous Queries" to "True"

- validate clicking on "Apply"

Go then in Samples/images in Cognos IIS alias and add a Webdav rule, for example all content / all users / read as below:

You can now navigate in the Report Studio Browser Image:

Distinct count on report studio

Count(distinct [MBRSHP_NO_BK] for [DOCTOR_NAME])

cognos report Total defined at any level in dyanmic cube

I have measure column called "Member_Count"
I need to extract member total to "Member_Count"
you can define which level you wanted to make total for my case defined at doctor level.

Make new iteam:

total ([Member_Count] for [Query3].[Doctor])

Derived / Extracted measure in report studio using cognos dynamic cube

If want to create new measure in dyanamic cube cognos while reporting in cognos.

like below.

Please note don't take level don't take description so its better to take Key to calculate extracted measures.

---
CASE WHEN
[Main Service - Key] = 'ACCOMODATION'
THEN [Inputed Quantity]
ELSE 0
END
----

Saving Report Output to the Cognos Server File System - Automatically

Saving Report Output to the Server File System


ENABLING THE SAVE TO FILE WITHIN COGNOS CONFIGURATION

1. From Cognos Connection, click on Launch (top right)
2. Click Cognos Administration
3. Click on Configuration tab
4. Click Dispatchers and Services (left side)
5. Click the Define File System Locations button ( top right)
6.