Question about OLAP demo sample source code for Pivot Table

Question

Upon trying the OLAP demo sample source code for Pivot Table component using React.js (https://ej2.syncfusion.com/react/demos/#/material/pivot-table/olap), I cannot seem to access the .dll file link (https://bi.syncfusion.com/olap/msmdpump.dll) from the URL of dataSourceSettings. When I tried to open the link via my browser, a Server Error 404 displays with a message. When I try to access the parent directory (https://bi.syncfusion.com/olap/), There seems to be a file with the name "msmdpump.dll" but is still inaccessible on my end displaying a Server Error 500 with a message.Is there a way to access the content of the URL so that I could re-create it on my end? I need to know the content of the file for our team's project presentation.

Attachment: Downloads_5c0acd9e.zip

Saranya Sivan · Accepted Answer

Hi JB Ochinang, 
  
Thanks for contacting Syncfusion Support.    
  
Kindly check the below blogs to check the permission to access the cube from client application, 
  
https://docs.microsoft.com/en-us/sql/analysis-services/multidimensional-models/grant-cube-or-model-permissions-analysis-services 
  
https://docs.microsoft.com/en-us/sql/analysis-services/instances/connect-from-client-applications-analysis-services   
  &shy; 
To check the connection in Excel, please follow the below steps,   
  
  
   
  
Provide the connection details,   
  
  
   
  
Select the cube from appropriate database,   
  
  
   
  
Note: If you found any issue while connecting cube in excel. Run the excel application as administrator. 
  
Please let us know if you need further assistance on this.  
  
Regards, 
Saranya Sivan.

JB Ochinang · Answer

Thank you for your response. Is there a way to achieve the foldering structure using json?, like this:

Saranya Sivan · Answer

Hi JB Ochinang, 
  
We regret you to let you know that the mentioned treeview structure (child view) is only applicable for OLAP data source. 
  
Please let us know if you have concern. 
  
Regards, 
Saranya Sivan.