Tuesday, January 06, 2009 Register   Login   
   You Are Here: Discussions      
 SQL Community Portal
  
 Recently Submitted Articles
  
 Recent SQL Clinic Articles
  
 SQL Server Discussion Forums
 
  SQL Server Forums  Discussions  SQL Server DBA ...  OLAP
Previous Previous
 
Next Disabled
New Post 3/3/2008 1:15 PM
Resolved
User is offline s s
2 posts
No Ranking


OLAP 
SQL Server DBA new to OLAP on 2005 which developer is requesting. Analysis services is installed but unsure if there are additional steps that I need to complete before handing over to developer. Please advise as BOL is confusing.
 
New Post 3/6/2008 9:58 PM
User is offline Michael Hotek
5 posts
www.mssqlserver.com
No Ranking


Re: OLAP 
From an admin perspective, no. If you have SSAS installed and running, you have everything they need. There might be subsequent storage permission issues, but you have the SSAS server up and running. They should be able to do everything they need to from that point forward.
Michael Hotek MCT, MCITP - SQL DBA
 
New Post 3/12/2008 1:46 AM
User is offline s s
2 posts
No Ranking


Re: OLAP 
Michael - Thanks for the response. From an admin perspective are their security considerations for OLAP (SSAS) that I would need to put in place similar to restrictions on sa dbo etc on sql server ?

 
New Post 4/28/2008 6:24 PM
User is offline Cindy Gross
16 posts
No Ranking


Re: OLAP 
OLAP has various levels of permissions similar to SQL. Which permissions you grant at the instance and database levels depends on your environment. In addition to the security you can grant through roles and the security dialogs there is also "dynamic security" which limits permissions based on an MDX query. Dynamic security can impact your performance, you need to optimize the security MDX just like any other query.
 
 Page 1 of 1
Previous Previous
 
Next Disabled
  SQL Server Forums  Discussions  SQL Server DBA ...  OLAP
  
   Minimize

  
SQL Server 2000 Downloads
 
SQL Server 2000 Reporting Services Downloads
 
SQL Server 2000 Notification Services SP Downloads
 
SQL Server CE Downloads
 
SQLXML 3.0 Service Pack Downloads
 
SQL Server 2000 JDBC Driver
 
MDAC 2.6 Download
 
SQL Server 2000 Tools Downloads
SQL Server 2005 & SQL Server 2000 Best Practices