Oracle Transactional Business Intelligence Idea Lab

Home› Oracle Analytics› Oracle Analytics Idea Labs› More Solutions Idea Labs› Oracle Transactional Business Intelligence Idea Lab

Categories

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

Ability to export data in other format's specially excel when executing a query in BI data model

Submitted
262
Views
4
Comments
Nitin Razdan
Nitin Razdan Rank 1 - Community Starter
edited May 12, 2025 8:39PM in Oracle Transactional Business Intelligence Idea Lab

Description

When executing a query in data model , export button by default downloads file in xml format , which makes it difficult to read and share . Even though there is a time extensive work around to create a report out of data model in order to export in excel but its not a good solution. 

So ask here is to export the data in multiple formats specially excel. 

Use Case and Business Need

When executing a query in data model , export button by default downloads file in xml format , which makes it difficult to read and share . Even though there is a time extensive work around to create a report out of data model in order to export in excel but its not a good solution. 

So ask here is to export the data in multiple formats specially excel. 

Original Idea Number: 83fb5b042f

data model export.GIF

8
Up
8 votes

Submitted · Last Updated

Comments

  • Ahmed Maher K.
    Ahmed Maher K. Rank 6 - Analytics Lead

    Agreed. The xml is helpful for the technical development work, but it is required to export the full query data result on excel file.

  • Swapnil Kashid
    Swapnil Kashid Rank 4 - Community Specialist

    Data can be exported in excel format as well. By using excel feature click on Data --> From Other Sources --> From XML Data Import

    This would convert the XML that is being exported through Data model in table level, you can always utilize this feature

    Regards,

    Swapnil

  • Hari Arumugam
    Hari Arumugam Rank 1 - Community Starter

    Hi Nitin,

    Yes, I was also looking for this ability. We have using the exported XML as mentioned by Swapnil. But every time when we do this, especially when we are having multiple data model results exported in XML do not render the structure correctly in excel automatically. If we have an option straight away as a single click to export it in excel, it would help us saving lots of time.

  • Swapnil Kashid
    Swapnil Kashid Rank 4 - Community Specialist

    Agreed Hari, it really becomes difficult when multiple data sets have output generated with multiple rows for each data sets.

    It becomes a cumbersome task to correlate the data.