Oracle^® Business Intelligence Presentation Services Administration Guide > Administering Oracle BI Dashboards >

Downloading Oracle Business Intelligence Results in Non-UNICODE Format

Oracle Business Intelligence provides options for downloading results that appear in Answers as options for the Download link. The Download link can also appear with a request in a dashboard.

By default, the Download Data option downloads results in a UNICODE, tab-separated text file. For organizations that require a non-UNICODE, comma-separated file for use with certain applications, you can override behavior of the Download Data option or add another download option by modifying the message kmsgEVCDownloadLinks in the XML messages file viewscontrolmessages.xml.

If you change the behavior of the Download Data option or add a new option that retrieves comma-separated data, the entry in the Oracle BI Presentation Services configuration file (instanceconfig.xml) described in this section is used to determine the character set to use. You can view supported character sets by examining the message file charactersetdefinitions.xml located in the SADATADIR\web\config directory, where SADATADIR is the data directory.

For example, adding the following XML code to the message kmsgEVCDownloadLinks in the file viewscontrolmessages.xml file adds the option Download CSV to the Download link:

          <a class="NQWMenuItem" name="SectionElements"
href="javascript:void(null);" onclick="NQWClearActiveMenu();
Download('@{command}&amp;Format=csv&amp;Extension=.csv')">Download CSV</a>

The Download CSV option downloads a comma-separated file that uses the following entry to determine the character set.

For information about working in the Oracle BI Presentation Services configuration file (instanceconfig.xml), read Making Oracle BI Presentation Services Configuration Changes.

The following entry is an example:

<CSVCharset>us-ascii</CSVCharset>

For information about making changes to the XML messages files, read Customizing the Oracle BI Presentation Services User Interface Using XML Message Files.