Is it possible to query a SQL Server Analysis Services cube using R? I have this cube on a different external Server and i am working from my machine but i have admin privileges on the Server with my domain account. To put it simply, i want to create an alaysis services solution, suing some mining algorithm to examine data cotained in the Cube. I can do that with Excel, for instance, but i need to use R to take advantage of several interesting clustering algorithms different from those MS offers. Is that possible? Which package should i import in R?
Grant the SQL Server Agent account administrator permission on SSAS. Using Management Studio, connect to the remote SQL Server Analysis Services instance. Right-click the server name, click Properties, and then click Security. Click Add to add the SQL Server Agent account.
To analyze cube data Open Microsoft SQL Server Management Studio. On the Connect to Server page, select Analysis Services for Server type. Enter the name of the server that contains the Analysis Services database for the General Ledger cube, enter credentials used to access the server, and then click Connect.
maybe something is coming from here
https://www.linkedin.com/groups/Importing-MDX-OLAP-cube-data-77616%2ES%2E265568694?view=&gid=77616&item=265568694&type=member&commentID=discussion%3A265568694%3Agroup%3A77616&trk=hb_ntf_COMMENTED_ON_GROUP_DISCUSSION_YOU_COMMENTED_ON&_mSplash=1
at the moment it's not available from CRAN, but maybe you will give it a try.
In the meantime you can also use an ODBC / OLEDB bridge and use the RODBC from inside R.
Hope this helps a little
Tom
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With