SSAS CUBE表和列不工作

本文介绍了SSAS CUBE表和列不工作的处理方法，对大家解决问题具有一定的参考价值，需要的朋友们下面随着小编来一起学习吧！ 问题描述 29岁程序员，3月因学历无情被辞！ HI ALL， 我在SSAS表格模型中创建了一个多维数据集，用DAX表达式过滤了该行。在表和列上，它声明"选择用户不应该看到的表和列"。我在一列上添加了一个复选标记l我不希望特定用户看到，如下图所示 销售额 可结算金额 总数量 实际成本 用户不会看到粗体 当他打开报告时 我部署了多维数据集并创建了Power BI报告并与用户共享应用程序，但用户仍然看到报告中的两个检查。 有没有人能解决这个问题？ 解决方案 这可能是因为用户要么是多个角色或它们是服务器管理员。 要检查这一点，您可以针对服务器启动探查器跟踪，以侦听现有会话和会话初始化事件。如果您启动跟踪，然后让该用户连接并找到该用户会话的事件，您将看到已应用于该用户的角色列表。 如果在角色列表中看到星号（*）。这意味着用户位于服务器管理员组中。安全角色不适用于服务器管理员，因此如果这是您的问题，则需要从他们中删除此级别的访问权限。 如果他们处于多个角色，您可能要制作确保它们只在一个角色中，或者所有角色都具有相同的受限列设置。 HI ALL,I created a cube in SSAS tabular model, filtered the row with DAX expression. On tables and columns, it stated that "Select tables and columns that should not be visible to users. I put a check mark to just to columns l don't want a particular user to see as shown belowSales AmountBillable AmountTotal QuantityActual costThe user will not see the bold  when he opens the reportI deployed the cube and created Power BI report and share the app with the user, but the user still sees the two check in the report.Does anyone have a solution to this issue? 解决方案 This could be because the user is either in multiple roles or they are a Server Admin.To check this you can start a profiler trace against your server listening for the Existing Session and Session Initialize events. If you start the trace, then get this user to connect and find the event for this user's session you will see a list of the roles which have been applied to the user.if you see an asterix (*) in the roles list. This means the user is in the server admin group. Security roles are not applied to server admins so you'd need to remove this level of access from them if this is your issue.If they are in multiple roles you would either want to make sure that they are only in one role or that all roles have the same restricted column settings. 这篇关于SSAS CUBE表和列不工作的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持！ 上岸，阿里云！