Re: Needed Advice - Olap client tool

how have you setup the security?
applying security into your cube should be enough.

Excel will enforce the security, if the security is not applied its because
there is a problem in the definition of the security.
using another tool will not help you.

can you describe what you want to secure and what is your current result?

"SAM" <SAM@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:F9CA3C27-040E-49C1-AABF-FBB38B5CBA52@xxxxxxxxxxxxxxxx
Hello,

Currently, we are using Excel as our client tool for reporting; however,
I'm
running into a security issue.

For instance, we created a Sales report giving the total sales and
commission. The manager want to add security where the sales people cannot
see each sales revenue and commission. I've created dimension security
roles
but it is not enforced through excel. I've tried using protected work***
function but the sheets cannot be refreshed which defeats the purpose.

So now I am seeking advice in testing a client tool that provide security
that is needed. The other alternative is to create a cube for each sales
person.

Any suggestions?


.