SSAS 2008/Excel 2007 - 看不到立方体
我在 SSAS 2008 中创建了一个多维数据集。在 BIDS 和 SSMS 中我可以很好地看到它。但是，我无法通过 Excel 连接。我已经尝试过 Excel 2003 和 Excel 2007。我必须同时支持两者，但两者都不起作用。我可以看到数据库，但立方体没有显示。
我使用向导在项目中创建了一个虚拟多维数据集，并将其部署到同一数据库。在 Excel 2003 中，我可以看到并连接到虚拟多维数据集。添加此多维数据集后，Excel 2007 甚至找不到服务器/实例。我使用另一台计算机并在 Excel 2003 中收到相同的结果。
有人有什么建议吗？
I have created a cube in SSAS 2008. In BIDS and SSMS I can see it fine. However, I cannot connect through Excel. I have tried both Excel 2003 and Excel 2007. I must support both and neither work. I can see the database but the cubes do not show up.
I created a dummy cube in the project using the wizard and deployed that to the same database. In Excel 2003, I can see and connect to the dummy cube. Excel 2007 can't even find the server/instance after adding this cube. I have used another computer and received the same results with Excel 2003.
Does anyone have any suggestions?
如果你对这篇内容有疑问，欢迎到本站社区发帖提问 参与讨论，获取更多帮助，或者扫码二维码加入 Web 技术交流群。
绑定邮箱获取回复消息
由于您还没有绑定你的真实邮箱，如果其他用户或者作者回复了您的评论，将不能在第一时间通知您！
发布评论
评论（3）
立方体具有可见属性。如果为 false，Excel 将不会列出该多维数据集。
要查看此属性，
A) 双击 BI studio 的解决方案资源管理器中的多维数据集
B) 转到多维数据集选项卡
C) 右键单击“度量”窗格中显示的多维数据集或“维度”窗格中的多维数据集，然后选择“属性”。
The cube has a property Visible. If it's false, Excel won't list the cube.
To see this property
A) double click on the cube in BI studio's Solution Explorer
B) go to the cube tab
C) right click on either the cube which appears in the Measures pane OR the one in the Dimension pane and choose Properties.
您是否尝试重新部署出现问题的多维数据集？请记住，您还需要下载 OLE DB 9.0 和 msxml v6 for Excel 2007。Google 搜索它，第一个结果应该是 MSDN 下载页面。
Did you try re-deploying the cube that is giving your problems? Remember you need to also download the OLE DB 9.0 and msxml v6 for Excel 2007. Google search for it and the first result should be the MSDN download page.
我们的组织也有类似的问题。我创建了一个简单的角色并将“Everyone”添加为成员。我为角色授予“读取”访问权限，为本地多维数据集钻取访问权限授予“无”角色。
在我使用此角色重新部署多维数据集后，人们能够在 Excel 中进行连接。
We had a similar problem in our organization. I created a simple Role and added "Everyone" as a member. I gave the role "Read" access and "None" for Local cube Drill-through access.
After I re-deployed the cube with this role, people were able to connect in excel.