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

Data Warehouse Scalability Features in SQL Server 2008
07 March 08 01:44 PM | ssqa.net | 1 comment(s)

By now you might be aware or have gone through the web resources and conferences about what's new within SQL Server 2008 version, one thing is sure scalability for your database platform. Though there isn't a real-time data warehouse implementation within...

Filed under: sql server, 2008, reporting services, blogs, new, technet, ssis, management studio, data warehousing, ssrs, features, documentation, analysis services, ssas, integration services