1

I'm trying to connect R or Python to an Analysis Services Cube. I usually access it through Excel Analysis Services, with the URL of the remote server and my username and password. You can see how I access it in the pictures below.

enter image description here

enter image description here

enter image description here

Thereafter I get a pivotable that allows me to make some queries. I need to do the same with R or Python, especially to import data. I tried to use olapR but I don't know how to set the server URL, username, and password. I also tried to use Python but it doesn't work for me.

Do you know if there is a tutorial or can you help me?

Note: I have "only read" permission, so I cannot change the configuration of the cube.

Chris Albert
  • 2,462
  • 8
  • 27
  • 31
alcastaro
  • 11
  • 3
  • Have you tried ODBC? If the data is not over-dimensioned, it might work for you. See https://learn.microsoft.com/en-us/analysis-services/multidimensional-models/supported-data-sources-ssas-multidimensional?view=asallproducts-allversions – r2evans Jan 04 '22 at 13:54

0 Answers0