是否可以抑制 OBIEE 中度量列的值？
众所周知，有一个选项可以通过在“列属性”窗口中进行设置来抑制或重复数据。
但是，我们注意到它仅适用于维度列，但是当我们对两个或三个事实表和具有适当级别的公共维度进行分析时，维度值会被抑制，但即使值相同，度量列值也会重复并且“抑制”选项已启用。
有什么办法可以压制他们吗？ 我知道，如果一个事实表中有 1 条记录，另一个事实表中有 2 条记录，第三个表中有 3 条记录，当您使用内连接和外连接将它们连接起来时，您将始终有重复的列，但是在 BI 中我们可以使其更加用户友好吗通过压制同等价值？
在上图中，直到红色方块开始的所有列都是维度列，并且它们被抑制，但方块内的列是度量列，即使启用了抑制选项，它们也会对每行重复。
It is known that there is an option to suppress or repeat data by setting in Column Properties window.
However, we noticed that it works only for dimension columns, but when we have an analysis from two or three fact tables and common dimensions with appropriate levels, dimension values are being suppressed, but measure column values are being repeated even though values are the same and 'suppress' option is enabled.
Is there any way to suppress them too?
I understand that if you have 1 record in one fact table, 2 in another and 3 in the third table and when you join them with inner and outer joins, you will always have columns repeated, but in BI can we make it more user friendly by suppressing equal values?
In the image above, all columns till red square starts are dimension columns and they are suppressed, but columns inside square are measure columns and even though suppress option is enabled they are repeated for each row.
如果你对这篇内容有疑问，欢迎到本站社区发帖提问 参与讨论，获取更多帮助，或者扫码二维码加入 Web 技术交流群。
绑定邮箱获取回复消息
由于您还没有绑定你的真实邮箱，如果其他用户或者作者回复了您的评论，将不能在第一时间通知您！
发布评论
评论（1）
不，不存在，因为它没有意义。度量根据查询和结果集的粒度进行聚合。
No there isn't because it doesn't make sense. Measures aggregate depending on the grain of the query and the result set.