Business Objects XI backups

A number of clients perform their backups in different ways. I always recommend the following:

  • Shut down all BOE services
  • Backup the CMS database
  • Backup the FRS
  • Restart BOE

This will give you a good full backup.

In addition to this, you can use the Import Wizard to create BIAR files. These can be done more frequently and will allow you to restore individual objects more quickly. If you are running XIR2, the BIAR process is manual. If you ar on XI3, this process can be automated via the command line.

In the main however, we prefer to recommend the use of version control tools such as EQM for restoring deleted reports or universes. You do have the latest production version in version control don’t you?


Business Objects User Conference – Texas

The next Business Objects User Conference is to be held in Dallas, Texas on October 20th to October 22nd.

Further details can be found here.

More data visualisation

More on one of my favourite topics at the moment – data visualisation.

Smashing Magazine – An excellent article discussing and demonstrating modern approaches to data visualisation. I’ve come across Mindmaps before and they are very intuitive. Newsmaps are a variation of heatmaps which I’ve blogged about before. These show different size boxes relating to a news item depending on the items populatrity.

Heat Maps – Smartmoney magazine have put together an excellent implemention of heat maps. This links shows a heat map of stock market companies and how they are performing today. Grouped into their respective categories, this map presents to the user a high level overview of how the market is doing, how specific sectors are doing, and how individual companies are doing. Unfortunately, if you look at it today (16th September 2008) it will be a sea of red due to recent market events. However, an excellent implementation of heat maps.

Olympic Medals – The New York Times presents an interesting graphical representation of the medals won at Olympics games, dating back to 1896. Use the slider at the top of the graphic to show the trend. The size of the circle is determined by the number of medals won. If you click on a circle, you can see who won those medals. Nice.

SQLBits III event

Following several weeks of miserable weather and washed out weekends, we finally had a glorious sunny Saturday. So what did I decide to do? Well, attend the SQLBits III conference of course!

Held at the excellent University of Hertfordshire campus, the event looked promising based on the agenda I had printed off a few days beforehand. As it was being held on a Saturday, I was half expecting a low turnout. I was pleasantly surprised to see a full car park, a very busy reception area, and several hundred like minded individuals.

I attended the BI session track. This covered a range of areas including Data Mining, Data Visualisation, the MS BI end-to-end stack, cube design issues and SSRS. The Data Mining session demonstrated how data mining techniques can be used within Excel spreadsheets without having to use cubes. Data visualisation covered many of the areas I have blogged about in the past, including Sparklines and bullet graphs. Delivered by a representative from XL Cubed, this was an interesting presenation.

This was followed by an excellent demonstration of MS technology delivering different types of reports into a Sharepoint front end. A lot of this was done of the fly and the speaker came across very well.

Users perception of reporting cubes were the topic of the next session. A number of cube issues were discussed in this session including time dimensions (YTD, QTD), scaling of data, etc. The presenter delivered a series of possible solutions to common cube design issues.

The final presentation was based on SSRS 2008 and covered some of the differences to SSRS 2005. Again, a handy session, although it did run out of it’s allocated time.

Regular refreshment breaks throughout the day, lunch at midday, and plenty of opportunities to speak to like minded people. I also managed to bump into a number of fellow bloggers including Chris Webb and Andrew Fryer. And the sponsor stands provided demos of their latest products.

The event was sponsored by Microsoft, Idera, Quest, XL and Hyperbac. I was particularlyl interested in the XL cubed product. XL cubed acquired Bonavista Systems and is now selling products which incorporate Sparkline and Bullet Graph technology into Excel. There was also a camera crew taking interviews with speakers and attendees throughout the day, so no doubt this will appear on a website at some stage.

An excellent event and very well attended. A big ‘Thank you’ must go out to the sponsors of the event, the organisers and the speakers (clearly idenitifed by their ‘Kermit’ polo shirts).

I’m looking forward to the next one!

%d bloggers like this: