SUPPRESS VALUES IN REPORT BUT REPEAT VALUES IN EXCEL EXPORT

1. Open the instanceconfig.xml file located in

ORACLE_INSTANCE\config\OracleBIPresentationServicesComponent\coreapplication_obipsn

2. Enter the following namespace declaration in the WebConfig element:

Note that the Export element includes the required attribute xsi:type, which specifies the type of export. Valid values are:

• excel (for export to Excel)
• formattedText (for data export)
• pdf (for export to PDF

3. Locate the Download section in which you must add the elements that are described in the table below.Include the elements and their ancestor elements as appropriate, as shown in the following example:

<ServerInstance>
  <Download>
    <Export xsi:type=”excel”>
        <RepeatRows>false</RepeatRows>
    </Export>

    <Export xsi:type=”formattedText”>
        <Delimiter char=”,”/>
    </Export>

    <Export xsi:type=”pdf”>
        <KeepRowsTogether>true</KeepRowsTogether>
    </Export>

  </Download>
</ServerInstance>

4. Save your changes and close the file.

5. Restart Oracle Business Intelligence.

Elements for Manually Configuring for Export:

Element	Description	Default Value
RepeatRows	Specifies whether cells that span rows and cells that span columns are to be repeated when users export tables and pivot tables to Microsoft Excel.Ifset to true, then cells that span rows and cells that span columns are repeated, regardless of theValue Suppression setting in the Analysis editor. For example, in a table that has Year and Month values, Year is repeated for all Month values.If set to false, then the behavior is the same as that defined by the Value Suppression option in the Analysis editor: – If Value Suppression is set to Suppress, then cells that span rows and cells that span columns are not repeated. For example, in a table that has Year and Month values, Year is displayed only once for Month values. – If Value Suppression is set to Repeat, then cells that span rows and cells that span columns are repeated. For example, in a table that has Year and Month values, Year is repeated for all Month values. For more information on the Value Suppression option, refer to this document: Value Suppression. The export type is: xsi:type=”excel”	false
Delimiter	Specifies the column delimiter character for theCSV Format option, for example, a semicolon (;), when exporting raw data from results andviews.The export type is: xsi:type=”formattedText”	“,”
KeepRowsTogether	Specifies whether rows are to be kept together at page breaks when exporting to PDF.If set to true, rows are kept together at page breaks.If set to false, rows are split across page breaks. The export type is: xsi:type=”pdf”	false