Oracle Analytics Cloud and Server

Home› Oracle Analytics› Oracle Analytics Forums› Oracle Analytics Cloud and Server› Oracle Analytics Cloud and Server

Categories

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

Dashboard download using CSV overrides suppression attribute

Received Response
1
Views
1
Comments
3713479
3713479 Rank 4 - Community Specialist
edited Aug 13, 2024 5:17PM in Oracle Analytics Cloud and Server

My version of OBIEE is not current( 11.1.1.7).

I noticed that downloading in Excel format  from the Dashboard retains the suppression attribute for a column so that it is not repeated which is working as designed.

The same download in CSV format does not suppress the column value and repeats the value which I do not want.

The download in Excel format is very slow compared to the CSV download.

Is the download format for each column governed by a configuration setting ?

Thanks for any suggestions.

Jim

Answers

  • [Deleted User]
    [Deleted User] Rank 2 - Community Beginner

    Download to Excel by definition is formatted. Download to CSV is raw data.

    CSV is not capable of handling value suppression. It's simply not in the nature of that file format and wouldn't make sense in a CSV from a conceptual point of view.