Skip to Main Content

Analytics Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Using semicolon as delimiter when generating CSV with agent

1468930Dec 5 2014 — edited Dec 10 2014

Hi Oracle Experts,

I have the following question, we want to generate an CSV with an agent that uses an semicolon ; as delimiter.

When looking for Oracle documentation I noticed the following article: http://docs.oracle.com/cd/E28280_01/bi.1111/e10541/answersconfigset.htm#BIESG1311

When checking 19.2.2 and adding the code to the instanceconfig, the first part works correctly:

<Export xsi:type="excel">

  <RepeatRows>false</RepeatRows>

  </Export>

Unfortunately when I add the other pieces of the code:


<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>

Further down in the script:

</ServerInstance>


And restart the server within the Enterprise manager the coreapplication_obips1 won't start correctly therefore the OBIEE logon page won't show.

The part that worked correctly in the instanceconfig and where the coreapplication_obips1 did restart correctly was:

<WebConfig xmlns="oracle.bi.presentation.services/config/v1.1" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance">

  
<ServerInstance>

     <Download>

      <Export xsi:type="excel">

        <RepeatRows>false</RepeatRows>

    </Export>

     </Download>

 
_______________________________________________________________________________________________

As soon as I replace the above part with:

<WebConfig xmlns="oracle.bi.presentation.services/config/v1.1" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance">

   <ServerInstance>

     <Download>

 <Export xsi:type="formattedText"> <Delimiter char=";"/> </Export> 

     </Download>

It will NOT work.

I added the current instanceconfig.xml for further reference.


It is quite likely that there is an error in the Oracle documentation.

Please help.

Comments
Locked Post
New comments cannot be posted to this locked post.