Hi There

We currently have an issue with getting users to see the cube from within an OWC.

Some users (mostly Administrator or part of an Administrators group) can see the cube fine.

I have changed the security settings in the Role within AS to include everyone and to allow full control (this is not permanent but to allow us to diagnose the problem).

So as far as AS is concerned there is no distinction between people in different NT groups, however clearly there is something preventing users not in an Admin group from seeing an accessing the cube.

Are there any other security considerations (besides the roles within AS) that control how access to the cube is maintained?

Any help greatly appreciated.

Many thanks

Brian

Brian,

I agree with cutley, If you choose the read option for the AS database role you must specify the read option source view and then for cubes.

After that it will run corectly.

If you have installed a SQL Service Pack on the server you need to install the same SP on the client machine. That updates the client connectivity pieces. This seems to be a machine issue instead of a user permission issue so I'm guessing this is the issue.