Oracle Analytics Forum

Home› Oracle Analytics and AI› Oracle Analytics and AI Forums› Oracle Analytics Forums› Oracle Analytics Forum

Categories

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

Dashboard Report export generating data in incorrect column order

Received Response
91
Views
2
Comments
Mandar -Oracle
Mandar -Oracle Rank 2 - Community Beginner
in Oracle Analytics Forum

Summary:

Report export generating data in incorrect column order 

Content (required):

Hi,

Customer is trying to export the dashboard table report in csv file, but after export, column is not having the same order as we see in report. Please suggest how to get correct export column order as we see in the report.

Version (include the version you are using, if applicable):

OAS 5.9

Code Snippet (add any code snippets that support your topic, if applicable):


Tagged:

Answers

  • Amrita Gupta-Oracle
    Amrita Gupta-Oracle Rank 6 - Analytics & AI Lead

    Hi Mandar,

    Check the order of the columns in the Criteria. The export gets generated in the order of the columns present in the criteria. If you have a specific order in which the columns need to be in the export, set the order in the Criteria itself.

  • Gianni Ceresa
    Gianni Ceresa Mod

    What Amrita said.

    There are 2 kinds of exports: one that goes directly on the criteria and does export your criteria (all the columns you have there) and one that is based on the visual rendering of the view as you see it on your screen (and therefore can have less columns because some are excluded etc.).

    CSV is an export based on the criteria definition, it's the expected behavior and does work like that for (many) years.