Oct 28 2009

Calculation Options

Categories: 2009 GBN - Dallas,Report Techniques,Universe Design Dave Rathbun @ 6:00 am

When working with the reporting suite from Business Objects there are many different calculation engines. A report developer can create custom formulas or variables in Desktop Intelligence, Web Intelligence, and of course Crystal. A universe designer can build custom objects using database functions in the universe. An ETL architect can design special query transformations. So where do you do the work?

This post covers slides 6 through 9 from my 2009 GBN presentation titled “Return of the Variables” which can be downloaded from my conference page. Continue reading “Calculation Options”


Oct 23 2009

Calculating Business Days Between Two Days Via Report Functions

Categories: 2009 GBN - Dallas,Report Techniques,Variables!,Web Intelligence Dave Rathbun @ 7:57 pm

A frequently asked question on BOB is:

How can I calculate the number of business days between two dates?

The easiest answer is to use a calendar table with a flag for business days because that takes care of everything quite easily. You can even mark holidays along with weekend days and make the results more useful.

But suppose you don’t have a calendar table. Suppose you don’t care about holidays, you simply want to count the number of Monday – Friday days between a range of dates. Can you do that?

The answer is coming if you read the rest of the post. πŸ™‚

Note: This technique was shown in public on Monday at the GBN conference. I had written this blog post some time ago but waited to release it until after the presentation had been delivered. The presentation has been uploaded to my blog and is available for download from the conference page.

Continue reading “Calculating Business Days Between Two Days Via Report Functions”


Oct 22 2009

2009 GBN Presentations Posted

Categories: 2009 GBN - Dallas,Report Techniques,Variables! Dave Rathbun @ 7:24 am

I have uploaded the latest pdf files for my presentations from the 2009 GBN conference. You can download them from my conference presentations page. I did two presentations this year.

Return of the Variables

Presentation Abstract

It’s time to pull out some variables again as we revisit a popular topic from past conferences. Report variables can provide a more creative, efficient, and effective means of completing the detailed analysis required for your reports. The focus of this presentation is building documents, using report functions, and reviewing variable tricks that can be used to solve reporting challenges. The presentation this year will focus primarily on the SAP BusinessObjects Web Intelligence product and include some of the newest features that have recently become available, but there will be some goodies for users of prior versions as well.

Universe Models for Recursive Data

Presentation Abstract

Recursive data can present a special challenge to SAP BusinessObjects developers because SQL is not natively able to process the relationships. This presentation will show several different methods for modeling recursive data along with the pros and cons of each. All of the methods shown have been used on real-world projects. Attendees will gain a better understanding of the complexities of dealing with inventory models, organizational hierarchies, and other types of recursive data.

As time allows I will be adding detailed blog posts for each of these presentations. I am cheating a bit this year. πŸ™‚ I have already written two blog posts that detail most of the “Variables” presentation:

That leaves only the initial portion of the presentation to write up, and I hope to have it done fairly soon. The detailed posts for the Designer presentation will take a bit longer.


Oct 21 2009

GBN 2009 Day 3, It’s A Wrap

Categories: 2009 GBN - Dallas Dave Rathbun @ 5:09 pm

I am tired. When conferences are outside of my home area (Dallas) I generally spend the days at the conference, the early evenings doing conference-related items, and the late evenings catching up on work. When the conference is here in Dallas, I spend the days at the conference, the early evenings doing conference-related items, the late evenings catching up on home stuff, and the even-later evenings catching up on work. I hope the conference is somewhere else next year, I’m exhausted. πŸ™‚

Some highlights from my third day at the conference…

Webi 3.x Has Cool Stuff

I attended Sandy Brotje’s presentation called “What’s New for Me?” for my first session. I already knew quite a bit of what was new myself, but different people place emphasis on different features so I decided to see what she had to offer. I thought she did a great job of summarizing but also personalizing the new features that were important to her. I should send her a link to my blog post about losing an old friend because she didn’t know what the new measure icon was. πŸ˜‰

Explorer… Again?

I went to a presentation by Dallas Marks (check out his blog if you haven’t already) about Explorer. He did a short demo (using eFashion, imagine that! :lol:) but then went into the back-end process showing how to install it. I left a bit early because I ended the day with…

Recursive Data in Universes is Hard

… my final presentation of the conference. I am fairly certain I submitted a far more imaginative title, but what came back was “Universe Models for Recursive Data” instead. It was a bit misleading because only one of the four solutions I showed can be done completely in the universe, and it’s the weakest of the four solutions. I had a good crowd for the last session on the last day of the conference, they laughed at my recursive jokes, and I gave out a bunch of BOB hats.

Good times. 😎

So what’s next? There was a slide being shown as a backdrop during the keynote sessions that asked a question about whether there would be a Business Objects focused conference next year, and the answer provided was apparently a bit confusing. My understanding is that there will be a conference next year like this year (and prior years) but under the ASUG name. Since GBN is merging into ASUG it will no longer be the GBN Annual Conference but something similar with ASUG in front instead. I hope we can get more details out about this soon (like dates and the location) and will post here as soon as I hear anything concrete.


Oct 20 2009

GBN 2009 Day 2

Categories: 2009 GBN - Dallas Dave Rathbun @ 10:20 pm

It’s 10:00 pm, do you know where your Dave is? He’s at home, finally, after a long but interesting day at the GBN conference. I am going to again post a few highlights from today and save some of the in-depth thoughts for later.

Computers Evolve During Stressful Times

The keynote this morning was delivered by Vicki Farrell, the Manager of Marketing Strategy from Hewlett Packard. She presented a couple of interesting points, one of which was that computer technology seems to get the biggest boost during times of economic stress. It’s at this sort of time that people really start looking to get more out of technology as a way to make up ground. She finished out her presentation with a picture of the garage where HP started. (I am sure there is a rule from HP that requires that πŸ˜‰ )

Text Analytics Are Cool

I attended a presentation on text analytics that was interesting enough. I never seem to get anything that I can use in my job from these presentations, but the concept is one that I am quite interested in so I try to attend them. The presented talked about monitoring sentiment by scanning both internal project documents and external web sites. She did get a bit confused when someone asked about RSS; she thought that was some sort of sound file.

Semantic Layer Usability Testing Was Interesting

Unfortunately it was also covered by a non-disclosure agreement so I can’t talk about it. πŸ™

Too Many Universe Design Sessions

I say this with my own universe design session coming up tomorrow, but I really think we had too many sessions this year. The technology hasn’t changed that much since last year (other than some improvements in SAP BW support in 3.1) and I saw a lot of the same stuff in the few designer sessions I did attend. My stuff is not the typical Designer material so I hope it will be well received by the folks that manage to stay for the last presentation slot on the last day of the conference.

SAP Mentors Rock!

One of the best sessions I attended was delivered by fellow SAP Mentor Ginger Gatling from the SAP Labs. She did a great job of presenting – in less than an hour – what SAP is, what they do, what they had for BI before they purchased Business Objects, how the product suite fits together now, and ended with tips on how people with different Business Objects skills could leverage them in the new environment. Yes, all in one hour. And she was entertaining and energetic while doing it too. πŸ™‚

Catching Up With Old Friends is Fun

I have chatted with quite a few BOB members and other friends I have known for years through our common interest in Business Objects. That is one of the best parts of the conference for me every year. 😎


Oct 19 2009

GBN 2009 Day 1

Categories: 2009 GBN - Dallas Dave Rathbun @ 8:11 pm

Lots of interesting things happening at the GBN conference today. I will share a few nuggets now, many of which I hope I will have time to expand on in the future. In no particular order…

Data Federator Combined With Semantic Layer

One of the things I heard last week was reiterated in public at the GBN conference today, that being that in XI 4.x (no scheduled release date, but could be 2010) the Data Federator product will be embedded directly into the semantic layer. What does this mean? Among other things, it means we can have multi-source universes.

Explorer (Accelerated) Is Still Hot

The keynote from John Schwarz featured yet another demo of the accelerated version of Explorer.

Xcelsius Is Still Hot

It’s hard to turn around without seeing another presentation for Xcelsius.

Old Stuff Still Works

My presentation had slides in it that I lifted from the very first Variables presentation in 1997. It still works. Steve Krandel updated a presentation from five years ago. It still works.

Text Analytics Should Be Hot

Several years ago Business Objects acquired a company that did really cool stuff in the unstructured data (text analytics) space. They should be getting more press; their systems have been integrated into Data Services now. I am planning on going to a text analytics presentation tomorrow.

I also signed up for a “usability session” on the new semantic layer tomorrow. It should be another good day.


Oct 18 2009

It’s Not Always The Report Writers Fault

Categories: General,Rants Dave Rathbun @ 11:08 am

I recently attended the 2009 TechEd conference. Here is a copy of the top portion of the session evaluation form. Notice anything that might cause a problem?

I know that form was reduced to fit the size of the page so it may not be immediately obvious what I think the issue is. In order to make it more clear I have posted a larger view of the specific survey choices.

Look at it for a bit and when you’re ready … Continue reading “It’s Not Always The Report Writers Fault”


Oct 16 2009

SAP TechEd 2009 – Wrap Up

Categories: 2009 SAP TechEd Dave Rathbun @ 3:24 pm

Score one for the Phoenix airport for having free wireless… why can’t more airports do this?

I am on my way home from TechEd 2009. Overall it was a good conference. As always, it seems that the contacts I made and conversations I had were as valuable (if not more so) than the presentations I attended. As mentioned earlier, I was able to sit in on a “strategy session” for the semantic layer, which was quite interesting. There are a number of changes coming that are apparently already in the pipeline, but we didn’t stop there. We talked about all sorts of possibilities. Some folks might not remember that the semantic layer concept was one of the very first patents that Business Objects was awarded. It’s nice to see (at least in my opinion) that it’s finally getting some attention. We have been coasting along for years. As I have said more than once, it means that they did a really good job with the universe concept when they revised it for version 4.0 over 10 years ago, since we’re using essentially the same technology today. If even half of the ideas we talked about come to production in the next two years we’ll have some really nice updates. Finally. πŸ™‚

Last night I attended a presentation about TREX. When I got there, it seemed that the presentation wasn’t exactly what I thought it was. (That’s my own fault, instead of a conference backpack this year SAP gave everyone a thumb drive with all of the presentations included on it. I should have reviewed it first.) Despite that, it turned out to be quite interesting. For those that haven’t heard about it yet, TREX seems to be the name for the in memory technology used by the accelerated version of Explorer. I was expecting to hear more specifics about that, but instead I found out that you can use the same TREX technology to power an enterprise search. For example, one of the items they showed in the presentation was how they pointed the search indexing process at their corporate shared drive. When the index process was complete, they had their own internal search engine that was lightning quick due to the in-memory storage of the search index. Very cool stuff.

I am wondering if I can use that to index my corporate Business Objects documents and such as well.

After I get home, I get a brief rest and then dive into the GBN conference which starts officially on Sunday with a welcome reception. At some point I might even have to get some work done.


Oct 15 2009

Everything-Accelerated

Categories: 2009 SAP TechEd Dave Rathbun @ 7:33 pm

Interesting footnote in a presentation on the accelerated version of Explorer… the presenter said something along the lines of, “… and of course eventually we want to accelerate everything.”


Oct 15 2009

Interesting Future for the Semantic Layer

Categories: 2009 SAP TechEd,Universe Design Dave Rathbun @ 4:44 pm

All I can say is “wow, I can hardly wait” for some of the features discussed in a private strategy session for the semantic layer. I need to find out how much I can say (and when) before I say much more on a public blog though.


Next Page »