Re: Needed Advice - Olap client tool

Jeje is right, a description of what you want to secure and what you
currently seeing would help.

There are two common issues that might relate to you. One is not setting
the visual totals option.

see: http://msdn2.microsoft.com/en-us/library/ms175366.aspx

The result of this is that the users can only see their own results at
the leaf level, but they can see the sum of all the results at higher
levels. This means that users could potentially figure out other members
data.

The other issue that can circumvent dimensional security is putting
ordinary users in the Olap Administrators group. Olap Administrators
always see all the data.

--
Regards
Darren Gosbell - SQL Server MVP
Blog: http://www.geekswithblogs.net/darrengosbell

In article <#Tf5VyOvGHA.4436@xxxxxxxxxxxxxxxxxxxx>, willgart@xxxxxxxxxxx
says...
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?



.