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. SSAS Maestros 1.2 Courses Join us for a five-day deep-dive course on Analysis Services 2008 R2 UDM and join the SSAS Maestro Program. Prepared and presented by SQLCAT, top industry experts and the SQL Server Analysis Server team, this intensive 500-level course gives top SSAS…
Tag: Internals
Can I access PowerPivot via a data access API?
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 is: Right now, there is no supported way to access the data store within Excel as all PowerPivot for Excel APIs are private. Saying this, the data store backup is stored within Excel itself as per the posting For Excel PowerPivot, the database is IN…
Analysis Services ROLAP for SQL Server Data Warehouses
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 14 months of testing, validation, analysis, and all sorts of hardware headaches and dancing, I am proud to say that I have finally published the Analysis Services ROLAP for SQL Server Data Warehouses whitepaper with my trusted partners-in-crime Thomas Kejser and Kay Unkroth. Thomas for…
PowerPivot, Analysis Services, and TechReady….and coffee!
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 I also used to live in Montréal so we’re real coffee snobs there, eh?!) – the best place for coffee without a doubt is Espresso Vivace! The closest one is the one across from REI but there is also two on Broadway in Capital Hill. …
Ramblings about missing time … and #PowerPivot sneak peek!
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 I do have a good excuse! Really! Oh, and for those of you patient enough to read to the end, I do have an interesting sneak peek for you 🙂 RTM… aaaaaaahhhhhh!! RTM is driving me nuts…but then again, Dave Wickert (PowerPivotGeek) has been handling…
What happens when you run a Data Refresh within #PowerPivot for SharePoint?
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 the xlsx is updated by SharePoint during data refresh, is that step subject to the 2GB file limit? and I thought it made sense if that we share this answer as well. So the answer is “Yes”. … Details you ask? Okay, here are the…
Denny Lee 