December 23, 2012

Setting up SSL for Tomcat and SIA in 6 Minutes

Setting up security on your BusinessObjects servers can be a daunting task. So... below is a script and a set of instructions that should have you up and running in 6 minutes (if you read quickly).

December 11, 2012

Sparkline Charts in Webi

Sparklines. They’re a great way to show a lot of information in a small amount of space. We’ve had them in Xcelsius and the BI Mobile app for a while now, but they’re not yet officially available in Webi. This trick will show you how to grace your Webi report with a sparkline.

November 24, 2012

Most Recent List in Xcelsius

Imagine a dashboard with a set of charts. Imagine this dashboard has a dropdown that allows you to filter the charts for a particular country. You select one country, check it out; then another, and so on. But switching between countries involves clicking a dropdown and finding a country in a list of 200. There must be an easier way, right?

November 9, 2012

Workdays Between Two Dates in Webi

You receive an order, you ship your wares. Now you want to track how long that process takes, excluding weekends. Here’s how:
=DaysBetween(RelativeDate([Order Date];Floor(DayNumberOfWeek([Order Date])/6)*(8-DayNumberOfWeek([Order Date])));RelativeDate([Ship Date];Floor(DayNumberOfWeek([Ship Date])/6)*(8-DayNumberOfWeek([Ship Date]))))-(Floor(DaysBetween(RelativeDate(RelativeDate([Order Date];Floor(DayNumberOfWeek([Order Date])/6)*(8-DayNumberOfWeek([Order Date])));(DayNumberOfWeek(RelativeDate([Order Date];Floor(DayNumberOfWeek([Order Date])/6)*(8-DayNumberOfWeek([Order Date]))))+1)*-1);RelativeDate([Ship Date];Floor(DayNumberOfWeek([Ship Date])/6)*(8-DayNumberOfWeek([Ship Date]))))/7)*2)

October 30, 2012

Disappearing Dashboard Panels

With only a certain amount of pixels at your disposal, it can be tricky to fit all the information you wish to display on your Xcelsius dashboard. This post shows a simple way to create a panel that is available to users when they want it, but can be hidden away when don’t.

October 21, 2012

Disappearing Dashboard Menus


When creating dashboards, screen real estate is a constant concern. You want to provide a simple, beautiful dashboard, but you also want to allow your users to slice and dice the data. In this post, I’ll show a simple technique for bringing extra content to a page without losing precious screen real estate.

September 6, 2012

Webi as a What-if Scenario Dashboard

At some point or another, you’re bound to come across the requirement to allow a user to adjust some values shown in a report to see how they affect the bigger picture. For example, what if my sales quantities increased, but my buy price and employment expenses went up? In this post, I’ll create a Webi dashboard that allows a user to adjust the figures over a year and see the effect these changes have on a final result.

August 7, 2012

A Beginner’s Guide to BI Services

There are plenty of posts out there explaining BI Services, but it’s difficult to find a true beginner’s guide. So the below is for those that are new to the world of BusinessObjects BI Services, or just want to get a better understanding of what's going on behind the scenes.

July 30, 2012

One Report, Many Folders

It’s a common problem, you have a folder structure in place that allows users to see only the content applicable to their region, division, department, etc. But there are some reports that should be visible across all regions (or divisions, departments, etc.). This post shows how to allow your users to see both their specific reports and shared reports, for a streamlined experience.

July 11, 2012

Toggle the Display of Text and Key in Webi

If you’re running Webi on BW, you may well have users that are used to being able to see either text or a key for an object. In this post, I’ll show you how to add a drop-down to your Webi reports that will offer your users this familiar functionality.

July 2, 2012

Navigating Notes

SAP notes and knowledgebase articles are a great source of information, but can be a little overwhelming if you don’t know your way around the interface.

June 18, 2012

BI Services with Crosstabs (Variable Columns)

BI Services are great. But they have a few weak points, and the one area they lose out to Live Office is their handling of crosstab data. That is, you need to know how many columns your Webi block will have in advance before using that BI Service in Xcelsius. In this post, I’ll show you a trick to get around this limitation.

June 9, 2012

InfoView Express (BOBJ SDK Demo)

The BusinessObjects SDK. A daunting thing, to be sure (for me at least). Recently I had the chance to spend a few weeks playing with it and had quite a lot of fun.
So I set out to create something useful, but what? InfoView and the CMC do everything, what more could I do? So I decided to do less. Much less.

June 1, 2012

OpenDocument Link Creator

OpenDocument is a great way to give simple access to your wonderful creations in BusinessObjects. But it can be fiddly to get the syntax right. So rather than just re-hash the manual, (which you've already read) and call it a blog post, I've put together a little link creator.

April 27, 2012

Creating Big Data

When it comes to learning and demonstrating BusinessObjects, it's important to have a good demo database. eFashion is great, and referred to in much of the documentation, but it's less than 10 tables and less than 100,000 rows.
Microsoft's AdventureWorks database is also good; it's got 70 tables, but still only about 120,000 rows.

In this post I'll show a quick trick to give you a few million rows of realistic data to play with.