Tuesday, September 25, 2007 - Posts

OLAP Connectivity from Pivot Table in Excel - security permissions
25 September 07 02:14 AM | SQL Master | 4 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 Read More...

Filed under: sql server, ssas, olap, execute, ssms, pivot, credentials, security, excel