0 Replies Latest reply: Mar 28, 2013 1:24 AM by 890114 RSS

    OBIEE Report Export from Dashboard to Excel doesn't suppress the columns as

    890114
      OBIEE Report Export from Dashboard to Excel doesn't suppress the columns as expected even after the properties are set to Suppress in the report. In Dashboard it is suppressed Properly but in the excel export it is not suppressed and values for the columns are repeated.

      Added the following to the instanceconfig :
      <Download>
      <Export xsi:type="excel">
      <DataValue>UseFormattedValue</DataValue>
      <RepeatRows>false</RepeatRows>
      </Export>
      </Download>

      But then could not restart services.The following error occured :
      Util Logger] Exception occurred:
           Severity:1
           Type:PKN3saw9ExceptionE
           File:saxreader.cpp
           Line:681
           Message:Sax parser returned an exception.
      Message: The prefix 'xsi' has not been mapped to any URI, Entity publicId: /oracle/ofm/instances/instance1/config/OracleBIPresentationServicesComponent/coreapplication_obips1/instanceconfig.xml, Entity systemId: , Line number: 43, Column number: 26

      Edited by: 887111 on Mar 27, 2013 11:23 PM