Export Data in CSV File Format
You can export reports as delimited text format.
Delimited text format is one of the most popular export formats, because the resulting file can be used as an import source by many applications. The delimited text format ensures a high degree of compatibility in multi-language environments. It also ensures reliability when importing into other applications such as Microsoft Excel.
PowerPlay® uses the following format conversions when you create a .csv file.
| Format | Conversion Details |
|---|---|
| Numeric data |
The decimal symbol for the locale is used, even if the format or pattern of the number contains an explicit decimal that differs from the locale. The digit grouping symbol (the symbol used to group large numbers such as thousands in the US locale) is not used in the CSV export. The negative sign symbol but not the format of the locale is used. This may also be different from the explicit format used for that number. The negative symbol is always leading. For example, for a German locale of DE_DE, a number that was formatted as (765 000.45) is exported to CSV format as -765000,45. |
| Currency data |
Currency values follow the same rules as numbers. The currency symbol is not exported. For example, if the locale is EN_US, and the format of the number in an IBM® Cognos® PowerPlay report is $123,456.00, PowerPlay exports 123456.00. |
| Character data |
In some products, you can optionally allow quotes to be put around the text. This technique ensures that a text field containing the list separator (such as a comma) is not interpreted as multiple fields in the exported file. |
| Date and time data |
Dates are exported in ISO format, YYYY-MM-DD. Time is exported as ISO format, hh:mm:ss.The hour value (hh) uses the 24-hour clock. Note: In PowerPlay, the date is defined in the Transformer model and is exported as text. |
You can view this data in any application that supports comma separated value files, such as Microsoft Excel. If you do not have Microsoft Excel installed, you can save the .csv file to your computer, and then open the file in another application.
If your administrator enabled the Dimension Line in CSV Export setting, the dimension line appears in your .csv file.
If you have Microsoft Excel installed, you can save the comma-separated value file (.csv) to your computer or open the data directly in Microsoft Excel.
Before you begin
To open the data directly in Microsoft Excel, your Web browser must be configured to recognize the CSV format.
To configure Microsoft Internet Explorer Web browsers for Export CSV, you must set the MIME type for the Microsoft Excel Comma Separated Values File format to text/x-csv for your operating system.
Procedure
- Click the file button
and click Export CSV.
You are prompted to open the file or save it to your computer.