Oracle Analytics Cloud and Server Idea Lab

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

Export dataset or project to an Excel file type format

Delivered
341
Views
16
Comments

Description

Customers are requesting the ability to export a dataset or a project (canvas) to an Excel file type format and NOT only in CSV as it's not keeping the format they need.

Use Case and Business Need

Customers are requesting the ability to export a dataset or a project (canvas) to an Excel file type format and NOT only in CSV as it's not keeping the format they need.

Original Idea Number: 0f7a65076d

50
50 votes

Delivered · Last Updated

Feature delivered as a Preview: Export table visualizations to Microsoft Excel in the November 2022 Update.

Welcome!

It looks like you're new here. Sign in or register to get started.
«1

Comments

  • Rank 4 - Community Specialist

    This is needed as some customers first do self-service analysis and then they want to share the results with excel savvy people who want to continue their analysis in excel. Respecting the format of tables and pivot tables is needed for that.

  • Rank 3 - Community Apprentice

    We've had many users ask why they can't export to excel and complain that their pivot tables are not retaining the same format when they export to CSV. If you include a column in your pivot (e.g. MONTH), the CSV exports it as a flat detailed list, and loses the pivot summarization... For example:

    Pivot in OAC appears as:

    Customer Jan Feb
    A 100 200
    B 400 500

     After exporting to CSV, appears as:

    Customer Month Amount
    A Jan 100
    A Feb 200
    B Jan 400
    B Feb 500

     

  • Rank 5 - Community Champion

    The ability to transform and/or share insights/information from a DV project in excel, respecting minimal formatting would be of high added value.

  • Rank 2 - Community Beginner

    Perficient as a company has standardized on OAC for enterprise reporting and dashboards. Although we typically discourage exporting to Excel if it can be avoided, there are several use cases at our company where there is a need to export a visualization or a canvas to Excel while keeping the format (the way it worked in OBIEE). The lack of this feature has caused some to think about using Answers for certain use cases. It would be great to have this feature in Data Viz as well.

  • Rank 5 - Community Champion

    It adds value .

  • Rank 4 - Community Specialist

    Very welcomed!

  • Rank 6 - Analytics Lead

    Business want to compare the OAC classic output(formatted Excel) and DV view export in CSV. If this feature will be enable it will help business to validate the reports data.

  • Rank 3 - Community Apprentice

    For which version is this planned?

  • Rank 2 - Community Beginner

    Due to the local settings of the operating system it is also leading to miss-interpretation of the comma-separated file in Excel if using the csv file. So export is highly appreciated from all users.

  • Rank 3 - Community Apprentice

    Any update on what release this will be in?

Welcome!

It looks like you're new here. Sign in or register to get started.