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: Within the PowerPivot window, you’ll notice that the lower case “a” has now become an upper case “A”. If “a” had come before “A”, then both rows would be “a” instead of “A” 😉 Why are you so in-sensitive? Actually, it isn’t THAT in-sensitive. When importing, the PowerPivot client picks up the regional settings and…
Month: June 2010
Microsoft PowerPivot for Excel and SharePoint
As you may already know from some of the tweets concerning #PowerPivot, the book Microsoft PowerPivot for Excel and SharePoint is now available at Amazon.com. The book’s authors are Sivakumar Harinath, Ron Pihlgren, and Denny Guang-Yeu Lee (i.e. myself). Siva and Ron are both long time (this is a good thing) testers with the Analysis Services team. And myself, well – you already know who I am (just in case you don’t, I’m with SQLCAT specializing in Analysis Services and PowerPivot). This is an end-to-end book describing all of the moving parts within PowerPivot. It is written in difficulty order…
Win a signed PowerPivot Architecture Technical Diagram at TechEd NA 2010
There are many reasons to go to TechEd North America 2010 in New Orleans this year. After all, it is THE event for developers and IT Professionals. And if you want to know more about PowerPivot, here’s yet another reason why you need to go. There will be a raffle to win a signed copy of the PowerPivot Architecture Technical Diagram (screenshot below) in each of five PowerPivot sessions (five diagrams in total). The sessions are: BIE04-INT – Building Custom Extensions to the PowerPivot Management Dashboard (Mon 6/7 1:00pm-2:15pm, Room 241) BIC06-INT – SQLCAT: PowerPivot Best Practices and Enterprise Case…
Denny Lee 