使用 R 连接到 SSAS 多维数据集 [英] Connecting to a SSAS cube using R
问题描述
是否可以使用 R 查询 SQL Server Analysis Services 多维数据集?我在不同的外部服务器上有这个多维数据集,我在我的机器上工作,但我有我的域帐户在服务器上的管理员权限.简单地说,我想创建一个 alaysis 服务解决方案,使用一些挖掘算法来检查 Cube 中包含的数据.例如,我可以用 Excel 做到这一点,但我需要使用 R 来利用几个不同于 MS 提供的有趣的聚类算法.那可能吗?我应该在 R 中导入哪个包?
也许有什么东西来自这里
目前 CRAN 不提供它,但也许您会尝试一下.
与此同时,您还可以使用 ODBC/OLEDB 桥接器并从 R 内部使用 RODBC.
希望对你有所帮助
汤姆
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?
maybe something is coming from here
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
这篇关于使用 R 连接到 SSAS 多维数据集的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!