Pivot table - REST API as data source

Question

Hi,I wan't to connect Angular PivotView control to OLAP data source (MSSQL Analysis Service) using REST API (.NET Core 3). On backend I'm using ADOMD.NET client to connect and query cube/database. I have single endpoint defined for this (POST /api/olap/testOlap) that accepts a custom object created from xml schema specification in request body.When looking at network in dev tools using https://bi.syncfusion.com/olap/msmdpump.dll as data source, I can see multiple requests being made to msmdpump.dll on component initial load (picture below).I want to replicate this initial cube metadata load using my own API endpoint in a single api call. I figure it out for any consecutive request (since there is actual query sent to server in XML request) when user adds/remove field to pivot table. But for this initial load I can't figure it out.Can anyone help me?

Sivamathi Natarajan · Answer

Hi AnR, 
 
Thank you for using Syncfusion products. 
 
Please find our response. 
 




Query 

Response 


I want to connect Angular PivotView control to OLAP data source (MSSQL Analysis Service) using REST API (.NET Core 3). On backend I'm using ADOMD.NET client to connect and query cube/database. I have single endpoint defined for this (POST /api/olap/testOlap) that accepts a custom object created from xml schema specification in request body. 

We have already logged the requirement as a feature task which will be available in any of our upcoming release. 
Please track the task using following link. 
https://www.syncfusion.com/feedback/15205 


When looking at network in dev tools using https://bi.syncfusion.com/olap/msmdpump.dll as data source, I can see multiple requests being made to msmdpump.dll on component initial load (picture below). 
I want to replicate this initial cube metadata load using my own API endpoint in a single api call. I figure it out for any consecutive request (since there is actual query sent to server in XML request) when user adds/remove field to pivot table. But for this initial load I can't figure it out. 

Yes, we call server several time on initial rendering to fetch different unique details. The count depends on features that enabled in the component. And each request is important and it couldn’t be avoided. It avoids server request on few UI operations. 
 
Regards, 
Sivamathi.

Query	Response
I want to connect Angular PivotView control to OLAP data source (MSSQL Analysis Service) using REST API (.NET Core 3). On backend I'm using ADOMD.NET client to connect and query cube/database. I have single endpoint defined for this (POST /api/olap/testOlap) that accepts a custom object created from xml schema specification in request body.	We have already logged the requirement as a feature task which will be available in any of our upcoming release. Please track the task using following link. https://www.syncfusion.com/feedback/15205
When looking at network in dev tools using https://bi.syncfusion.com/olap/msmdpump.dll as data source, I can see multiple requests being made to msmdpump.dll on component initial load (picture below). I want to replicate this initial cube metadata load using my own API endpoint in a single api call. I figure it out for any consecutive request (since there is actual query sent to server in XML request) when user adds/remove field to pivot table. But for this initial load I can't figure it out.	Yes, we call server several time on initial rendering to fetch different unique details. The count depends on features that enabled in the component. And each request is important and it couldn’t be avoided. It avoids server request on few UI operations.