In homage to the maestro, the Battlestar Galactica image links to Bear McCreary’s All Along The Watch Tower. Note, This is a re-post of Announcing SSAS Maestros v1.2 on the SQLCAT blog. — We are proud to announce that SQLCAT will continue with the SSAS Maestros course in June and July in Redmond and Madrid. [...]
Posts Tagged ‘Internals’
Announcing SSAS Maestros v1.2
Posted in Analysis Services, tagged Internals, Performance, SSASMaestro on May 12, 2011 | 1 Comment »
Can I access PowerPivot via a data access API?
Posted in PowerPivot, tagged Excel, FAQ, Internals, SharePoint on October 27, 2010 | 2 Comments »
I recently got asked the question: Does PowerPivot have any data access APIs? Is there any way to to programmatically access the data store? I figured that a lot of people will eventually ask this question (heck, that’s what I had asked when I had first heard about PowerPivot). The answer as of 2010 [...]
Analysis Services ROLAP for SQL Server Data Warehouses
Posted in Analysis Services, tagged Data Warehouse, Internals, Performance, ROLAP on August 24, 2010 | 2 Comments »
You’re sh*&ting me. No way. Man, that sucks. rocks! – Toby Lee Shavers, from XXX (2002), altered of course! And before you start, yes, I’m starting to follow the schtick of quotes from fellow PowerPivot bloggers Rob Collie (@PowerPivotPro) and Kasper de Jonge (@Kjonge). For more memorable movie quotes, check out http://www.powerpivotpro.com/ . After about [...]
PowerPivot, Analysis Services, and TechReady….and coffee!
Posted in Analysis Services, PowerPivot, tagged Internals, Miscellaneous on July 26, 2010 | Leave a Comment »
If you’re going to TechReady 11 at the Washington State Convention Center this week in warm, sunny Seattle – first of all, welcome to the Emerald City! And if you’re a coffee snob like me (to give you background, not only am a long time Seattle resident so I pretty much breathe coffee – but [...]
Ramblings about missing time … and #PowerPivot sneak peek!
Posted in PowerPivot, tagged Book, Configuration, Connectivity, Design, Excel Services, FAQ, Internals, SharePoint, Troubleshooting on April 5, 2010 | 4 Comments »
Wow, I just checked and its been more than a month since I did my last blog post! So for starters, apologies for the lack of cool PowerPivot stuff on this blog. But it’s not like I haven’t been tweeting about PowerPivot…thank goodness I can easily retweet or type 140 characters! (follow me @dennylee) But [...]
What happens when you run a Data Refresh within #PowerPivot for SharePoint?
Posted in PowerPivot, tagged Data Refresh, Internals, SharePoint on November 8, 2009 | Leave a Comment »
I was just recently asked the question by a fellow Analysis Services expert (Greg Galloway): When you have SharePoint automate a data refresh for a PowerPivot workbook, is the new data saved back into the xlsx? So if I download the xlsx onto my laptop the next day, will I see fresh data? Also, if [...]

