Posts Tagged 'Excel'

PowerPivot Technical Architecture Diagram Released: Security Architecture

Published August 30, 2010 Internals , Perspectives Leave a Comment
Tags: , , , , ,

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

PowerPivot Technical Diagram: PowerPivot Security Architecture

Published August 18, 2010 Configuration , Internals Leave a Comment
Tags: , , , , ,

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)

Published June 18, 2010 Internals , Perspectives Leave a Comment
Tags: , ,

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’?

Published June 17, 2010 Configuration , Installation Leave a Comment
Tags: , , ,

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!

Published May 19, 2010 Internals , Perspectives , Usage 2 Comments
Tags: , ,

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

Published April 28, 2010 Internals , Perspectives Leave a Comment
Tags: , ,

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

Published April 27, 2010 Usage Leave a Comment
Tags: ,

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

An interesting post on the manageability of PowerPivot

Published February 14, 2010 Perspectives Leave a Comment
Tags: ,

By powerpivotgeek (dwickert@hotmail.com), on February 2nd, 2010

The Excel 2010 blog just posted an interesting article on the management aspects of PowerPivot – more of a “Why should I care?” kind of article, see (http://blogs.msdn.com/excel/archive/2010/02/01/management-features-of-powerpivot-for-sharepoint.aspx). It shows how PowerPivot helps IT answer:

Read more…

Cube Formulas and NamedSets Running Commentary

Published February 4, 2010 Perspectives Leave a Comment
Tags: , ,

For those of you who want to know the timeline of the commentary by @PowerPivotPro and @dennylee on cube formulas and named sets.  Rob started the process with his excellent introductions:

Then @dennylee innocently created a three-part posting on how to create filtered by Top 10 reports:

which was quickly responded to and openly challenged by @PowerPivotPro

Solid punches were given and mayhem ensued, but @dennylee got his footing back and wreaked havoc via pile driver!

Perhaps more mayhem will ensue – perhaps not.  And in fact – it did with a great entry from Rob:

So the feud is over…we think!  Either way, you have to admit its sort of dorky, eh?! ;-)

Create a #PowerPivot report filtered by the Top X Users by (Part 3 of 3)

Published January 31, 2010 Calculation Leave a Comment
Tags: ,

This blog posting is a continuation of previous post, Create a #PowerPivot report filtered by the Top X Users by (Part 1 of 3), where I had created an Excel Named Set based on the Top 10 Users by Events as noted in Figure 1.  What is handy about using named sets is that it will only render the top 10 rows as opposed to the millions of rows of users this data set has.  While it is easy to show the Top 10 users, it is not straightforward to filter by those Top 10 users because Excel Named Sets cannot be used as a filter.  Example reports with  this type of business logic include “most common hospital departmental systems that the top 10 users are accessing” or “what are the most watched TV programs of the top 10 markets (i.e. cities)”.

image

Figure 1: Top 10 Users by Events using an Excel  Named Set

In the second blog posting of this series, Create a #PowerPivot report filtered by the Top X Users by (Part 2 of 3), I showed how to filter by this same named set in a static fashion.    In this third part of this blog series, let’s figure out how to filter by a named set in a dynamic fashion.

Read more …

Next Page »

Denny Lee’s Tweets (1/2 of PowerPivot Twins!)

Copyright

Copyright © 2010 Denny G Lee - All Rights Reserved
Follow

Get every new post delivered to your Inbox.