Business Intelligence Archive

Comparing BI Dashboard Solutions: Hummer vs. Fit

Comparing BI Dashboard Solutions: Hummer vs. Fit

My youngest son recently learned to drive and he now takes himself to school three times a week in my wife’s orange Honda Fit. For those not familiar with this awesome sub-compact, it is a nifty 38 mile per gallon cute little dynamo of a car. It is practical, economical, environmentally friendly and, most importantly of all, my wife adores it.

So the other night, my son decided to chat with me about cars.  This was mainly due to the fact that a girl from his junior class parks in the spot next to him driving a huge black Hummer.  He always seems to arrive at the same time as she does and, as he put it, “It’s just not cool stepping out of a little orange car as she climbs down from her big black Hummer.”

I explained to him that you really should not compare a Hummer with a Fit. They are two very different vehicles with different capabilities. A Hummer would be an ideal vehicle if you were planning some “off-roading” in the desert but for driving to school it is expensive, bad for the environment and not very practical.

Although, in many ways we are conditioned to compare, we often end up comparing items using different criteria and coming to vastly different results.   Comparing the Honda Fit to the Hummer may put the Fit ahead in terms of fuel efficiency, maintenance cost, price and many other areas but many people would still pick a Hummer over a Fit to drive.

So when people come to me and ask me to compare Xcelsius to Qlikview, Dundas, Corda or other BI dashboard solutions, my first response is usually to first ask about the solution they are trying to implement and then ask about what will be their main criteria for selection.

Usually, the bigger issue is the data and metrics that they want to compare. These often do not exist in a form that can easily be used in a dashboard solution and a Data Mart may need to be created first to do any meaningful comparisons. The quantity, quality and frequency of change of the data are also all important factors to be considered.

The dashboard, like most user interface solutions, is usually the tip of the iceberg above the water and the larger and more important consideration is that mass of data under the water. We tend to get caught up in comparing features of dashboard tools and the tool vendors love to show their competitive analysis matrices and reports from “independent” analysts and organizations that they pay to create for them.

Yes, factors like ease of use, dynamic visibility, underlying technology and price are important too but if you focus on the solution itself then the weighting of these items will become more apparent and fall into their rightful place. If the solution is too difficult to use or too expensive, then you can eliminate it from consideration right away.

I have always been a great believer in “try before you buy” but more importantly in doing that “trying” in the context of the solution you want to create. So, in my opinion, the best way to compare dashboard solutions is to set up a meaningful pilot project and see which one truly meets your needs the best.

No, I am not going to encourage my son to test drive a Hummer to see if it is the best vehicle for him to drive to school because there is no way he could ever afford to own and run a vehicle like that so we can eliminate that one right away. Besides, there are better ways to impress the girls.

Photo: ca. 1999 — Apple and Orange — Image by © Royalty-Free/Corbis – downloaded from Microsoft clipart online.

Top 5 Predictions for Business Intelligence in 2011

Top 5 Predictions for Business Intelligence in 2011

Well 2010 saw not just a strong recovery for the I.T. sector, but some very healthy growth and, once again, Business Intelligence was right at the forefront.

So what can we expect to see in 2011?

BI Vendors and Industry Analysts are predicting all sorts of things for 2011 but they tend to look at the world based on technology announcements along with CIO and CEO interviews and surveys. Not that there is anything wrong with this, but the battle plan of the generals often tends to “miss the mark” in terms of the reality in the trenches.

So I thought I would take a stab at making my own predictions for 2011 for the world of Business Intelligence based on my own experiences both on the front line and as an observer in the general’s war room.

Prediction 1:  Visual Dashboards will remain dominant as the BI User Interface of choice. They will expand beyond their traditional tactical and strategic usage and be seen more in operational BI applications as backend performance with in memory analytics and caching continues to improve. Tools like Xcelsius will increase their presence due to both their visual appeal and ease of use.

Prediction 2: Data Governance will be a priority as both large and mid-size companies are compelled to accurately consolidate and clean up their data for more relevant and precise business intelligence. Data quality, integration and master data management solutions will become mandatory in many organizations.

Prediction 3: The race for optimal mobile business intelligence solutions will get into full swing. With a plethora of new tablet devices and new BI mobile software products, I anticipate a year of experimentation and we will need to wait another year before the real market leaders are determined. Watch out for Roambi (http://www.roambi.com/)   because they are definitely heading in the right direction.

Prediction 4: Relational database Data Marts and Warehouses will continue to be the BI repository of choice in 2011. OLAP cubes will remain a niche market and the new in memory databases are just too immature and too expensive to have a serious impact this year. There will probably be lots of hype but until this new technology is affordable to the masses, it will have minimal effect. Data Mart projects will continue to thrive in the small to medium enterprise space.

Prediction 5: Business Intelligence for Web and Social Media content will be hot and in demand. The need to perform BI against the predominantly unstructured data sources of the web has never been greater as more business and institutions both grow their web presence and web driven marketing. BI tools and solutions that can quickly analyze this data both quantitatively and qualitatively will see fast growth and adoption in 2011.

So there it is and now let’s see what happens.

Wishing you all a prosperous and healthy 2011 and may all your Business Intelligence dreams come true!

Dashboard Development Services

Dashboard Samples

Photo: copyright Paul Grill

BO XI 3.1: To Upgrade or Not to Upgrade?

As SAP announces the “ramp up” or controlled release for SAP BusinessObjects XI 4.0, some companies who are planning to upgrade to BO XI 3.1 are wondering if they should now wait.

The simple answer is “no” and there are many good reasons to upgrade to XI 3.1 as soon as possible.

Firstly, BusinessObjects XI 3.1 has been the general release for a couple of years now and has proven to be a stable and solid platform. It brings a new version of Web Intelligence with the Rich Client (offline) capability with access to external data providers like Excel. It also has other features, previously only available in Desktop Intelligence, like the fold/unfold feature and stored procedure support through the universe. It adds new functionality also like the ability to track data changes between versions, contextual hyperlinking and use of drop-down selection boxes for prompts.

At the same time, XI 3.1 fully supports Desktop Intelligence reports unchanged which is quite significant when you consider that there will be no support for Desktop Intelligence in XI 4. This means that XI 3.1 will be the last BusinessObjects release to support Desktop Intelligence or the old Full Client reports.

BusinessObjects XI 4.0 will be a major new release with a lot of new functionality some of which will be available in the first 4.0 release and some which will be released later in service pack updates. It will be a 64-bit software application. It will have a new semantic layer that will combine the capabilities of the old BusinessObjects universe and Crystal Business Views and with a slew of new functionality including support of OLAP (MDX) data sources like SAP BW and MS OLAP cubes. The old BusinessObjects Universe Designer will remain supported in XI 4 for compatibility and easier transition.

There are new functionalities and capabilities in Web Intelligence, Xcelsius, Crystal and other content providers including taking advantage of the new semantic layer and universe design tool. There are two versions of Crystal – Crystal Enterprise which is new and uses the new semantic layer and Crystal Reports 2011 which is a continuation of Crystal Reports 2008. There is a new OLAP analysis tool called Advanced Analysis which replaces Voyager and there are significant improvements to Data Services and the BOE infrastructure functionality.

There will also be a new utility to move the contents of your old BusinessObjects content to XI 4. The Import Wizard is effectively replaced by this new tool called the Upgrade Manager Tool. This works for upgrades from XI 3.1 and the plan is to also be able to upgrade from XI R2 with security model changes. There is no upgrade available from earlier releases meaning you would need to move to XI R2 or XI 3.1 before moving to XI 4.

The ramp up will probably last 3 to 6 months so the general availability of XI 4.0 is expected sometime between February 2011 and May 2011. It is unlikely that the first service pack will be available until late in the year and most existing BO customers will probably not look at moving to XI 4 until 2012 or 2013 (based on previous trends).

For these BO customers still using Desktop Intelligence, there will be the added consideration and work of converting or replacing their old reports with Web Intelligence which for some may be a considerable effort and cost.

According to information disseminated at the ASUG BO annual conference in October, in addition to Desktop Intelligence, the following other existing BO XI products will be end of  life :  Voyager, Encyclopedia/Discussions and Performance Manager.

Historically, the current and immediately prior software releases tend to be actively supported for all software issues which would suggest that at some point in 2011 only XI 4.0 and XI 3.1 will be considered the actively supported releases.

Taking all of this information into consideration, it does make sense to upgrade to BusinessObjects XI 3.1 in the coming months if you have not done so already.

Beauty is in the Eye of the Beholder

Beauty is in the Eye of the Beholder

Several years ago, I saw an exhibition of surrealist paintings in Paris including works by Salvador Dali and Joan Miro. I found the Dali paintings visually stunning as well as fascinatingly compelling whereas I had a hard time understanding the Miro ones. Others, who were with me, expressed the complete opposite opinion and loved the Miro work but had little time for the Dali pieces.

We all have different likes and dislikes to visual images whether they are paintings, cars or even business intelligence dashboards. I can personally testify to the dashboards since our company has developed over 400 of them in the last four years and they come in all shapes, sizes and visual tastes. I remember one particular dashboard that we developed for a transportation company that I thought was very visually stunning and provided multiple levels of drill down and some very powerful “What if?” scenarios. While the manager at the company also liked it a lot, his director felt it was not stunning enough and wanted different colors and more 3-D components. They both felt the dashboard met their functional needs but for the look it really just boiled down to a matter of personal taste.

The beauty of a dashboard tool like Xcelsius is that it allows you to design and cater to all these different tastes. You have a wealth of components, colors, themes and templates available and, if this is still not enough, you can develop your own.

While some people prefer simple dashboards with clear sharp components, others may prefer a more complex and richer look. If you do not like pie charts and certain colors, you do not have to use them.

Dashboard design is an art but the key to designing an effective, as well as a visually pleasing, dashboard is not to read books about the subject and it is also not to hire a graphic artist. The key is to sit down with the people who are going to be using the dashboard and to understand what they want to see and how they want to view and interact with it. While this may sound too simplistic, it is not. Of course, there can be room for visual enhancement and “cool” features but only if they serve a purpose.

There are many dashboard products on the market today that provide limited views and components so that you often have to force fit your requirements into what is available within the product. Xcelsius, on the other hand, allows you to design and create dashboards in an almost infinite number of ways and you are only limited by your imagination (or your user’s requirements).  As to how they look, it is doubtful you will ever please everyone but remember that beauty is in the eye of the beholder.

For a gallery of Xcelsius dashboards designed by INFOSOL and defined by customers, visit INFOSOL’s Dashboard Gallery

Missing Leo Apotheker

Missing Leo Apotheker

There was a lot of trepidation amongst the BusinessObjects community when SAP acquired Business Objects in January 2008. We had all seen how Oracle had consumed Hyperion (which had, in turn, consumed Brio) to the point of losing its identity as an independent BI solution. The question was would SAP do the same to BusinessObjects?

On the day of the acquisition, I was attending a joint sales and partner meeting for BusinessObjects in Las Vegas listening to a mix of top Business Objects and SAP Executives delivering presentations to motivate sales for the coming year. There was really very little of substance until this man named Leo Apotheker took to the stage. He was engaging and passionate as he explained that Business Objects would remain an autonomous division of SAP so that it could effectively continue to sell Business Intelligence to all. He then went on to explain who SAP was and the core values of the company and how those would benefit the BusinessObjects employees, partners and product suite.  He painted an exciting vision of both the direction for SAP and BusinessObjects. I believe he impressed and inspired a lot of people in the room that day.

The global financial crisis followed later that year and into 2009 and Apotheker had his work cut out for him to steer SAP through a difficult time but he continued to push Business Intelligence to the forefront of SAP as well as actively support the Sustainability solution initiative within SAP.

So at the beginning of 2010 as we emerged from that difficult period, I was both shocked and sad to see Leo Apotheker leave SAP.  Of course, what he put in place has borne remarkable results with now more than 50% of SAP’s license revenues coming from Business Intelligence (not bad when you consider SAP was eight times larger than Business Objects at the time of acquisition) and SAP a clear leader in the Sustainability solution arena.

Leo Apotheker is now the CEO of Hewlett-Packard ( a company eight times larger than SAP – HP Press release ) and I think they are very fortunate to have such a visionary leading them. Unfortunately, we will not see how much further he could have taken SAP but, from where I sit, he certainly set them on the right track.

In searching for a picture to post on this blog, I found the following blog post from Feb 7, 2010  http://www.enterpriseirregulars.com/12079/news-analysis-saps-ceo-leo-apotheker-resigns/ which has many links including one to the official SAP press release.

Kimono Starts to Open on BusinessObjects XI 4.0 at ASUG BO Conference

Kimono Starts to Open on BusinessObjects XI 4.0 at ASUG BO Conference

The 2010 ASUG BusinessObjects User Conference provided a lot of interest not just for the 1,100 registered attendees but also for the additional 600 attendees of the SAP Fall Focus who shared the same venue. Judging by the number of attendees in the various sessions, it appeared a large number of SAP Fall Focus attendees decided to attend the BusinessObjects tracks. The same was true in the exhibit area as many of the BusinessObjects sponsors were swamped with excited and interested customers.

This year Xcelsius dashboards shared the limelight with Mobile Business Intelligence in terms of the most popular topics being discussed amongst attendees.

There was also some buzz around the new BusinessObjects XI 4.0 release promising to be the first truly integrated business intelligence platform. While there were a few small demonstrations of some of the new XI 4.0 products in the general session, most of the other sessions stuck to slides and pre-recorded Camtasia demonstrations.  With the release moving to “ramp up” stage in November, the kimono was only half opened on some of the new features and functions. These included the new Data Services that will now incorporate Text Analytics in addition to Data Integrator and Data Quality in a single engine solution. Also, there is the new Universal Metadata Layer that not only combines Business Views and Universes but also now provides direct access to Multidimensional OLAP data sources.

Part of the integration approach with XI 4.0  is to provide common services across all the main content provider tools like Crystal Reports, Web Intelligence, Xcelsius, Explorer. These include a common query panel for accessing data through a universe so in the new Xcelsius Enterprise 4.0 developers would have access to universe objects while building the dashboard.

An updated Web Intelligence brings new charting libraries from the Explorer product and an update Crystal Reports delivers a new grid view with drag and drop on graphics capability.

Common platform services like Auditing and Life Cycle Manager now extend across all the content provider tools including Xcelsius.

SAP’s new solution for in-memory analytics, known as HANA (High performance ANalytical Appliance), was also discussed.

Once the ramp up period gets underway, we will have a better chance to more thoroughly explore the new features and functions but based on this sneak preview, there appears to be some promising new functionality in XI 4.

Xcelsius Will Always Be Xcelsius

Xcelsius Will Always Be Xcelsius

So what’s in a name? Some people will tell you “everything” while others will tell you it depends on what you are naming.

Some products have not only become defined by their name but have been so successful they end up defining all products of the same type like “Kleenex” and “Band-Aid” .  Others have found out that their product name can end up portraying the wrong image like Chevrolet’s Nova car – “No va” meaning “it doesn’t go” in Spanish! The French company Bull Computers also had a hard time with its “Bull” named products in North America.  However, Bull also launched a clever marketing campaign around the ambiguity of its name entitled “Know Bull” which did get some attention.

At this year’s Sapphire, Sir Richard Branson told this great story of how when he went to register the name “Virgin” for his company in the UK, the company registration official turned it down because they deemed the name as rude. So Branson returned the next day with a dictionary showing the definition of “virgin” as being pure and they accepted it.

So I have been somewhat intrigued about recent forum discussions surrounding SAP’s decision to rename Xcelsius – their amazing and very popular dashboard product.

Xcelsius already had some name recognition when Business Objects acquired Infommersion (the original developers) in November 2005 but then proceeded to rename it Crystal Xcelsius. This resulted in a lot of confusion as people started to relate the product to Crystal Reports and thought it was an add-on to this report writer product.  So when the next major release was developed, the decision was made to drop the Crystal name and so Xcelsius 2008 came to market.

For the last two years Xcelsius has become one of the most popular and prolifically used BI dashboard products in the marketplace and its name has become synonymous with data visualization and dynamic dashboards. 

So why would you take this very well known product with such a cool and catchy name as Xcelsius and rename it SAP Crystal Dashboard Design or SAP Enterprise Dashboard Design?

Well apparently this is because SAP uses a “master brand strategy” where SAP is the master brand and the product brand name takes a back seat. 

So why not SAP Xcelsius?

Well this is because SAP also uses “descriptive naming” for all its products so in the case of Xcelsius, the back seat has been completely removed!

Since “SAP Crystal Dashboard Design” is so long, it is bound to become abbreviated. However, I doubt this will be shortened to “SCDD” since a Google search points you to the “California State Council on Development Disabilities” .  It is more likely to become “Dashboard Design” since that is the new descriptive product name.  A Google search on “Dashboard Design” comes up with about 2.5 million results starting off with Qlikview, followed by Tableau Software then Corda and SAP Crystal Dashboard Design comes in at about number 14.  Interestingly, there is little ambiguity when you search on “Xcelsius”.

Translating Dashboard Design into other languages may also prove interesting.  Xcelsius will always translate into Xcelsius in all languages and I have a feeling the name will persist. At the end of the day, it is not just the name that counts, it’s the product itself. Xcelsius is as unique as a product as it is as a name. I will never forget that day in 2005 when I first saw it and was totally blown away. Infommersion created something truly amazing and ahead of its time. It remains top of its class and, for me, Xcelsius will always be Xcelsius.

Winners of 2010 Best Xcelsius Dashboard Awards Announced at IBIS 2010

Winners of 2010 Best Xcelsius Dashboard Awards Announced at IBIS 2010

As Xcelsius becomes more widely used and more mature, the level of complexity and creativity in its usage in Business Intelligence applications appears to grow exponentially.  This was the third year of InfoSol’s Best Xcelsius Dashboard Awards and there was no shortage of great dashboards on display at IBIS 2010 at the Ritz Carlton, Laguna Niguel, California.

IBIS 2010 Winners

Most Valuable Dashboard SPX Service Solutions Detroit, MI
Most Innovative Dashboard United Educators Washington, DC
Best Business Dashboard Aluchemie Rotterdam, Netherlands
Most Xcellent Dashboard ARI Mt. Laurel, NJ

 

SPX wins Most Valuable Dashboard

This year’s winner of the Most Valuable Dashboard was SPX Service Solutions who developed a series of complex dashboards to provide on-line interactive views of Global Strategic Customers and Line of Business P&L’s for company executives and financial managers. The data was retrieved from an SAP BW (Business Warehouse) and delivered comparisons and analysis never previously available.  The number of possible comparisons and drill-downs is huge and created some real challenges for the BI/BW team at SPX in terms of the amount of data to be retrieved. However, SPX overcame the data quantity and performance hurdles by using InfoBurst XDS with its Intelligent Caching.

The Most Innovative Dashboard Award is for the dashboard that is designed and developed in an innovative way or for an innovative solution.  United Educators, who provide insurance to educational institutions, needed a solution to enable their clients to Self-Serve and Leverage Policy Data to make informed decisions.  The United Educators dashboard application was certainly an innovative solution with its peer selection function that retained anonymity of the institutions being compared. Also, the design using selection /de-selection of multiple peer groups and write-back to prevent users “gaining” the system was unique and creative.

Best Business Dashboard won by Aluchemie

The Best Business Dashboard was awarded to Aluchemie, a manufacturer of anodes needed for the electrolysis process by which aluminum is extracted from ore, based in Rotterdam in the Netherlands. They were looking for a way to get Team Leaders, Production Managers and Executives excited about the roll out of their Manufacturing Execution System software, used to manage and monitor work-in-process on the factory floor. Xcelsius was the answer and they created a comprehensive set of options in a multi-tab dashboard with more than 120 different dynamic graphs showing trend analysis along with shift-by-shift and day-by-day comparisons of key production line metrics. The dashboard revolutionized their manufacturing reporting and brought to light critical production issues that could be seen clearly for the first time.  As one Team Leader put it, he felt like they were finally, “coming out of the Stone Age”.

ARI receives Most Xcellent Dashboard Award - IBIS 2010

Last but not least, the Most Xcellent Xcelsius Dashboard was won by ARI, an international fleet Vehicle Leasing and Management Company.   ARI already had the ability to compare and analyze key life cycle metrics of any vehicles through their existing customer portal but they wanted to make it more visually dynamic and add even more useful functionality. They used Xcelsius to create a visually intuitive interface with picture icons, dynamic sliders and a lot of pizzazz.

ARI’s Dashboard Prototype was shown at a key trade show and received rave reviews.

Representatives of the winning companies received their prestigious glass pyramid awards and also participated in a customer panel to explain how their dashboards were conceived and how their respective businesses are benefitting from them.  In addition, three of the winners also presented insightful case studies on their dashboards.

Xcelsius Dashboards – Best Practices – Data Layout

In addition to the Xcelsius Dashboard Maintenance – Best Practices – Using Labels in Excel I wanted to share other important aspects of making Xcelsius dashboards easy to maintain and for other developers to understand.  One such practice is having some kind of conformity in your approach to how you lay out the data for your Xcelsius project. 

In this blog I will discuss 2 methods, both of which are valid and are useful ways to organize dashboard data.  Deciding as an organization which approach you adopt can help with the process of taking up someone else’s project. 

 Some Xcelsius developers like to use a method of having all the data that is being used in the dashboard on one (or more) tab/s of the Excel spreadsheet, and then as you need to use data for display, using a series of vlookups or match & index functions for displaying data on charts, which they layout on other tabs of the spreadsheet.

My preferred method is to spread the layout in such a way that the names of the Excel tabs generally correspond to the functional area on the Xcelsius dashboard, perhaps even the same name of the Xcelsius  tab (Either the Tab Set Container or the Label based menu, is what I’m thinking of), so that all the data being expressed on that “page” of the dashboard is on one tab in the Excel spreadsheet behind the scenes. 

  

I like to have the data insert & any manipulations I have to do for expressing that data nearby the loaded data, so that it is all in one place & I can find it easily.  The only difficulty with this is when you have many components on one “page” or you have to create several aggregate levels to display.  Spreading it out & spacing it can become an issue, and this is where again, labeling the spreadsheet is so important.  (But aren’t we glad that if we move data around on the spreadsheet that the links follow, for those of you who have been using Xcelsius since the 4.5 days!). 

This approach, of course, assumes you have the aggregated data to work with!  Which leads back to my previous blog regarding data connectivity options.   If I have to use QaaWS, I end up having to do a lot of manipulation in the universe to get the data to look or be ordered the way I want to use it in Xcelsius.  I usually have to end up making many of what I call, “dimensionalized measures” when I want to end up with a crosstab result.  So I have a measure for Jan Sales, Feb Sales, etc.  Very tedious.  Sorting is another  issue that is often easier addressed in the universe, but also can be labor intensive.  

Live Office gives me the option to create crosstabs and sort the data in any way I wish and I can also have multiple tabs to aggregate the data at different levels (YTD, MTD,  past 30 days, etc).  The problem that I so often bump into with this approach is the amount of data when we get down to the detail level.  We have all experienced poor performance any time we go over the 512 row default and horrible performance when we approach 1000 rows. 

All of these are reasons why I enjoy using the InfoBurst XDS or XDM option, as it addresses all these issues, plus gives me many more options.  The Intelligent Cache syntax of this tool is by far the most exciting feature, in my opinion.  Using their syntax, I can pass parameters to the XML url call and only return the rows of data I wish to display.  For example, within my xml url call, I can add syntax that returns …. YEAR=2009;DIVISION=HPD;DEPT=23.  This ability to extract just the rows of data I want to display helps keep my dashboards very responsive, since I am not loading it down with too much data.  It also gives me the ability to go to a much more detailed level than I would have been able to with QaaWS or LiveOffice.

XDS or XDM also has syntax to return unique values of a particular column from an xml data set which I can use for  my selector.  My selector will always have accurate values, as it is loaded from the current xml cache, rather than from a hard-coded list in my Excel spreadsheet which may not be up-to-date.

And, I have the flexibility to create these large XML data sets from a Web Intelligence document or by writing a query, directly to the database, or even from an Excel spreadsheet, and any combination of all three!

Europe Trip 2010: Day 8 Denmark – Vikings and Excel Post-Processing

Europe Trip 2010: Day 8 Denmark – Vikings and Excel Post-Processing

I arrived late at night at Copenhagen airport and headed for the taxi rank to get to my hotel. As I exited the terminal, there was a large sign pointing to “Danish Taxis” to the right and “Swedish Taxis” to the left. Not understanding the difference, I figured I should opt for the Danish taxis since I was in Denmark.  As we drove to the hotel, I asked the driver about the Swedish taxis and he explained that they were cheaper but they take you to Sweden so I guess I made the right choice!

I checked in at the Kong Arthur Hotel (Kong being King in Danish) and made it to my room where this huge modern painting hung above my bed. I have included a picture since it will have different interpretations to each viewer.  At that time it was saying to me “No matter how tied up in knots you are, come to bed”. In the morning, I noticed there was both the outline of a man and a woman in the picture and I had a totally different interpretation.

Although I did not see a lot of Denmark in one day, I did get to meet quite a few Danish people in my meetings and learned that Denmark is the home of Lego, Lager beer, ham and Vikings. I also noticed that the average Dane is significantly taller than the average European – must be that special beer and ham! 

I was visiting one of the largest companies in Denmark where a couple of the divisions use BusinessObjects for their Business Intelligence. They were interested in finding a better way to schedule, publish and distribute their reports so I showed them a demonstration of the new InfoBurst 2009 along with presenting a few customer case studies. They were particularly excited about the ability of InfoBurst to apply Excel macro post processing. It seems they, like many other companies, have large numbers of Excel users that want all their Business Intelligence reports delivered in Excel format but publishing reports directly from BusinessObjects to Excel does not provide all the features in the Excel output that they want delivered to the user. For example, one customer wanted to make use of data grouping and outlining within Excel for one-click collapse and expansion of individual data groupings in the report. In addition, they wanted each and every data group and outline to be automatically collapsed in the initial delivery of the report – keeping the report compact and easier to view. This simply cannot be done publishing from BusinessObjects to Excel but with InfoBurst 2009, you can execute a VBA macro following report production and produce a revised version of the report for publishing.

This caused great excitement amongst my Danish audience and there were smiles and vigorous hand shaking at the end of the meeting.  I think they really appreciated the logical building block of adding the Excel post-processing – just like Lego!