Posts Tagged 'Excel'

PowerPivot Technical Architecture Diagram Released: Security Architecture

Because PowerPivot for Excel and PowerPivot for SharePoint involves so many components from SQL Server 2008 R2 Analysis Services, Office 2010, and SharePoint 2010, this poster provides an end-to-end view of the PowerPivot Security Architecture in one view.  This view includes nearly all of the logical security surface areas and illustrates how these systems interact.

Included in this diagram are:

  • Service Accounts
  • SharePoint Databases
  • Security Hardening
  • Automatic Data Refresh
  • User Identity Flow
  • PowerPivot Permissions Levels

Please click through to continue reading: PowerPivot Technical Architecture Diagram

Advertisements

PowerPivot Technical Diagram: PowerPivot Security Architecture

Just in case you didn’t already know, we just uploaded the PowerPivot Security Architecture technical diagram on to sqlcat.com / MSDN.  To get access to the PDF, XPS, and/or VSD files, please click through to: http://sqlcat.com/whitepapers/archive/2010/08/17/powerpivot-technical-diagram-powerpivot-security-architecture.aspx

 PowerPivot Security Architecture

Enjoy!

[Note, this is cross posted from dennyglee.com in its entirety]

PowerPivot, you are so insensitive! (case that is)

June 18, 2010 by dennyglee

Working with my compatriots Ayad Shammout (@aashammout) and Peter Myers, we had found out that PowerPivot at times can be really insensitive…in terms of case that is.  That is by default, the collation for PowerPivot is case-insensitive.

For example, if you import the table below:

Continue reading: PowerPivot, you are so insensitive! (case that is)

Client: What happens if I install the wrong ‘bitness’?

By powerpivotgeek (dwickert@microsoft.com), on June 17th, 2010

Recently ran into this situation: Customer installed the wrong PowerPivot bits on their machine. They were running on a 64-bit OS with Office 2010 x64, but installed PowerPivot for Excel 32-bit. Everything installed OK, but when they clicked on the PowerPivot tab in Excel; then the PowerPivot Window they received the following error:

Click through to continue reading.

PowerPivotGeek’s Tips, How-to, and A Peek Inside!

PowerPivotGeek has been doing a lot of GREAT posts the last week and its getting harder and harder to keep up with greatness!  Saying this, here are some great tips, how-to, and A Peek Inside!

Tips!

 

How-To

 

A Peek Inside!

Enjoy!

PowerPivot Technical Diagram: PowerPivot Client/Server Architecture

Because PowerPivot for Excel and PowerPivot for SharePoint involve many components from SQL Server 2008 R2 Analysis Services, Office 2010, and SharePoint 2010, this poster contains all of the key components that make up PowerPivot in one view. This view includes nearly all of the logical architecture components and illustrates how these componets work together.

Included in this diagram are the components for:

  • PowerPivot for Excel
  • PowerPivot for SharePoint
  • Browser-Based Clients and their connection to PowerPivot
  • Data Import and Data Providers in relation to PowerPivot
  • Analysis Services Clients and their ability to connect to PowerPivot
  • Timer Jobs, Health and Usage Data Collection in relation to PowerPivot

For more information, please go to the reference sqlcat.com site: PowerPivot Technical Diagram: PowerPivot Client/Server Architecture

Querying data within the PowerPivot Excel client add-in

By powerpivotgeek (dwickert@hotmail.com), on April 27th, 2010

Recently we have been seeing some users complain about how the PowerPivot Excel client add-in deals with queries. There are three limitations that you need deal with when working with SQL (TSQL, PL/SQL, or whatever) and stored procedures:

Continue reading Querying data within the PowerPivot Excel client add-in