chart output axis changes when running analysis studio report

[nfldbunker]

hi

i have a report portal created with a lot of analysis studio reports. users see charts along with crosstab of data. when users export these reports to either excel or pdf the axis of the chart changes to a much larger values and the graphs are changed because the axis changes and look awful.

is there a way to keeo everything consistent

regards

bunker

[IceTea]

This is a bug in the Cognos Excel Export. Cognos exports the xls and generates the DataSource / the Data values directy into the charts. There they values are saved with "." as decimal point AND (this is the problem) with also "." as value separator. This is it as it acts in our environment (Cognos Installation in german, user preferences also german).


Example:

Fact Data in the report is for Dimension Year:
2007: 30,52
2008: 41,45
2009: 50,99

The Data Values in the exported Excel Chart look like:
30.52.41.45.50.99

So you have a Excel-Chart with 6 facts instead of 3.

If anyone knows how to deal with this, help is appreciated. Our Cognos Version is 8.4.1 with latest Fixpacks. Trying to format the Data Elements to zero decimal in the query or directy in the ReportStudio-Diagram did not affect this beaviour...