Cognos 10 Report Studio - Adding secondary value axis to the chart

This example shows, how to add secondary value axis to the chart in C10 Report Studio. For example in this bar chart 'revenue' and 'profit margin %' measures can't use same axis (Pic.1.)




Pic.1

CASE statement giving error in SSRS query designer

This is someting "back to basics" stuff.. :)

In SSRS query designer I needed write CASE statement like this:

        (CASE WHEN (tf_table.applicationtype = 1)  THEN ('first') 
         ELSE (tf_table.applicationtype) ) AS application

.....But I got error message:

Cognos 10 Report Studio - Format tooltip values

I show tooltip in a chart but measure value is too precise, like 1,629387. I want to show only one decimal. So, here are steps how to modify that tooltip value:

[ 1 ] On the chart Series / Sarja box, click measure text
[ 2 ] Go to  Properties - Chart Node Member / Ominaisuudet - Kaavion solmujäsen
[ 3 ] Click ellipsis (...) in the Data Format / Tietomuoto section to open properties and modify format of the measure as you like.