Cognos Analytics

The data tray is meant more for developers to debug their dashboards than an end user tool, which is why it's showing the unformatted data. When you open the tray Cognos calls an internal API (DataBehindTheViz) and just populates the grid with what it gets


Going through the _renderReactGrid function, it doesn't look like it's calling any formatting function at all before it renders the data. My guess is this is intentional. What is your end goal here? If you want to let users export their data, there are other ways of doing it than having them open edit mode. 

Hi Pierre-Frank,

The same issue occurs with the new feature in v12.1.1 called Allow users to access data.

You need to enable this feature from the dashboard Properties.

Then when you click on a widget, you will see a new Export to CSV icon.

When you export the CSV file, the same issue occurs:

I've logged a ticket with IBM support on this issue: TS020705783 and https://ibm-data-and-ai.ideas.ibm.com/ideas/CA-I-4703

You can vote to have a feature added here: Local separator is not | IBM Data Platform Ideas Portal for Customers

(Updated to add case number and idea)

Best regards,

@Patrick Neveu that's a real bummer. This way, the new feature is completely useless. Let's hope IBM will understand there is a world outside the north american continent.