Oracle Transactional Business Intelligence Forum

Home› Oracle Analytics and AI› Oracle Analytics and AI Forums› More Solutions› Oracle Transactional Business Intelligence Forum

Categories

Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture

24A - OTBI Data Exporting updates

Received Response
83
Views
2
Comments
Frank Davidson
Frank Davidson Rank 1 - Community Starter
in Oracle Transactional Business Intelligence Forum

Exactly what object types in OTBI are impacted by this 24A advanced notice. Does impact extend to csv or tab delimited files which are manually generated using rtf templates? Please direct us to additional detail around 24A CSV/tab delimited exporting changes. Specifically for the addition of apostrophes as an escape character to analysis/dashboard export output.


https://docs.oracle.com/en/cloud/saas/otbi/otbi-notable/index.html#GUID-69D70740-2CFC-44C5-B595-6B5C1086F27C

Tagged:

Answers

  • Skolli-Oracle
    Skolli-Oracle Rank 4 - Community Specialist

    By default in 24A, exporting OTBI analysis (Subject area) output to csv or tab delimited files will have apostrophe appended when the data has prefixed formula characters.

    Admin user can change the property "Export Data to CSV and Tab-Delimited Files as Text" to disable this feature. For more details, please refer to the help center document:

    https://docs.oracle.com/en/cloud/saas/otbi/otbi-admin/administration-page.html#GUID-B1E435A9-5B7A-49FC-B9B1-4650DA93B254

  • Rich Merkel
    Rich Merkel Rank 6 - Analytics & AI Lead

    We will test this out in our dev environments once patch is applied this weekend. What is the thought, I'm having a bit of trouble to understand the document.

    Do we need to do anything to keep the export to csv working as it is today? I wasn't sure if default remains as it was or if we need to disable the feature to remain working as was prior to patch.

    Much appreciated.