Get Free Trial

Pivot Update Data – Error

Suresh asked on March 28, 2018

We are trying to call ‘updateData’ to update rawdata to add some custom rows. I am getting an error saying “CSV,OCSV and JSON data not supported in current version”. we are using “SaaS license”. Its very critical for our client requirements.

3 answers

Tanya Gryshko Tanya Gryshko Flexmonster March 29, 2018

Hello, Suresh,
Thank you for posting a question on our Support Forum.
Updating raw data to add some custom rows to the current data is available for JSON data sources only.
If you are using MSAS cube, updateData allows updating data for the report, i.e. connecting to a new data source. Your code for updateData should look the following way:

// replace with your parameters
dataSourceType: 'microsoft analysis services',
proxyUrl: '',
dataSourceInfo: 'Provider=MSOLAP; Data Source=extranet;',
catalog: 'Adventure Works DW Standard Edition',
cube: 'Adventure Works'

Please let me know if you need further explanations.

Suresh March 29, 2018

Hello Tanya,
Is there any way that I can add new custom rows on client side once we get the data from the MSAS cube?

Iryna Kulchytska Iryna Kulchytska Flexmonster March 29, 2018

The component works as a visualizer of data from the MSAS cube. It completely relies on the MSAS response and new custom rows could not be added on the client side to the response from MSAS.
Kind regards,

Please login or Register to Submit Answer