SSAS/SSRS 从多维数据集报告中删除参数会破坏报告
团体， 我们使用 SSAS 构建了一个数据立方体，现在正在根据该立方体构建 SSRS 报告。 不确定是否有人遇到过这种情况，但是当您使用向导构建报告并包含参数时，一切看起来都很好。 但是，如果您在向导完成后处于报告中，并且决定要删除您创建的参数之一，则会揭穿报告的真相，将其恢复的唯一方法是重新创建整个报告。
有什么方法可以在初始构建后删除或添加参数而不破坏报告吗？
先谢谢您的帮助！ 我喜欢这个论坛！
Group,
We built a data cube using SSAS and are now building SSRS reports off of that cube. Not sure if anyone has come across this, but when you build the report using the wizard and include parameters all looks fine. However if you are in the report after the wizard is compete, and you decide you want to remove one of the parameters you created it debunks the report and the only way to get it back is to re-create the whole report.
Any way you can remove or add parameters after the initial build without destroying your report?
Thanks in advance for the help! I love this forumn!
如果你对这篇内容有疑问，欢迎到本站社区发帖提问 参与讨论，获取更多帮助，或者扫码二维码加入 Web 技术交流群。
绑定邮箱获取回复消息
由于您还没有绑定你的真实邮箱，如果其他用户或者作者回复了您的评论，将不能在第一时间通知您！
发布评论
评论（2）
我遇到了同样的问题，这就是我解决它的方法：
I had the same problem and this is how I solved it:
如果您查看为每个参数创建的隐藏数据集，就会发现每个参数都有一个查询，该查询以级联方式依赖于其他一些参数。 除非删除最后一个参数，否则其他参数将不起作用。
您可以通过手动编辑参数数据集查询来修复此问题，可以更新它们以不使用要删除的参数。
主查询还使用嵌套 FROM (... (... (... 方式。您需要更新它，以便它不会将自身限制为该参数。然后顶部有一个参数按钮查询生成器允许您删除查询中对该参数的引用，
我认为如果您从向导中删除参数，它应该更新所有其他参数和查询以正常工作。您的所有报表对象都应保持功能。
If you look at the hidden datasets created for each parameter, each one has a query which depends on some of the other parameters, in a cascading fashion. Unless you delete the very last parameter, the other parameters won't work.
You can fix this by manually editing the parameter dataset queries can updating them not to use the parameter you want to delete.
The main query also uses the parameters in a nested FROM (... (... (... fashion. You need to update that so that it doesn't constrain itself to that parameter. Then there is a parameters button on top of the query builder which allows you to remove the reference to that parameter in the query.
I think if you remove the parameters from the wizard, it should update all the other parameters and the query to work correctly. This is probably the easiest route. All of your report objects should remain functional.