提取 MDX 计算成员价值观
有谁知道一种将多维数据集所有计算成员的公式“提取”到某种平面、可读文件中的方法？或者，与使用 Analysis Services 的多维数据集编辑器并单击每个计算成员相比，获得代码概述的更轻松的方法会有所帮助。是的，我是 MDX 新手。非常感谢！
Does anyone know of a way to "extract" the formulas for all calculated members of a cube into some kind of flat, readable file? Alternatively, a less-painful method of getting an overview of the code than using Analysis Services' Cube Editor and clicking on each Calculated Member would be helpful. Yes, I'm new to MDX. Many thanks!
如果你对这篇内容有疑问，欢迎到本站社区发帖提问 参与讨论，获取更多帮助，或者扫码二维码加入 Web 技术交流群。
绑定邮箱获取回复消息
由于您还没有绑定你的真实邮箱，如果其他用户或者作者回复了您的评论，将不能在第一时间通知您！
发布评论
评论（2）
这就是“注册用户”所指的 - 但如果我理解正确的话，它不会回答你的问题。
olappivottableextend.codeplex.com/
幸运的是，如果我正确理解你的问题，有一个非常简单的解决方案。当您对多维数据集使用 BIDS 时，在“计算成员”选项卡上，单击左侧第 12 个图标，即“脚本视图” - 我认为这就是您正在寻找的。
ssas-info.com/images/fbfiles/images/calc_tab.jpg
图片归功于 ssas-info（由于我的“声誉”，无法嵌入或发布链接 - 没有意义，但没关系）。
This is what "Registered User" was referring to - but it won't answer your question if I'm understanding it correctly.
olappivottableextend.codeplex.com/
Fortunately, if I understand your question correctly, there is a very simple solution. When you are using BIDS against your cube, on the "Calculated Members" tab, click on the 12th icon from the left which is "Script View" - I think this is what you are looking for.
ssas-info.com/images/fbfiles/images/calc_tab.jpg
Credit to ssas-info for the image (can't embed or post links because of my "reputation" - doesn't make sense, but ok).
如果您通过 Excel 数据透视表连接到 OLAP 多维数据集，则可以使用 Olap 工具 ->转换为公式功能可公开底层的多维数据集公式。我建议对尽可能小的数据执行此操作，因为 Excel 会向 OLAP 服务器发出大量发现请求。请注意，我没有任何计算的措施，所以我无法测试它是否真的做到了这一点......
If you are connecting to the OLAP cube via an Excel pivot table, then you can use the Olap Tools -> Convert to Formulas feature to expose the underlying cube formulas. I would recommend doing it for the smallest possible data because Excel will issue a large number of discovery requests to the OLAP server. Please note I don't have any calculated measures, so I couldn't test if it actually does this...