SSAS立方体更新问题
我创建了一个 SSAS 项目，它在我的多维数据集、数据源以及我第一次部署多维数据集时运行得很好，但是如果我更改数据库中的数据并在 BIDS 中单击 Cube>Process，它将不会反映新的更改即使当我在 SQL Server Management Studio 中检索表数据时，该表显示我的数据已更改。
我还尝试使用 Analysis Services 处理任务更新 SSIS 包中的多维数据集。但是，我的基础数据的变化没有显示。它保持不变。谁能告诉我一些可能导致此问题的情况。 非常感谢
提前致谢
I have created a SSAS project and it works perfectly fine my cubes, data-sources and such first time I deploy the cube, but if I change the data in my database and I click Cube>Process in BIDS it will not reflect the new changes even though when I retrieve the table data in SQL server Management Studio the table shows my data is changed.
I have also tried updating the cube in SSIS package using the Analysis Services Processing Task. However, the changes in my underlying data is not shown. It stays the same. Can anybody give me the few possible scenarios that can cause this problem.
Much appreciated
Thanks in Advance
如果你对这篇内容有疑问，欢迎到本站社区发帖提问 参与讨论，获取更多帮助，或者扫码二维码加入 Web 技术交流群。
绑定邮箱获取回复消息
由于您还没有绑定你的真实邮箱，如果其他用户或者作者回复了您的评论，将不能在第一时间通知您！
发布评论
评论（4）
第一步是验证服务器上的数据源（不是您的开发计算机上的本地数据源）是否设置为正确的数据库。
First step is to verify that the datasource ON THE SERVER (not locally on your dev machine) is set to the correct database.
您正在处理整个项目还是仅处理立方体？我注意到我必须处理解决方案资源管理器中的顶级项目。仅处理立方体是不够的。
您收到任何错误消息吗？
尝试先处理维度，然后处理立方体。
我自己不是专家，但我知道更新（“过程”）和“部署”之间存在区别。
因此，当您创建或添加维度时，您首先必须将多维数据集部署到分析服务器，然后对其进行处理。
稍后，当数据源中有新数据时，您只需处理多维数据集（它已部署）即可更新数据。
Are you processing the whole project or just the cube? I noticed that I have to process the top level item in the solution explorer. Processing just the cube was not enough.
Do you get any error messages?
Try processing the dimensions first and then process the cube.
I am not an expert myself, but I understood that there is a difference between updating ("process") and "deploy".
So when you create or add dimensions you will first have to deploy the cube to the analysis server and then process it.
Later when there is new data in your datasource, you can just process the cube (it's already deployed) to update the data.
试试这个：
Try this:
对多维数据集结构进行的任何更改，即添加新的度量或业务情报。仅在处理立方体后就会反映，无需再次部署整个项目。但是，如果底层数据或数据结构发生任何更改，则需要部署整个项目。
在 Cube>Browser 中处理/部署后可以立即看到更改，但由于缓存的原因，在 SSRS 中需要一些时间才能实现。
Any changes made to the cube structure i.e. adding new measure(s) or business intel. will reflect merely after processing the cube, there is no need to deploy the whole project again. However if any changes are made in underlying data or data structure, then the whole project needs to be deployed.
Changes can be seen right after processing/deployment in Cube>Browser but will take some time to be realized in SSRS because of caching.