Pivot Update Data - Error

posted on March 28th, 2018

Answered

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.

Thanks,
Suresh.

Attachments:
Flexmonster_Updat_Data_Issue.png

3 answers

Public

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:

flexmonster.updateData({
 // replace with your parameters
 dataSourceType: 'microsoft analysis services',
 proxyUrl: 'http://olap.flexmonster.com/olap/msmdpump.dll',
 dataSourceInfo: 'Provider=MSOLAP; Data Source=extranet;', 
 catalog: 'Adventure Works DW Standard Edition', 
 cube: 'Adventure Works'
});

Please let me know if you need further explanations.
Regards,
Tanya

Public

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?

Thanks,
Suresh.

Public

Iryna Kulchytska ⋅ Flexmonster ⋅ March 29, 2018

Suresh,

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,
Iryna

Pivot Update Data - Error

3 answers

Please login or Register to Submit Answer