Welcome to the world (new face) of Knowledge Sharing Network.
To track the older blog posts refer to our historical knowledge sharing site  and you will find this as your destination for SQL Server knowledge pool.

Follow SQLMaster on Twitter SqlServer-QA.net - Knowledge Sharing Network (@sqlmaster)

↑

excel - SQL Server Knowledge Sharing Network (@sqlmaster)

Browse by Tags

All Tags » excel (RSS)
20 May 2010 08:47

SQL Server 2008 R2 PowerPivot for Excel and SharePoint is here; volume licensing downloads available

Self-Service Business Intelligence is the new solution from SQL Server 2008 R2 that enables the end users to access, analyze and share data across the ... read_more....
Posted by ssqa.net | with no comments
Filed under: , , , , , ,
14 March 2008 06:10

Pivot table connectivity to SQL Server Analysis Services - security gotchas

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...
Posted by ssqa.net | with no comments
Filed under: , , , , , , , ,