Mark Polino's Blog, page 236
May 10, 2012
Rebooting because of an Automatic Update does interrupt SQL job execution. - Microsoft Dynamics GP DBA
GPUG Summit 2012 Customer Conference - Inside Microsoft Dynamics GP - Site Home - MSDN Blogs
You're going to get more GP 2013 even closer to it's release.[image error]
An Inside Look with Jared Hall - Inside Microsoft Dynamics GP - Site Home - MSDN Blogs
Anyway, Jared's a great guy, wicked smart, watch the video. So Jared, which child is your favorite?[image error]
Microsoft Dynamics Most Influential People Top 100 | DynamicsWorld
The DynamicsWorld.co.uk list of the Microsoft Dynamics Most Influential People Top 100 is out for 2012. I reiterate that I’m not sure that the list means anything but I confess that it is fun to be on it.
I slipped from #16 to #20 this year. Clearly I will have to step things up next year, though I’m not sure what I’m supposed to step up.
Andy Hafer and Andy Snook stayed exactly the same at #17 and 18. Andy Vabulas jumped from #27 to a much deserved #14. My friend, coworker and the man who writes my reviews, Clinton Weldon, landed at #53, up from #90. Shane Hall of The Closer fame moved up as well. Mariano, Victoria and Mark Rhodes all slipped a little, like me.
Congratulations to Jon Rivers, Bob McAdam, Joe Tews and Frank Hamelly on their appearance on the list. All them deserve to be there. I even said that about Bob and Frank last year.
That’s all the people that I could find who are in and around the GP space excluding Microsofties. This year’s list feels odd for the people who are not on it. No Errol, no Pam, no Christina Phillips, Steve Endow, Leslie Vail…you get the picture. I’m not sure what else David Musgrave has to do to make the list but clearly someone has a grudge against him.
Doug Burgum didn’t make the list but frankly, he shouldn’t have made the last two lists in terms of his influence today.
So we’re going to have to see if Doug Pitcher revives his 100 most famous, awesome and totally influential Dynamics people for 2011 list for 2012. I did get to say hi to Doug at Convergence so maybe I’ll make his list. Doug’s is snarkier and well, that’s always fun. Hmmm…Maybe I’ll start my own awards.
Weekly Review: Shopping Basket Analysis - Customers Who Bought “X” Also Bought…
I was reworking the list of SQL Scripts for DynamicAccounting.net and I realized that it would be nice to have some SQL code that showed related items. In other word, something similar to Amazon.com’s “Customers who bought “X” also bought “A”, “M” and “Y”.
I wanted to add a frequency to make it more relevant. What I was looking for was “Customers who bought “X” also bought “A” 56% of the time, “M” 42% of the time and “Y” 38% of the time. I could swear I’ve seen code like this but I couldn’t find it, so…I created it.
I built a SQL Stored Procedure that accepts an inventory item as it’s only parameter and returns other items that were sold on the same invoices along with the percentage of how often they appeared together.
For example, executing the procedure with the item “5-Fee” looks like this: exec BoughtRelated '5-Fee' and returns this:
This won’t work in SmartList Builder since SLB won’t use a Stored Procedure. To work around that I’ve included a download that does the same thing with Views instead of a stored proc. It’s not as efficient and it takes 3 views to make it happen though I suspect someone smarter than me can make it cleaner. The only other advantages (maybe) to the views is that you could return results for all items, not just one. This could be a plus or it could severely bog down your system if you have enough items and invoices. I told you it was inefficient.
Finally this works off of SOP invoices under the theory that it’s not really bought until it’s invoiced. Also, I didn’t bother including returns because it’s not really relevant from a sales/pairing standpoint. The returns piece is really a different question.
I’ll add these to the permanent SQL Scripts as well.
The files are here:
Related Items Procedure
Related Items Views
Originally Posted by Mark Polino at 6/21/2010 09:00:00 AM
May 9, 2012
Mini-Post 2 of 2: PivotLink, Birst, QlikView, and “Desktop-Only” PowerPivot added to ROI Quadrant « PowerPivotPro
Since I’m working on a PowerPivot presentation for the GPUG Summit in October I thought this post on the ROI Quadrant might be interesting to you. Just a note, this is geared more toward ad hoc BI tools, not really CPM offerings.
Training: Keep reports up to date with Missing Account Analysis - Dynamics Corporate Performance Management - Site Home - MSDN Blogs
