Click here to monitor SSC
SQLServerCentral is supported by Redgate
Log in  ::  Register  ::  Not logged in
Home       Members    Calendar    Who's On

Add to briefcase

Remote Access Analysis Server OLAP Services Expand / Collapse
Posted Tuesday, August 2, 2005 9:31 PM
SSC Journeyman

SSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC Journeyman

Group: General Forum Members
Last Login: Tuesday, May 19, 2009 9:14 AM
Points: 99, Visits: 6

Hi all,

        I think I might have asked a similar question before. But I just wish to confirm something:

(1)   If I want to use the Analysis Manager on my local PC, LOCAL_PC, to manage the OLAP cubes in a remote server, OLAP_SERVER, is this what I should do?      ->  Join both LOCAL_PC and OLAP_SERVER to the same domain, and add the Windows user account (e.g. administrator) of LOCAL_PC to the OLAP_Administrators group on OLAP_Server.

(2)    If I want to use Excel on my local PC to access the OLAP cubes in the remote server OLAP_SERVER, is that what I need to do is exactly the same as in (1)?

Many thanks,



Post #206691
Posted Wednesday, August 3, 2005 7:31 AM



Group: Moderators
Last Login: Saturday, November 5, 2016 7:09 PM
Points: 1,896, Visits: 3,753

Hey Del,

You're right with # (1).  Just make sure thta if your local machine is running XP SP2 (or any other firewall softwre) that it's not blocking the ports for communicating withthe remote server.

With #(2), you need to have been allowed access via the security roles within Analysis Services, ie you don't put every user in the AS admins group becuase then they could log onto the server and ruin everything .  It's through these roles that you can limit what the user/s can see of dimensions (e.g in a world wide sales cube, I can limit my aussie users to only australian sales data by limiting the members they can see within the Sales_Person dimension).  You as the administrator need to set up the roles.  A simple way to get everyone up and going is to put the 'everyone' windows group into a role.  The downside of this is basically you're then saying *anyone* on the domain can view *all* of the data within this cube.

Further to puttingon the roles, each client machine will need PTS (pivot table services).  This can be found on each and every Service Pack CD for SQL/Analysis Services.  Note that if you put SP2 PTS on a client and your server is actually SP3 or maybe SP4 - you *will* have problems.  *Make sure* your P of PTS on every client matches that of the server.  I know it sounds obvious, but also ensure that if you're not personally installing the SP's, ensure that whoever is knows that there is a SQL SP and an AS SP - two very different service packs, usually on the same CD, but two downloads if downloading via MSDN.


Post #206856
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse