SSAS CUBE表和列不工作 [英] SSAS CUBE TABLE AND COLUMN NOT WORKING
问题描述
HI ALL，
我在SSAS表格模型中创建了一个多维数据集，用DAX表达式过滤了该行。在表和列上，它声明"选择用户不应该看到的表和列"。我在一列上添加了一个复选标记l我不希望特定用户看到
，如下图所示
- 销售额
- 可结算金额
- 总数量
- 实际成本
用户不会看到粗体 当他打开报告时
我部署了多维数据集并创建了Power BI报告并与用户共享应用程序，但用户仍然看到报告中的两个检查。
有没有人能解决这个问题？
< blockquote>
我部署了多维数据集并创建了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 below
- Sales Amount
- Billable Amount
- Total Quantity
- Actual cost
The user will not see the bold when he opens the report
I 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?
I 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表和列不工作的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！
