Browse by Tags

Pivot table connectivity to SQL Server Analysis Services - security gotchas
14 March 08 06:10 AM | ssqa.net | with no comments

Security permissions in OLAP is similar to normal OLTP based environment. Say if you are using Pivot Table object in MS Office Excel to display the reports using OLAP objects like Cubes. To achieve this it should connect to an OLAP Server and database...

Filed under: sql server, permissions, security, analysis services, ssas, pivot, excel, office, olap