SQL Clone
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 


Remote Access Analysis Server OLAP Services


Remote Access Analysis Server OLAP Services

Author
Message
Del Piero
Del Piero
SSC Eights!
SSC Eights! (945 reputation)SSC Eights! (945 reputation)SSC Eights! (945 reputation)SSC Eights! (945 reputation)SSC Eights! (945 reputation)SSC Eights! (945 reputation)SSC Eights! (945 reputation)SSC Eights! (945 reputation)

Group: General Forum Members
Points: 945 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,

delpiero


stevefromOZ
stevefromOZ
SSCoach
SSCoach (17K reputation)SSCoach (17K reputation)SSCoach (17K reputation)SSCoach (17K reputation)SSCoach (17K reputation)SSCoach (17K reputation)SSCoach (17K reputation)SSCoach (17K reputation)

Group: Moderators
Points: 17560 Visits: 3757

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.

Cheers,



Steve.
Go


Permissions

You can't post new topics.
You can't post topic replies.
You can't post new polls.
You can't post replies to polls.
You can't edit your own topics.
You can't delete your own topics.
You can't edit other topics.
You can't delete other topics.
You can't edit your own posts.
You can't edit other posts.
You can't delete your own posts.
You can't delete other posts.
You can't post events.
You can't edit your own events.
You can't edit other events.
You can't delete your own events.
You can't delete other events.
You can't send private messages.
You can't send emails.
You can read topics.
You can't vote in polls.
You can't upload attachments.
You can download attachments.
You can't post HTML code.
You can't edit HTML code.
You can't post IFCode.
You can't post JavaScript.
You can post emoticons.
You can't post or upload images.

Select a forum







































































































































































SQLServerCentral


Search