COGNOiSe.com - The IBM Cognos Community

IBM Cognos 8 Platform => COGNOS 8 => Report Studio => Topic started by: aliclowes on 10 Mar 2010 04:20:36 AM

Title: Charts using cubes - a problem
Post by: aliclowes on 10 Mar 2010 04:20:36 AM
Hi

When I create a chart from a cube using a dimension short code on the x axis, the source label is shown on the axis rather than the short code, however if I use the same short code in a list the short code is shown.

Has anyone had this problem before and does anyone know how to get round this 

Title: Re: Charts using cubes - a problem
Post by: CognosPaul on 10 Mar 2010 04:35:25 AM
What you're seeing is the difference between the default behaviours of charts and lists.

Click on the list column body - the field in the list. In source type you'll see "Data Item Value". Now click on the chart node member in the chart. In source type it says "Member Caption". Simply change the source type to Data Item Value and that should solve your problem.