MDX - filtering measure values

_MG_ 1 Reputation point
2020-09-03T17:37:02.723+00:00

Hi everyone,

I created a role in SSAS. I denied the dimension customer data which works fine. But what can i do if i want to denied the cell data (I mean the total measure values) for every customer except the customers with the ID 10000 and 11000?

I think I have to write an mdx Statement in the Cell Data menu. But how should it looks like?

Best regards!
MG

SQL Server Analysis Services
SQL Server Analysis Services
A Microsoft online analytical data engine used in decision support and business analytics, providing the analytical data for business reports and client applications such as Power BI, Excel, Reporting Services reports, and other data visualization tools.
1,002 questions
{count} votes