Dave's Adventures in Business Intelligence

As mentioned earlier, one of the key themes mentioned in the morning keynote was (once again) mobile applications. Later on I saw a brief marketing video from SAP that showed off some of their mobile apps, and I started to wonder: were some of those apps mobile because they needed to be? Or because they were simply re-positioned from a desktop? And if so, where is the value? For example, one of the sample apps shown appeared to be an HR app used to approve expense reports. I can honestly say that I’ve never heard a request from our HR department saying they needed to do that via a mobile device. The same could be said for many of the other applications shown (however briefly) in the video.

Years ago I had a friend who started a company that was going to be based on the Internet. His idea would have been a very early front-runner in the social media space, although we didn’t know that at the time. Like many, his company disappeared during the “dot bomb” collapse. What really intrigued me about his idea, though, was that it was not a company that could be built on the Internet, it was a company that required the Internet in order to function. (The same could be said about most social media companies today which is why I said he was a front-runner in the space.) During the same time he was launching his idea, many other companies were trying to simply re-platform their brick-and-mortar offerings on the web, with various degrees of success. They didn’t require the Internet to function, they were just using it as a delivery device.

Today I’m starting to feel like I am seeing the same thing with mobile. Everybody seems to want to show off their mobile apps, but what they’re showing (at least a large percentage of the time) is a desktop app or common function that has been repositioned as a mobile app. It’s something that could be done equally well on either type of hardware. I don’t think anyone with a smart phone is going to be interested in giving up mobile access to their email, and that’s clearly a desktop app that has been re-platformed very successfully. Blackberry probably would not exist as a company today if not for the success of their mobile email devices. When I go out shopping, I frequently use Amazon or eBay as a price guide to see if a locally available item is priced competitively. That’s not a mobile app, though, that’s simply mobile access to data. I could do my comparison shopping at home, but it’s certainly convenient to have it on a mobile device.

I can get sports scores on my phone. I can get the same thing at home. Again, it’s convenient to have mobile access but it’s not mandatory.

Today I can deliver Web Intelligence documents over the Internet with the mobile platform in BI 4.0. That’s not really a mobile application, it’s an alternate delivery path for desktop content. The same thing could be said for the mobile version of Explorer.

In fact, I personally can’t think of a single thing that I currently do with my Blackberry that requires mobility. I just have a bunch of desktop applications in my pocket. There is value in that, but it’s not a very compelling (at least to me) mobility story.

How about you? Do you have any true mobile apps? Something that would not be possible any other way? Or are they simply desktop apps on a different device? Spreadsheets were the “killer app” for desktop computers. Email may have been an early force behind the growth of smart phones, but what’s the true mobile killer app that we can’t live without?

I took quite a few notes during Vishal Sikka’s keynote that kicked off SAP TechEd 2011, and I’ll have a longer summary coming out later on. However, I wanted to share a few highlights while they’re still fresh.

Once again the primary themes are mobility, cloud computing, and of course Hana. Some might say boring, others would say stable. IT likes stable. There’s nothing like deciding to drop several hundred thousand to millions of dollars on new technology only to find out that you made the wrong bet. Hasso in a video said that Hana has moved from viable concept to extremely desirable technology. As a result, SAP is starting the drive to educate customers on how / when / where to use Hana in order to speed adoption.

Dr. Christoph Kollatz took the stage to talk more about Hana, saying that in the 10 months since the release (3 months in GA) Hana has had the fastest growing pipeline of any product from SAP. Ever. He shared some customer success stories that very specifically included the terms “went live” instead of “proof of concept.” Of course the focus was on how much more efficient processes had become as a result (days to hours to seconds in some cases) and I’ll share more details later. I’m sure it’s no surprise that the customer they provided as a reference was using Hana to replace Oracle. 😉

Customers will be able to start switching their BW data stores over to Hana starting with a release that should be available in November. It would be interesting to know what the most popular platforms are for BW currently, and what the financial impact will be on those companies if SAP customers start switching to Hana?

The most important note from my perspective is that Vishal reconfirmed the September 16th general availability date for BI 4.0. But overall BI 4.0 was a small part of the keynote, much like Sybase which didn’t even get mentioned until over an hour into the session.

The opening keynote last night was very interesting as well. It featured Dr. Jane McGonigal and the concept of “gamification” which I found fascinating. I want to let my thoughts marinate for a few days before I share what I got out of her talk though.

Hi, folks, I’m sorry for the delays as I fully intended to upload the code by now. It turns out that everything was ready to go but there’s no button to click to run the macro! I realize many of you can figure out how to run the code anyway, but I decided to pull the code back and get a button set up.

I’m getting ready to travel to SAP TechEd this afternoon, but hopefully will either be able to get the update made on the plane or after I get to the hotel tonight. I may yet get this released before BI 4.0 comes out. 😉

At the 2010 SAP BusinessObjects User Conference (also known as SBOUC) I did a presentation titled, “Don’t Lose Control: Change Management Strategies for Universe Designers.” The slides from this presentation are available as a PDF download on my conference presentations page or via a link at the end of this post. I said I would post a download link last week; I didn’t yet. 😳 It took longer than I expected to write up the documentation that I felt was required prior to the release. Part of that documentation has been extracted and published as this post instead as I don’t expect everyone will care or need to know about the background as to how this utility came about. However, it was important to me, so I wrote it. 🙂

Which brings up the philosophical question: if a blogger writes a post and nobody reads it, does it make the sound of one hand clapping? Or something like that… Continue reading “Universe Compare Tool – How It Came To Be”

I’m sure no child labor laws were violated during the filming of that video… 😉

This post details the system requirements and support plans for my universe compare tool which will be posted for downloading later this week. Comments are off for this post; any questions should be posted in the release topic, once it’s available.

System Requirements

Continue reading “System Requirements and Support Plans For Universe Compare Tool”

WordPress (the software that powers this blog) is released under the GNU GPL license. So is phpBB, the board software used to run BOB. The essential purpose of the GPL license is to provide software authors the rights of copyright and to provide software users with the freedom to do whatever they want to with the software. There is a FAQ provided by the FSF (Free Software Foundation) that addresses many questions related to the GPL but I would like to call attention only to a few specific items.

I want to get credit for my work. I want people to know what I wrote. Can I still get credit if I use the GPL?
You can certainly get credit for the work. Part of releasing a program under the GPL is writing a copyright notice in your own name (assuming you are the copyright holder). The GPL requires all copies to carry an appropriate copyright notice.

Simply put, this means that even though I am releasing code under the GPL I still retain the copyright to the code. Releasing it under the GPL ensures that anyone who downloads the code for use has the right to do so, and that those rights cannot be removed by someone else. If someone were to download my code and modify or improve it in some way, then the modified / improved version must also be released under the GPL, so that everyone can benefit.

If I add a module to a GPL-covered program, do I have to use the GPL as the license for my module?
The GPL says that the whole combined program has to be released under the GPL. So your module has to be available for use under the GPL.

That restates what I was saying earlier. By releasing my code under the GPL it protects everyone. Someone could take my program and turn around and try to sell it, but anyone who buys a copy – even if there are improvements – has the right to then distribute the software for free. Code based on GPL software must be licensed under the GPL, which grants the user the right to decide what to do with it, not the owner of the copyright.

What does this have to do with anything? 🙂 I just finished a project where I reworked a very large universe. During that project I used my universe comparison tool quite extensively, and I think the final testing is done. I will be posting a copy of the VBA code for download next week here on my blog. The software will include the GNU GPL license so that anyone is free to use it in any way they see fit.

Keep in mind that – unfortunately – there is already an expiration date on the software, as the BI 4.0 Information Design Tool does not initially ship with an SDK, and even when it does start to provide one it will likely be in java rather than visual basic. So enjoy it while it lasts. 😎

Not too long ago I had a very frustrating run where certain events (and I was never quite sure what the connection was) would cause my designer session to crash. For a while it was just exporting a universe. The universe would get exported successfully and then Designer would immediately crash. Then I started having problems with Desktop Intelligence where I could not edit documents related to a specific universe. The universe itself was fine, as I verified by going into the Infoview portal and creating documents. And others were able to use the universe just fine.

Ultimately I found a post on BOB that pointed me in the right direction. The seemingly “random” events all had to do with accessing the security areas of the repository, and that pointed to a corrupted .lsi file. These files have been around for many versions of the Business Objects software. Although I don’t remember ever getting a confirmation one way or another I have always called them the “local security information” files. This file is what lets Desktop Intelligence users work in offline mode as it contains a list of universes and documents and so on that the user has rights to. It makes sense that exporting a universe works because that’s not related to security. It’s only after the export was complete that the local security information file was updated, and since my file was corrupted in some fashion that update failed.

Removing the .lsi file for that particular environment solved the problem. There’s no harm in removing this file as Business Objects will automatically regenerate it the next time it’s needed when the program realizes that it is missing.

Where are the .lsi files? The location may be different based on how the software is installed, but they should be within the application folder that is contained within the Documents and Settings parent folder. Here’s the path for me under XI 3.1:

D:\Documents and Settings\username-here\Application Data\Business Objects\Business Objects 12.0\lsi

Once I deleted the .lsi file for the offending environment – I could have removed them all because they’re automatically regenerated if they’re missing – everything worked again. That being said, there are two files in that folder that should not be deleted, and those are pdac.lsi and sdac.lsi. Those files are used to store information related to personal (pdac) and shared (sdac) connections that have been defined on the client computer.

If you’re wondering what ABEND means, it’s short for “abnormal ending” and dates back to mainframe days. 🙂

There has been some confusion around HANA the product, but also around HANA the name. Originally it was an acronym, but it isn’t anymore as detailed in this blog from SCN that clarifies just what HANA means as far as the product name goes.

A few weeks ago I attended the quarterly meeting for the Dallas/Fort Worth ASUG chapter. I didn’t get to stay for the entire day, but I did get to hear the keynote by Dr. Jeffrey Word about HANA. The talk was less about the technical aspects of HANA and more about the genesis of the idea. He started with a very interesting comparison. It seems that HANA is SAP’s iPod. Continue reading “Still More HANA: Report from DFW ASUG Chapter Meeting”