If you are unable to create a new account, please email support@bspsoftware.com

 

News:

MetaManager - Administrative Tools for IBM Cognos
Pricing starting at $2,100
Download Now    Learn More

Main Menu

Problem in downloading report output in CSV in cognos 8.1

Started by gvraocognos, 29 Jun 2012 04:47:48 AM

Previous topic - Next topic

gvraocognos

Hi All,
Currently i am working on cognos 8.1, i am facing a problem for downloading report output in csv format.
In my report dynamically selection measures columns using prompt page. i have A,B,C,D columns in prompt I have selected A and C columns in prompt and run the report. In HTML and Excel I am getting A and C columns only. But when i download CSV format i am getting A,B,C and D columns, selected columns are displayed with data and non selected columns are displayed with out data. And also data not same.

For example:
HTMT Output result is 100%
Excel Output result is 100%
CSV Output result is   1



Many thanks in advance.
Venkata Rao  :'(

MFGF

When rendering to CSV, you get all the data and no formatting. Your report works by hiding the measures you don't want to see using conditional rendering (I'm guessing) but this part of the formatting options which get ignored when rendering as CSV. Similarly with the values, you have a data item which contains real values such as 0.76, but the report is configured to format these as percentages so you see 76%. Again, formatting gets ignored when rendering as CSV - you just get the data.

If you want to render as CSV and show only a specific set of measures, you will need to change the way your report works - perhaps have calculated fixed columns which use an if-then-else construct to decide which measure to display, and have a calculation for each percentage measure that physically multiplies the underlying number by 100 so you see the percentages in your CSV.

It's not an error - it is just a facet of the way your particular report is written.

Regards,

MF.
Meep!