williamweber.net
  • Home
  • About
  • Minnebar 2013 Wrap-Up

    Last Saturday I attended my first Minnebar, a local BarCamp style event for technology geeks of all shapes and sizes here in the Twin Cities. My original goal was to attend a [...]

    Read more
  • Thoughts on Killzone 3 Multiplayer Go...
    killzone3

    A few days ago I read that Killzone 3 would be offering up it’s multiplayer component free of charge with progress limitations and a $15 price tag to acquire the full e [...]

    Read more
  • A Game Funding Revolution
    A Game Funding Revolution

    Earlier this month the game Double Fine (the development studio headed by Tim Schafer) started a Kickstarter project with the goal of developing a classic point-and-click adv [...]

    Read more
  • Named Set Sub-totals in Excel using V...
    Named Set Sub-totals in Excel using VisualTotals()

    This is just a quick tip for fixing the default Analysis Services (SSAS) named set sub-total behavior in Excel 2010. Normally when you select a named set for the rows or colu [...]

    Read more
  • New Camera Please. – Mirrorless...
    Olympus OM-D E-M5

    A few years ago my wife and I upgraded our intro-model DSLR camera for a mid-range one (Nikon D60 to the Nikon D90). We’ve really enjoyed the camera and looking at our [...]

    Read more
  • Formatting Map Legends in SQL Server ...
    Formatting Map Legends in SQL Server 2008 R2 Reporting Services

    Recently I needed to do some slightly more advanced formatting of a map legend in SQL Server 2008 R2 Reporting Services (SSRS). I love the map reports you can build with SSRS [...]

    Read more
  • MDX: Scope Statement For All Measures...

    This was irritating me today so I thought I would share. If you need to write a scope statement that will include all the measures in multiple measure groups; perhaps youR [...]

    Read more
  • Startup Frenzy Is Out of Control

    A recent, and refreshingly brief, article over on Business Insider about the inexplicable amount of hype that tech media lavishes on startup funding crystallized what’s [...]

    Read more
  • The Building Windows 8 Blog is Amazin...

    Wow! The Building Windows 8 blog is amazing. And the most recent post, Reflecting on your comments on the Start screen, in which they respond to a number of the comments abou [...]

    Read more
  • My iPad Must Have App List

    I was recently asked for a list of apps I would recommend for the iPad. I decided to do it up right, with links and some brief commentary and post it on the blog. Seemed the [...]

    Read more

Monthly archives for February, 2012

A Game Funding Revolution

Feb28th
2012
Leave a Comment Written by Will

Earlier this month the game Double Fine (the development studio headed by Tim Schafer) started a Kickstarter project with the goal of developing a classic point-and-click adventure game. Now if you’re not familiar with Kickstarter it’s essentially a funding mechanism for creative projects. Anyone can propose a project with whatever funding goal they believe will take the project to completion. Backers pledge money to these projects, if they deem them worthy, and if the funding goal for the project is met then — game on! If the goal is not met, well in that case no money changes hands and the developer can either go back to their day job or try to come up with something more compelling to draw the attention of more backers.

It’s an amazing platform.

Backers are not “investors.” The developers keep 100% ownership of their creation. Backers are often enticed with rewards for various levels of backing. Depending on the project it could be a copy of the product itself or some unique experience related to it that provides something to backer for their donation.

The Double Fine Adventure is the first time, at least that I’m aware of, that an already well established company has come to gather funding for a what amounts to a side project. And it’s been amazingly successful. They reached their goal in record time, reached $1 million in record time and are the first project to reach $2 million, and as of this writing they still have over 13 days remaining of their original 30 day goal.

The reason this particular project is exciting, at least to me, is that it represents what could be a fundamental change in how games get made. Minecraft gave this type of funding it’s first taste of fame. By putting out a very early version of the game and asking people to basically pay early for the finished product Markus Persson (@notch) has been able to not only fund his brain child in perpetuity but he’s now developing all sorts of other games and projects. He’s not beholden to publisher whims. He has the freedom to create without needing to justify his decisions to a board or shareholders or some mindless marketing drone. The only thing stopping him from doing whatever the hell he damn well pleases is the support of the people who play his games. If he puts out crap, no one will buy it and he’ll fade into obscurity.

That’s the sort of relationship that I would love to have with creators. In this instance I’m talking rather specifically about the game development world but I could certainly apply the same desire to any creator.

Back to Double Fine and Tim Schafer and the Double Fine Adventure and why I think it’s potentially more significant than the success of Minecraft. The first important distinction is the chain of events. By using Kickstarter Double Fine is asking for funding up front, before development has started. With Minecraft Persson had a working game that he put out there in demo form and then asked for money to continue development. Buy getting funding up front people developers with great ideas who may not have the time or finances to get started can try to come up with a pitch that will get them the funding that they need to get started. Obviously Double Fine is a special case here, Schafer has a cult-like status in the gaming world so just putting his name on a project guarantees a certain level of support from his fan base. But the success of the Double Fine Adventure brings me to my second point.

Visibility.

The success has brought attention to Kickstarter as a platform for game funding that wasn’t there before. Take a look at Code Hero which blew up in the last few days of funding after Double Fine announced their project. Here’s a game with a fantastic, fresh concept that would never get the backing of a big name publisher. They may have hit their funding goal without the added attention but because of it they hit almost 200% of their goal giving them that much more backing to make the game better.

As awesome as all of this is it isn’t going to change the fundamental nature of the game development world. Triple A games are going to stay on their breakneck annual release schedule and they are going to continue to rake in hojillions of dollars on the backs of overworked developers and under funded QA departments.

What I hope does happen though, is that the success of Minecraft and the Double Fine Adventure opens up new lines of direct communication and support between creators and their fans. If a new breed of games can gather funding directly from the pockets of the people who want to play them without marketers, publishers, and god knows who else taking their cut, developers can get the freedom to do what they truly want to do. Sure, some will fail and for every Psychonauts that may be born from this process we’ll probably see just as many Shaq Fu’s but that’s the price you pay.

 

 

Gaming    Gaming, kickstarter
SHARE THIS Twitter Facebook Delicious StumbleUpon E-mail

Named Set Sub-totals in Excel using VisualTotals()

Feb22nd
2012
Leave a Comment Written by Will

This is just a quick tip for fixing the default Analysis Services (SSAS) named set sub-total behavior in Excel 2010. Normally when you select a named set for the rows or columns of a pivot table you don’t get a sub-total. Which, for me, removes a lot of the usefulness of the named set. Thankfully it’s a relatively easy fix. It just takes a little additional MDX in your named set definition.

Enter: VisualTotals() (msdn function reference)

The VisualTotals() function dynamically totals child members in a set. By adding the “All” member for whatever hierarchy you’re building your set from and wrapping the whole set in the VisualTotals() function you can get Excel to treat the named set just like any other group/hierarchy when it comes to sub-totals.

Typically if you created a set like this one (all examples from Adventure Works):

WITH SET [Amasia] AS
{
	[Geography].[Country].&[United States]
	,[Geography].[Country].&[Canada]
	,[Geography].[Country].&[Australia]
}

You’d see something like this:

no sub-totals

If instead you create your set like so:

WITH SET [Amasia] AS
VisualTotals(
	{
		[Geography].[Country].[All Geographies]
		,[Geography].[Country].&[United States]
		,[Geography].[Country].&[Canada]
		,[Geography].[Country].&[Australia]
	}
)

You’ll get a nice little sub-total at the bottom.

Yey! sub-totals

One thing to note is that you need to put the “All” member at the beginning of your VisualTotals set. Otherwise it won’t be correctly filtered by the children that follow and you’ll end up with a sub-total that is actually the full, unfiltered total of the “All” member.

BI    BI, MDX, Scripts, SSAS
SHARE THIS Twitter Facebook Delicious StumbleUpon E-mail

New Camera Please. – Mirrorless ILC Goodness

Feb8th
2012
Leave a Comment Written by Will

A few years ago my wife and I upgraded our intro-model DSLR camera for a mid-range one (Nikon D60 to the Nikon D90). We’ve really enjoyed the camera and looking at our picture catalog from the before we moved into the DSLR world it’s readily apparent how much better our pictures are using a quality camera over a point-and-shoot.

That being said, I want a Mirrorless Interchangable Lens Camera (Mirrorless ILC or MILC) right now.

Trey Ratcliff (G+, twitter) over at www.stuckincustoms.com made a post recently about the coming demise of the DSLR. It got me interested in the technology and after looking at some of the new cameras that are coming out, I can’t wait to upgrade.

This one in particular caught my eye. It’s the Olympus OM-D E-M5. Stupid naming conventions aside, it looks sweet. The silver body model, with it’s throwback design is especially appealing. I reminds me of the my old film camera from high school. And although I have no particular love of my high school days I did love taking pictures and working in the dark room for hours on end.

Olympus OM-D E-M5

Unfortunately an upgrade is a long way off. These new-fangled toys don’t come cheap and all my existing DSLR lenses don’t do me a lick of good. Yep, gotta buy new stuff there too.

On the upside by the time I can afford to upgrade I believe the vast majority of the “issues” people have with the new technology will be worked out. Sensors will be bigger, the electronic viewfinder will have improved in speed and performance, and most importantly, the prices will start to come down.

In the mean time I’ll just lust after all the pretty hardware from afar.

Photography    cameras, dslr, mirrorless ilc, photography
SHARE THIS Twitter Facebook Delicious StumbleUpon E-mail

Recent Posts

  • Minnebar 2013 Wrap-Up
  • Thoughts on Killzone 3 Multiplayer Going Free-to-Play (or is it Free-to-Pay?)
  • A Game Funding Revolution
  • Named Set Sub-totals in Excel using VisualTotals()
  • New Camera Please. – Mirrorless ILC Goodness

Categories

  • BI
  • Gaming
  • Opinion
  • Photography
  • Reporting
  • Scripts
  • Social Games
  • SQL Server
  • XNA

Archives

  • April 2013
  • March 2012
  • February 2012
  • January 2012
  • December 2011
  • October 2011
  • September 2011
  • April 2011
  • January 2011
  • December 2009
  • July 2009
  • April 2009

EvoLve theme by Theme4Press  •  Powered by WordPress williamweber.net