My Oracle Support Banner

Incorrect Values In The Exported CSV File Of The BAM Dashboards Based On Predefined SQL (Doc ID 2695715.1)

Last updated on JULY 29, 2020

Applies to:

Oracle BAM (Business Activity Monitoring) - Version 12.2.1.3.0 and later
Information in this document applies to any platform.

Symptoms

On : 12.2.1.3.0 version, BAM Dashboard

ACTUAL BEHAVIOR
---------------
After setting EnableFullDownload=true, export and save the full download .csv file then reopen.

It has been observed that some fields containing a comma will shift to the next column


STEPS
-----------------------

1) Using the System MBean Browser in EM set the MBean attribute EnableFullDownload to true and apply


2) Restart the BAM server


3) In BAM Designer, create a new project or use an existing one


4) Use an existing data object or create a new one as follows:


a) Create a simple data object called GourmetFood with the following columns:
Brand DIMENSION VARCHAR
Category DIMENSION VARCHAR
Sales MEASURE DECIMAL


b) Populate it as follows:
Brand Category Sales
Pasta Gourmet Pasta 42,566.31
Montego Bay Pasta 40,098.78
Specialty Farms,Vermont Cheese 61,992.27
Pasta Gourmet Pasta 37,132.83
Vermont Specialty Farms Cheese 37,524.87
Montego Bay Pasta 57,463.02
Wisconsin Cheese Works Cheese 41,834.61
Wisconsin Cheese Works Cheese 27,406.89


c) Add the data object to your project.
If using an existing data object, add a row with a value that contains a comma in a String field


5) Create a Flat SQL Query to read all fields from the data object created in step 4


6) Create a List view using the query created in step 5


7) Create a Dashboard using the view created in step 6


8) Open the Dashboard created in step 7 and click on the Download icon in the upper right corner of the List view. Save the file.


9) Open the saved file in Excel and verify that the row with the field that contains a comma has the right number of fields in Excel

Cause

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Symptoms
Cause
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.