SSAS->如何隐藏层次结构中使用的属性? (不使用透视)
我有一些用于构建层次结构的属性......(见图).....由于我在关键列中所做的更改而将这些属性包含在层次结构中之后,它们不再是用于最终用户。如果这没有意义,您可能不知道这个问题的答案。 (基本上它通过包含的关键列来拼接数据)
I have some attributes that I am using to build hierarchies....(go figure).....after these attributes have been included in the hierarchy due to the change that I have made in their key columns they are no longer of use to an end user. If that doesn't make sense you probably don't know the answer to this question. (basically it splices the data by key columns included)
如果你对这篇内容有疑问,欢迎到本站社区发帖提问 参与讨论,获取更多帮助,或者扫码二维码加入 Web 技术交流群。
绑定邮箱获取回复消息
由于您还没有绑定你的真实邮箱,如果其他用户或者作者回复了您的评论,将不能在第一时间通知您!
发布评论
评论(2)
转到维度选项卡,右键单击您的属性。将属性hierarchyvisible 设置为 false。这将阻止您的属性对最终用户可见,并且在立方体浏览器中也不会看到。
Go to dimension tab, right click on your attribute. Set the attributehierarchyvisible to false. This will stop your attribute from being visible to your enduser and it will not be seen in the cubebrowser either.
转到属性属性,将 AttributeHierarchyVisible 设置为 false。这将隐藏该属性,但您仍然可以在定义层次结构时使用它。但无论如何,如果您想删除某个属性,或者想停止在层次结构和 MDX 查询中使用某个属性,那么请将 AttributeHierarchyEnablr 设置为 False。
go to the attribute properties and there make AttributeHierarchyVisible to false. this will hide the attribute but you can still use it in defining hierarchy. but by any chance if you want get rid of an attribute, if you want to stop using an attribute in hierarrchy and in MDX query,then make AttributeHierarchyEnablr to False.