Pivot Update Data – Error
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.
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',
dataSourceInfo: 'Provider=MSOLAP; Data Source=extranet;',
catalog: 'Adventure Works DW Standard Edition',
cube: 'Adventure Works'
Please let me know if you need further explanations.
Is there any way that I can add new custom rows on client side once we get the data from the MSAS cube?
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.