Question related to Analysis Service Roles

Hi,

One of my users is supposed to have full access to all other dimesions except for one and thus I have defined a customized role on one of 4 dimensions that I have.

When I test the role (from the front-end), I am getting a strange message in my front-end :confused: and could it be that I also have to define a role for this user on all other dimensions? Should I define the role on the server or the client :confused: I am a bit confused and will appreciate your help.

Thanks.Are you testing the role from your machine or from the users machine? What happens when they log on to your machine? Can you post the error message that you are getting?|||Are you testing the role from your machine or from the users machine? What happens when they log on to your machine? Can you post the error message that you are getting?
Hi and thanks for the reply.

At the moment I am testing this from my own machine by logging in (from my machine) as the test user and then trying to use the cube. Could this be the reason? The front-end that I'm using is MSDA (Microsoft Data Analyzer) and the error message that I get is as follows:

Formula error - cannot bind: unknown member: "[Product].[_MAXIMAL_MIN_]"

Any clues please.sql

Question on DEveloper EDition Client Tools Only

Hi:
Our developer's are supposed to use SQL Server Developer Edition Client
Tools Only.
Can anybody tell me if any of the components below could be considered
as that tool?
Many thanks in advance.
Analysis Services Shared Tools
=B7 Business Intelligence Development Studio
=B7 Connectivity Components
=B7 Legacy Components
=B7 Management Tools
=B7 Notification Services Client Components
=B7 Reporting Services Report Manager
=B7 Reporting Services Shared Tools
=B7 SQL Server 2005 Shared Tools
=B7 Software Development Kit
=B7 SQLXML Client Features
=B7 SQL Server 2005 Books Online
=B7 SQL Server Mobile Server ToolsDataPro wrote:
> Hi:
> Our developer's are supposed to use SQL Server Developer Edition Client
> Tools Only.
> Can anybody tell me if any of the components below could be considered
> as that tool?
> Many thanks in advance.
> Analysis Services Shared Tools
> Business Intelligence Development Studio
> Connectivity Components
> Legacy Components
> Management Tools
> Notification Services Client Components
> Reporting Services Report Manager
> Reporting Services Shared Tools
> SQL Server 2005 Shared Tools
> Software Development Kit
> SQLXML Client Features
> SQL Server 2005 Books Online
> SQL Server Mobile Server Tools
>
Those are basic SQL Server components. You're asking the wrong
question, it's not the components that you need to worry about, it's
where they were installed from. Were they installed from SQL Server
Developer Edition media, or one of the other editions?
Tracy McKibben
MCDBA
http://www.realsqlguy.com|||Our software aquisition folks tell me that they were in the contract as
sub components of SQL Server 2005 Standard and Enterprise Editions.
Does that make sense?
I was told that if one attempted to install SQL Server on a server that
could work. However attempting to install it on a workstation would
only allow the installation of Query Analyzer. So I'm not sure if any
other client tools could be installed that way.
Thanks for the help.
Tracy McKibben wrote:
> DataPro wrote:
> Those are basic SQL Server components. You're asking the wrong
> question, it's not the components that you need to worry about, it's
> where they were installed from. Were they installed from SQL Server
> Developer Edition media, or one of the other editions?
>=20
>=20
> --=20
> Tracy McKibben
> MCDBA
> http://www.realsqlguy.com

Question on DEveloper EDition Client Tools Only

Hi:
Our developer's are supposed to use SQL Server Developer Edition Client
Tools Only.
Can anybody tell me if any of the components below could be considered
as that tool?
Many thanks in advance.
Analysis Services Shared Tools
=B7 Business Intelligence Development Studio
=B7 Connectivity Components
=B7 Legacy Components
=B7 Management Tools
=B7 Notification Services Client Components
=B7 Reporting Services Report Manager
=B7 Reporting Services Shared Tools
=B7 SQL Server 2005 Shared Tools
=B7 Software Development Kit
=B7 SQLXML Client Features
=B7 SQL Server 2005 Books Online
=B7 SQL Server Mobile Server ToolsDataPro wrote:
> Hi:
> Our developer's are supposed to use SQL Server Developer Edition Client
> Tools Only.
> Can anybody tell me if any of the components below could be considered
> as that tool?
> Many thanks in advance.
> Analysis Services Shared Tools
> · Business Intelligence Development Studio
> · Connectivity Components
> · Legacy Components
> · Management Tools
> · Notification Services Client Components
> · Reporting Services Report Manager
> · Reporting Services Shared Tools
> · SQL Server 2005 Shared Tools
> · Software Development Kit
> · SQLXML Client Features
> · SQL Server 2005 Books Online
> · SQL Server Mobile Server Tools
>
Those are basic SQL Server components. You're asking the wrong
question, it's not the components that you need to worry about, it's
where they were installed from. Were they installed from SQL Server
Developer Edition media, or one of the other editions?
Tracy McKibben
MCDBA
http://www.realsqlguy.com|||Our software aquisition folks tell me that they were in the contract as
sub components of SQL Server 2005 Standard and Enterprise Editions.
Does that make sense?
I was told that if one attempted to install SQL Server on a server that
could work. However attempting to install it on a workstation would
only allow the installation of Query Analyzer. So I'm not sure if any
other client tools could be installed that way.
Thanks for the help.
Tracy McKibben wrote:
> DataPro wrote:
> > Hi:
> >
> > Our developer's are supposed to use SQL Server Developer Edition Client
> > Tools Only.
> >
> > Can anybody tell me if any of the components below could be considered
> > as that tool?
> >
> > Many thanks in advance.
> >
> > Analysis Services Shared Tools
> >
> > =B7 Business Intelligence Development Studio
> >
> > =B7 Connectivity Components
> >
> > =B7 Legacy Components
> >
> > =B7 Management Tools
> >
> > =B7 Notification Services Client Components
> >
> > =B7 Reporting Services Report Manager
> >
> > =B7 Reporting Services Shared Tools
> >
> > =B7 SQL Server 2005 Shared Tools
> >
> > =B7 Software Development Kit
> >
> > =B7 SQLXML Client Features
> >
> > =B7 SQL Server 2005 Books Online
> >
> > =B7 SQL Server Mobile Server Tools
> >
> Those are basic SQL Server components. You're asking the wrong
> question, it's not the components that you need to worry about, it's
> where they were installed from. Were they installed from SQL Server
> Developer Edition media, or one of the other editions?
> > > -- > Tracy McKibben
> MCDBA
> http://www.realsqlguy.com