在 R 中使用 X4R 包连接到 SSAS 多维数据集? [英] Using X4R package in R to connect to a SSAS cube?

问题描述

我想弄清楚如何使用 X4R 包将多维数据集加载到 R 工作区.我的服务器名称是 "//vmtest//xmla2//msmdpump.dll""，多维数据集名称是 "Ocube_MANMartCube".

I am trying to figure out how to use X4R package to load a cube into R workspace. My server name is "//vmtest//xmla2//msmdpump.dll"" and the cube name is "Ocube_MANMartCube".

我还找不到连接到立方体的方法.我尝试了以下代码:

I couldn't find a way to connect to cube yet. I tried the following code:

library(X4R)
handle<-xmlaConnect(url="//vmtest//xmla2//msmdpump.dll"")

我得到的消息是 <?xml version="1.0" encoding="UTF-8"?><Envelope xmlns="http://schemas.xmlsoap.org/soap/envelope/" xmlns:SOAP-ENV="http://schemas.xmlsoap.org/soap/envelope/" xmlns:SOAP-ENC="http://schemas.xmlsoap.org/soap/encoding/" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema"><Header><BeginSession xmlns="urn:schemas-microsoft-com:xml-analysis" SOAP-ENV:mustUnderstand="1"></BeginSession></Header><正文><执行 xmlns="urn:schemas-microsoft-com:xml-analysis"><Command><Statement></Statement></Command><Properties><PropertyList></PropertyList></Properties></Execute></Body></Envelope>.

使用上述输出，R 变得忙碌且无响应.我确定我有用户访问权限我可以使用 Excel 连接到多维数据集.

With the above output, R becomes busy and non-responsive. I am sure I have user access & I can connect to cube using Excel.

我做对了吗?互联网上没有任何例子可供参考.可能熟悉该软件包并知道其工作原理的人可以在这里阐明一些信息.

Am I doing everything right? There isn't any examples in the internet to go with. Probably someone who is familiar with the package and knows how it works can shed some light here.

推荐答案

坚持这篇文章http://msdn.microsoft.com/en-us/library/gg492140(v=sql.105).aspx

这里是 MS AS 2014 的文章

and here is the article for MS AS 2014

http://msdn.microsoft.com/en-us/library/gg492140.aspx

当然还有一篇关于 MS AS 2012 的文章

of course there is also an article for MS AS 2012

前一段时间 X4R 不支持 Windows 身份验证，这意味着您必须为匿名访问配置 IIS(我不会这样做)，或者您必须在 R 脚本中提供用户和密码

Some time ago X4R did not support Windows-Authentication, meaning that either you have to configure IIS for anonymous access (I would not do this) or you have to provide a user and a pwd within your R script

然后连接将工作.

希望能帮到你

这篇关于在 R 中使用 X4R 包连接到 SSAS 多维数据集?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！