Dave's Adventures in Business Intelligence

I’ve already tweeted and posted about this on BOB, but in case you don’t check either of those two venues, ASUG has opened a new site to collect abstract submissions for the fall Business Objects conference.

http://callforpresentations.asug.com/

There was a question about the deadline for getting submissions in, and I will find that out and share it.

The event will be hosted once again at the Dolphin and Swan resorts at Walt Disney World. I really enjoyed my time there last year and am looking forward to another successful conference. Of course the success of the conference depends largely on the content, and the content is provided by the community. If you have a success story, please share. If you have a failure story, feel free to share that too. People like hearing both sides of a project.

Werner Daehn has started a topic on BOB that I have found very interesting… he has suggested that we do a series of sessions that will be a “soup to nuts” representation of a data warehouse implementation. Werner wrote:

Who wants to submit an abstractor as part of a consecutive series of “How to build a DWH” lectures?

I would come up with a nice source system and convert that into a Data Warehouse Star Schema in e.g. SQL Server database I provide to you. And then based on that Star Schema we can do our lectures with the different products.

The advantage would be that people who know one area, like Universe Designer, would see what can be done in other areas, e.g. what can be done in the ETL layer, the data modeler person will see the challenges an XCelsius developer has with a simple Star Schema. Simply provide the opportunity to “watch” the creation of an entire DWH within a couple of hours and attend the parts you are interested in.

If you’re interested, please log on to BOB and post your input in the topic.

See you in Orlando!

Related Links

• Soup to Nuts definition on Wikipedia
• SBOUC Call for Papers

I was not sure if I was going to be able to make it to SAPPHIRE this May, but it appears that I will be going. At least that’s the current plan.

For those of you waiting anxiously for details about the SAP BusinessObjects User Conference (aka SBOUC) I can tell you that things are moving forward behind the scenes, and that the call for papers dates should be announced soon. It looks like we’ll have about six weeks to get our abstracts ready. If you want to have some input on some of the possible categories, feel free to post suggestions in the comments. The process of getting those categories selected is going on right now. Some of you may even have received a survey from ASUG looking for your input. Even if you didn’t get the survey, you can pass your ideas on to me. I’ll do my best to get them to the right people.

I have had a number of questions or requests related to the release date for my universe compare tool that I demonstrated at the SAP BusinessObjects User Conference last month in Orlando. I am happy to report that I have almost completed the “digging out from under” process that occurs every year after the conference season, and hope to be able to finalize the initial release. All I have to do is remove the logic that checks for object incompatibilities (related to Aggregate Navigation) as large universes contain too much data to fit in a standard (old version) spreadsheet.

Once that is complete, I will release the initial version here on my blog. I anticipate at this time that I will be able to do this early in December. Thanks for your patience.

ASUG Annual Conference is taking a new approach to getting speakers for their sessions this year. In the past, this conference (as most of the others I have been a part of) has opened a “call for speakers” web page and allowed folks to submit ideas (abstracts). Those ideas are then evaluated and placed into the agenda. This is fine, but it leaves the conference committee at the mercy of the speaker community. If the speakers don’t submit enough ideas for a particular track, then the conference folks might be left scrambling as they work to fill out the overall agenda.

This year they’re asking speakers to share their initial ideas first, even before sending in any abstracts. The intention is not to make extra work, but to make a better conference. By getting an early indication of what the speakers are interested in, the conference committee can see where gaps might be and work to fill them during the call for speakers process. It sounds like an excellent plan to me! I hope it works well.

If you are interested in speaking at the conference, please consider filling out the call for presentations survey and let ASUG know what you’re thinking about.

I received comments in private related to posts (one in particular) I published last week regarding SAP TechEd. Since the comments were made in private I will not reveal the sources, but I do feel like I should address them in public since the posts are, of course, public. Others may have the same questions and will benefit from seeing my responses.

First, I need to make a correction. I provided incorrect information in a post last week where I said that SAP was hosting the SAP Insider “Reporting 2010” conference. That is not true. While I did reach out via Twitter and a few emails, I did not get any clarification on what the conference was until after the post was already published. I now understand that SAP Insider is not a part of SAP; they are an independent organization that publishes newsletters and provides specific and targeted conferences throughout the year. They may do other things as well, but I now understand that while SAP does participate by providing speakers, they are not the host of those events. I do apologize for my error and any confusion that may have provided.

Second, I had some folks take what I wrote as a criticism of ASUG. I was not criticizing either ASUG or SAP or their respective processes. What I was trying to point out was that despite some claims to the contrary we cannot simply drop the SBOUC conference and send folks to TechEd without changing what is delivered at TechEd. It was pointed out to me that the content for SBOUC was designed to not overlap with TechEd. I understand that, and perhaps I should have pointed that out in my earlier post. I am sure that the folks that went to those sessions appreciated them. But there is not enough content at TechEd as it stands today to simply drop SBOUC. With my post last week I was not trying to imply that the content at TechEd was bad or poorly planned by either ASUG or SAP. But several folks have been quite adamant in their opinions that there is plenty of content already at TechEd. My post was an attempt to point out that in my opinion there is not, currently, enough BI content at TechEd to simply drop SBOUC.

To recap: I believe there is a market and a need for a BI-specific event. However, if discussions are held regarding merging SBOUC and TechEd, then in my opinion it must be a merge. Dropping SBOUC without migrating the content to TechEd would not be a good idea.

Let me now talk about some positive outcomes of such a decision, were it to be made. If the content from SBOUC were added to TechEd, how would the community benefit?

First and foremost, there would not be any confusion on the part of the potential conference attendee or speaker. Which conference should I submit to? Do I have to alter my topic abstract to make it more appealing to TechEd than to SBOUC? How can I convince my manager to budget for two separate SAP conferences? Which one is most appropriate for my role in my company? All of these questions go away if the two conferences were combined.

Next, the TechEd conference is huge. It’s not as big as SAPPHIRE but it’s about three times the size even of the largest BusinessObjects conference that we had. For some folks that would be attractive; more people equals more networking opportunities, and higher probabilities that I might run into someone experiencing the same issues that I have. The old “Insight” conferences we used to go to had between 2,000 and 2,500 attendees at most. TechEd last week had well over 5,000 and SBOUC had over 1,000. Add those two together and we would have a single conference with about triple the number of attendees.

Finally, does anybody remember what one of the top complaints was about the SBOUC conference when it was first reborn as a GBN conference? No party. 🙂 I suspect because it has been larger (and therefore has a bigger budget) TechEd throws great parties. I did not write about Demo Jam this year, but I have previously. In fact, I had hoped to bring something like that to SBOUC. Score one for TechEd. GBN/SBOUC has dropped their conference parties for various reasons, but mostly related to budget. Since I have been attending, TechEd has had concerts by the Black Crowes (2008, Las Vegas), Train (2009, Phoenix), and this year Lifehouse performed live.

To those who were confused (as I was) about the hosting process for the SAP Insider conferences, I apologize. I hope this post helps clarify the points I was trying to make. As always, feel free to use the comment form to provide feedback or ask questions.

Here is a list of session from the BI track at SAP TechEd for today:

• Drive Insight to Action with Superior Extension Capability
• Building a Statistics Cockpit Using SAP NetWeaver Visual Composer to Proactively Monitor SAP NetWeaver BW Usage and Performance
• ASUG Influence: Introducing SAP BusinessObjects Advanced Analysis
• Best Practices and Tips for Best Performance of SAP BusinessObjects XI 3.1 on SAP NetWeaver BW
• Integrating SAP BusinessObjects Xcelsius and Web Intelligence reporting with SAP NetWeaver BW and SAP NetWeaver Portal
• Kraft’s SAP NetWeaver BW Accelerator Usage Decision Tree and Capacity Planning
• How to Design and Deploy High Performing SAP BusinessObjects Dashboard Design (Xcelsius)
• Embed and Integrate SAP BusinessObjects into Your Applications – Discover How To Save Time and Cost by Partnering with SAP
• How to Deploy SAP BusinessObjects Mobile
• SAP Business Objects BI Solutions Overview and Roadmap
• Low-Power Memory: Enhancing TCO for Today’s Server Environments
• Leveraging Live Office, Where Your Users Live
• What’s New in SAP BusinessObjects XI 4.0 for SAP BusinessObjects Enterprise
• Measuring Daily Health of Your Business Using SAP BusinessObjects Mobile
• SAP BusinessObjects Enterprise Performance Management Roadmap
• Newell Rubbermaid SAP BusinessObjects Explorer Implementation Success and Lesson Learned

Sessions start at 8:00AM and run until 6:45PM, and there are generally at most two BI sessions in any given time slot. There are dozens of sessions going on at any given time, but from a pure BI perspective there are some hours where the choices are a bit weak. For example, two of today’s sessions are roadmaps, four are related to NetWeaver, and one sounds suspiciously like a sales pitch for SAP consulting. 🙂 Seven of today’s BI sessions are offered by ASUG, one is from a partner, and the remainder are from SAP.

TechEd also offers two-hour sessions that offer a hands-on look at the products. Here are the BI sessions scheduled for today:

• Learn and Practice the New Multi-source Semantic Layer Modeling
• Learn and Practice the New Multidimensional Semantic Layer for SAP NetWeaver BW and OLAP Sources
• Technical Deep-Dive into SAP BusinessObjects Advanced Analysis, edition for Microsoft Office
• Two Hour, Hands-On Tour of the SAP BusinessObjects BI Solutions
• Extending the Value of SAP BusinessObjects Spend Performance Management
• Building Dashboards that Rock with SAP BusinessObjects Dashboard Design (Xcelsius)
• Best Practices for Using SAP BusinessObjects Web Intelligence with SAP NetWeaver BW, Today and Tomorrow

And finally there is one extended (four-hour) session as well.

• An Introduction to SAP BusinessObjects Planning and Consolidation, version for SAP NetWeaver

There continue to be discussions about whether there is a market or need for the SBOUC conference. I have often said that I favor the continuation of the separate conference, but basically what I am most concerned about is a continuation of the type and style of content delivered there. If the SBOUC conference were simply to disappear and nothing were done to enhance the offerings at TechEd I think that would be very disappointing. ASUG currently manages the SBOUC conference, and of course then already have a relationship with TechEd. As I mentioned above, they are providing a number of different sessions across different tracks including BI. If the content from SBOUC were moved to TechEd, would that be a benefit? Would it make it easier for folks to budget and decide which conference to go to if there was only one?

And given that, what is the point of the “Reporting 2010” conference later this month, which I just found out about this morning? If SAP is so much in favor of combining SBOUC with TechEd, why are they hosting their own “reporting” conference as well? Apparently there are several different conferences that SAP hosts throughout the year that focus on a particular topic. Is it so hard to understand why BI deserves a separate conference?

A clarification: This is not an SAP-hosted event. It is hosted by a third party conference group. So while there are SAP speakers presenting at this conference, this is not an SAP event. My apologies for any confusion caused by my original post.

Related Links

• Reporting – Planning – Analysis 2010, October 27-29, Orlando, Florida
• Financials 2011, March 8-11, Las Vegas, Nevada

It’s a bit weird. I can fly all the way across the globe to attend a BusinessObjects conference in Australia and not feel as bad as a two hour time difference in Las Vegas. Not sure how to explain that, but there it is.

SAP TechEd Opening Keynote

The keynote this morning was from one of the top technical folks at SAP: Vishal Sikka. There were three main points he talked about: HANA, the in-memory engine that will soon drive application code and not just analytics, mobility, driven by the Sybase acquisition, and cloud computing. All of these are interesting, but there were not a lot of big take-aways from a BusinessObjects perspective. It’s not that the tools were not present. The talk included a number of interesting demonstrations that included dashboards and Explorer content. The talk was (at least to me) aimed at a broader SAP-style of audience. Vishal also talked quite a bit about the NetWeaver platform. Again, interesting stuff but not as important to BusinessObjects customers. If you want more in-depth coverage of Vishal’s keynote I have included a link at the end of this post.

Day In Review

Unfortunately for anyone looking for additional “scoops” from TechEd, I then spent the next few hours talking to various contacts, both inside and outside of SAP. After lunch I went back up to my room to rework my demonstrations for my talk this evening. And take a nap. (See above note about time zones.)

Semantic Layer Design For Non-ERP Data

My session was from 5:45 to 6:45 and I really was not sure how many folks would show up, given the late time slot. The room held 170 people and it was more than half full (by my estimate) so I considered that a good crowd. I introduced myself and told folks what I would cover (relational universe design) and would not cover (cubes) to make sure everyone was in the right place. Nobody left, so I considered that a positive step. I also asked how many folks knew about BOB, and less than 10% of the room raised their hands. It was like the old days again! 😆

My talk was designed to share some of the power and flexibility offered by the current semantic layer. I suggested to folks in the room that since they were all running SAP, I could almost guarantee that they also had other databases within their enterprise, and BusinessObjects provided all the tools the needed to access that information. From there I jumped into my presentation, which was about one and a half days of the standard Designer training course condensed down to a single hour. 😯 I covered aliases, contexts, fan traps, chasm traps, and aggregate awareness. Yes, all in one hour.

At the end, I still had time for a few questions, and the first question I got was related to building a universe on top of cubes! 😆 I guess it goes with the territory.

I felt like the session went well. I even got the audience to sing the “super hero theme song” every time I saved the universe, so that was fun. 🙂

As a footnote, I had complained about the wireless earlier. This came out in the daily email summary:

ATTENTION HACKERS
We know it’s tempting, but please do not use devices like MIFI’s, personal access points, hubs, switches, etc. while at SAP TechEd. On Tuesday, the network team found multiple personal devices that were jamming the airwaves for SAP TechEd attendees, demos, and sessions. We are supporting over 2,000 concurrent devices on the network and can only provide the best possible service if everyone refrains from adding other devices to the airwaves. Thanks for your cooperation.

Liked the subject line for the paragraph. 🙂

Evening Activities

Tonight is the Demo Jam, and I am sure other folks will write about it in some detail. Folks get six minutes to go through a demonstration of a product or idea that they have, and the top demos (measured by applause) get the prize. Beer is served, so I assume there is an advantage to going on stage later in the evening…

I had a brief visit with some of the folks from the Mastering BusinessObjects conference while at Demo Jam. Early rumor is that the conference will be back in Sydney again this year (it was there two years ago) but I’m not sure that’s absolutely confirmed. I just wanted to report the rumor. 🙂

I did not stay long as (again, see first note in this post) I decided I needed some rest. And since the wireless was so bad this morning (I could not stay connected at all) I wanted to write up this first day post before it faded. Since I am done with my talk, I hope to spend more time visiting folks and seeing some sessions. By the end of the week I hope to be able to share some opinions and facts about how well BusinessObjects content is covered here, and what I think about the often repeated rumors that SBOUC and TechEd may be merging at some point.

If you’re planning for next year, TechEd is going to be in September.

Related Links

• Vishal Sikka’s keynote at SAP TechEd 2010

I have uploaded the PDF files for my two presentations from the 2010 SAP BusinessObjects User Conference. These are just the PDF files, the supporting materials (video clips and sample reports for the client tools session, and the VBA code for the designer session) are not yet available. I am working on reformatting the supporting materials for Internet presentation and will post them shortly.

As with previous conferences, I have posted these files for downloading on my conference download page.

One of the more interesting (and disappointing) tidbits I got from the folks talking about the new semantic layer (the Information Design Tool) coming in 4.0 is that there won’t be an SDK in the initial release. There may be one coming later, but it will potentially be java based rather than VBA. That means that my VBA experience is going to be less useful, and tools like my Schema Change utility and the soon to be posted Universe Change Log script that I showed at the 2010 BusinessObjects User Conference will soon not only be obsolete but we won’t have a mechanism to replace them. 😯

While on the subject of the SDK… I was asked multiple times when I would be posting my script from the conference. I discovered a few days before the presentation was due that there is a problem with joins when switching from one database to another. For example, we are in the process of switching one of our larger datamarts from DB2 to Teradata. I am going to write a more detailed blog post on that shortly, but let me say that my universe compare script was very useful during the process. But during the compare process I found that this join:

table1.table_1_id = table2.table_2_id

Got changed to this:

table2.table_2_id = table1.table_1_id

Of course both joins are functionally the same. But to my script they showed up as three different changes. Table 1 was changed from “table1” to “table2” while Table 2 was changed in reverse. And of course the join logic was reversed as shown above. So while this was not really a change, my script was recognizing three unique differences between the two universes, all related to that one join. I had not encountered this when running against two different versions of the same universe pointing to the same database, which is the expected use of the tool. I created it primarily to compare the DEV and PROD versions of the same universe. But I am trying to think about a way to update the code so that inverted or reversed joins are not detected as changes. If I can’t come up with something in the next few weeks, I will go ahead and post the code as I demonstrated it at the conference last week.

I generally have several goals when attending a BusinessObjects conference. In no particular order, they are:

• Make sure that my sessions are delivered effectively and provide value to those that attend
• See what is coming new from SAP BusinessObjects
• Reconnect with old friends and see what they’re up to
• Attend a few sessions and try to learn something

Maybe those are in the right order. 🙂 Both of my sessions were delivered on Tuesday which left me (in theory) free for the rest of the conference. I did manage to reconnect with some old friends as well as make some new ones. I did attend some sessions to see what’s coming new in the semantic layer in 4.0. I participated in the first-ever ASUG Influencer Summit, and will post more on that in a bit. I also worked with Bridgette Chambers (and many others) to finalize the agreement related to the new collaboration agreement between BOB and ASUG, which you can read more about in the announcement post on BOB.

I went to Epcot on Wednesday night and stayed until midnight. I got a bruise from somewhere, probably on my second or third mission to Mars. 😆

Ultimately due to the lack of wireless (something that many folks have provided feedback about) I did not blog much while there. That’s why the last two days are going to be wrapped up here, and will seem a bit short. It seems easier to write while I am in the middle of everything instead of back at home. But here goes. Continue reading “SBOUC 2010 – Day 2 + 3”