Create a Chart with 2 measures and percentage

Used in Cognos 8.4

To achieve this we need to join 2 facts on one time dimension

After publishing the package we create a new report.

Drag in a combination chart

In the series we put 2 measures

After that we create a new data item in the query with the calculation:

[MEASURE2] / [MEASURE1]

We name it PERCENTAGE

After that we drag the PERCENTAGE in the series

chart_2_measures

The following settings are important:

Click on the chart > complete chart is gray

chart_2_measures_2

Click on the right y-axis

chart_2_measures_3

Click on label left of MEASURE1

chart_2_measures_4

Click on label left of MEASURE2

chart_2_measures_5

Click on label left of PERCENTAGE

chart_2_measures_6

Click on the PERCENTAGE

chart_2_measures_7

The result when running the report:

chart_2_measures_8

Custom Chart Palettes

Some Companies want to have a special set of colors when they use charts in a report.

Underneath an example of two charts. One with default colors an the other with custom colors.

custom_chart_color_6 custom_chart_color_5

 

Solution:

This can be achived by editing 2 system XML files.

It is to be recommended to save the original files so you wil be able to return to the original configuration.

The article describes the process by which you can add new chart palettes or customize existing chart palettes for use in IBM Cognos 8 Report Studio.

Click on the following link to open the PDF:

custom_chart_palettes_for_report_studio.pdf