Funday Monday: Day 1 at GOTO

So today was day 1 at the GOTO conference. Today none of the tracks related directly to what I work with daily, so I think I was around almost all the tracks for different sessions.

Solving Real and Big (Data) Problems Using Hadoop
So the first session actually was the only one, that related a litle to my work. I think approximately, once a year, a new technology is born in business intelligence land, which promise that it can replace the old enterprise data warehouse. This year it is Hadoop šŸ™‚

I can understand why salespeople want to get that message out, because it is a good business case, since the development of an enterprise data warehouse can be expensive, and if you can replace it with something that is almost free, hey, why not.

But it is not going to happen, for many obvious reasons I don’t want elaborate on in this post.
However, Hadoop is really cool, and it can enrich many companies BI & DWH solutions(Not replace them).

I have seen a lot of presentations at different conferences and user groups about Hadoop, but the presentation by Eva Andreasson from Cloudera was the best so far, and she almost convinced me to buy the book ā€œDefinitive Guide to Hadoopā€ in the FactumĀ bookstore.

Microsoft Devices and Services
As an old .Net developer, it is allways exciting to see what MS is up to. I attended 2 session from MS. ā€œWindows Phone app developmentā€ and ā€œWindows Azure Mobile Servicesā€. One thing that amazes me, is how fast it is to develop to windows phone and all the azure things.

Reliving the history of multiplayer games
I also went to the session ā€œReliving the history of multiplayer gamesā€. I don’t do game development myself, but hey, I do a lot of gamming. It was fun to see the presenters be so excited about games. My key take away: I want to work on something that relate to computer games in the near future šŸ™‚

Taking The Hippie Bus To The Enterprise
My last session of the day. Again, not something I work with directly, but it is always cool to catch up with the trends in .Net land. A lot of code examples and overall a great presentation by Microsoft MVP Mogens from d60.

All in all, an exciting day.

My GOTO program

I have not completely decided on my GOTO program yet, but here is a list of some of the sessions I’m looking forward to šŸ™‚ Ā Some of them are at the same time, so I really hope that they will be available on VOD afterwards.

Don’t be religious about the Internet of Things!
As an owner of a BI company, I have noticed that all of my competitors are talking about the internet of things, and yet, I still do not know what it is šŸ™‚ So yes, I’m looking very much forward to this session, where I’m hoping to get at good introduction to the subject.

I have a feeling that it is somehow, someones view on big data, but from another perspective. I have tried to take a look at the comic book by The Alexandra Institute, but I’m still not completely sure about what it is.

The ā€œMaking sense of dataā€ track
Well, the job description of every business intelligence developer, is properly to ā€œmake sense of dataā€, so I’m guessing this is a must šŸ™‚

The track ā€œOpen Data / eGovā€œ
A part of big data (In my line of work, it is important to say big data a lot these days), is to enrich a companies data warehouses with all kinds of market data. So all information about how to do that is welcome.

The NoSQL, MySQL and Big data track(There is that word again)
There is a trend at the current time, that make developers use no SQL databases. As a consumer of the data the developers applications create, I have to know there mindset behind this, so sessions about this, is also of big interest to me.

Well I guess that is it. Else I’ll just go with the flow, and get inspired by the people I talk to at the conference.

Attending GOTO as a Business intelligence developer

Back in my .NET developer days, like 100 years or so ago, I went to my first GOTO conference(Or JAOO as it was called back then). Back then, I loved .NET and anything that related to it, but that wasn’t the reason I went to GOTO.

If I wanted to know more about the changes from 1.0 to 1.1, it was proberly a MS conference I should have went to.

The reason for attending to GOTO, was to get inspired. Get inspired by all the different tracks, learning about what was going on with all the other languages and trends.

So, fast forward approx. a 100 year and a technology lane shift to a BI developer. Why should I go now??? Well, the same reason. If I want to know more about how the new indexes works in MS SQL server, or for instance the new in memory technologies from MS, other conferences offer that.

But my world changes fast, and a lot of new technologies are emerging, and even as a BI developer, GOTO still offers a lot of inspiration. All the next big things in my line of work, like Big data, the internet of things, no sql, open data, and a lot of other things, all has a track at GOTO.

BTW, If I haven’t mentioned it, I’m attending GOTO this year, and if you are like me, I guess I’ll see you there šŸ™‚

Error code: 0x80040E21 Reading from SSAS with SSIS

So, I upgraded a big project for a customer to 2012 from 2008R2. Everything worked fine, except the last part, where some datamarts was loaded with SSIS from SSAS. They had worked with no problem before, but suddenly, I received the above error code. It made no sense to me, and it was hard to find out, what precisely had happen. The worst, was, that I was able to see the preview in the datasource, but not run the package.

A workaround was to create a linked server to the cube, and then just select from that like so

SELECT * FROM openquery(<ServerName>, ā€˜<MDX>’)

And that was, properly they way I would have implemented it myself. But having hundreds of packages, rewriting them, was not the way to go.
Instead, I found an old post on google, where a person had the same problem, in an older SQL server. The solution was, to open the connection, click the all botton, and type in ā€œ(Format=Tabular)ā€ in the extended properties field. Se the image bellow.

So, yeah…., YIEAKS. But hey, if you find yourself having the same problem, you now know what the solution is šŸ™‚