I trying to understand a what stage in processing a MDX
statement is security applied.
I have geography dimension with 3 countrys which total up
to an All Countries member. Another dimension is products.
I have a MDX query which ranks the best selling products.
No problem with users whose roles are not restricted.
However, if I have a user with a role which restricts them
to view one country's details (using custom dimension
security), when they use the MDX query, selecting the All
Countries member, products not sold in the country are
displayed, but with no values. I would use the NON EMPTY
clause, but the MDX adds the Ranking number, so is always
present.
I suspect that the dimension security is processed after
the MDX processing and before the output, or have I missed
something.
Thanks
Jon

"Jon C" <mrslippy (AT) hotmail (DOT) com> wrote

Security is applied before creation of calculated members/named sets and
before any session statement is executed.

--
==================================================
Mosha Pasumansky - www.mosha.com/msolap
Development Lead in the Analysis Server team
All you need is love (John Lennon)
Disclaimer : This posting is provided "AS IS" with no warranties, and
confers no rights.
==================================================

Thank you for your reply.
However, it doesn't explain the results that I am getting.

Do you have any further thoughts?

Jon

I beleive that your results can be explained: Since dimension security cuts
out two other countries, product which were only sold in them will show up
as empty. If you wanted to preserve the same ranking as for non-secured
users, you can disable visual totals. However, in this case, secured user
will see real totals for All Countries.

--
==================================================
Mosha Pasumansky - www.mosha.com/msolap
Development Lead in the Analysis Server team
All you need is love (John Lennon)
Disclaimer : This posting is provided "AS IS" with no warranties, and
confers no rights.
==================================================