SAP BI4: Override OLAP Connections in Promotion Management

Posted by

The Promotion Management corner in the SAP BusinessObjects BI Platform CMC is still a bit of a strange place for us coming from the SAP BW world. I really like the fact that you can use a single promotion job to promote a report again and again after each change. In SAP BW that would require a new transport every time. But, something as the Overrides Settings is still a difficult to get through and set up. The official admin guide for the BI4 platform mentions it briefly, but does not explain it good enough.

Until we had this configured we had to manually reconnect each SAP BW BEx Query in a promoted Webi report. I wrote about this annoying situation before.

With an override setting on an OLAP Connection to a SAP BW system, we can make the connection change (or better: override) its settings when promoted, so it connects to the right source system. Say we have two SAP BusinessObjects Platforms (BOTest and BOProd) and two SAP BW systems (BWTest and BWProd). We want the OLAP Connection on the BOTest environment to connect with the BWTest system. The connection on the BOProd environment should connect to the BWProd system. So if we promote a Webi document that uses this OLAP Connection from BOTest to BOProd, the Webi should load data from BWProd after refreshing it on the BOProd environment.

Now, how can we set up this override thing?

1. Log in to the CMC of the SAP BusinessObjects BI Platform that acts as the ‘source’ (where you want to promote from).

2. Make sure you have an OLAP Connection set up on your SAP BusinessObjects BI Platform. You can create this in OLAP Connections.

Read More

Audiobook: The Martian (Andy Weir)

Posted by

themartianI listened to a great sci-fi audiobook last week: The Martian by Andy Weir. The plot is that a human mission to Mars goes horrible wrong a few days after arrival. The crew has to evacuate when they get in a big dust storm. During the evac the main character Mark Watney is heavily wounded, and believing he didn’t survive it, the other astronauts leave Mars.

Imagine being the only person on a planet, with broken machinery, no way to communicate and very limited food. What would be your plan?

Watney writes a log of all of his experiences and tells us all about the science and calculations he uses to fix things, create water and how to grow food. On Mars! Of course the story also switches to what is happening at NASA back on earth and to the returning spacecraft with the other astronauts.

The narration of this audiobook is excellent. Even when I arrived at home I stayed in the car for a few minutes to finish a chapter or a section of the book. Regarding the story I like the fact that there is no unnecessary/unwanted deviation from the core storyline. So no romantic bs woven into it.

In 2015 a movie will be released based on this novel. Director is Ridley Scott and Mark Watney is portrayed by Matt Damon. Looking forward to that one!

The Martian – Andy Weir – ISBN 978-0091956141 – Audiobook version

Cutting the cable: One year later

Posted by

In the summer of 2013 we made the decision to cancel our expensive cable subscription. We had it all: Around 100 channels from Holland, Germany, Belgium, UK and even some Spanish and Italian channels that nobody watches. Ten Discovery-like channels, several music channels, a bunch of 24/7 news channels and all the regular stuff. Of course I had the HD upgrade to watch everything in high quality. In addition we had the recorder feature upgrade, so we could pauze the broadcast and easily record shows.

Oh and I almost forgot the premium channels to watch my sports: Sport1 and FoxSports, so I could watch all mayor football matches in Holland and Europe live and finish the weekend on Sunday evening with the live broadcast of the final round of the PGA Tour Golf tournament of that week.

The Problem

Yes it was great. And a giant wast of time. And money. And focus.

So what did we actually watch? As many others we enjoy good television series. But, commercials are awful and most series are broadcasted way behind their USA release schedule. So we’d rather get the Blu-ray box and watch them that way. About the news: You can get way better news updates and opinions through the web, so that was already over for a long time. For music and radio we have Vevo, Spotify and YouTube. And for sports, all the games are viewable via the channel’s websites and apps. Only problem with that is that the quality is not really the best you can get.

The biggest problem was that we were watching things we didn’t need to watch. The TV was always on and sometimes we even kept switching channels until we found something viewable.

The alternatives

Read More

Humans Need Not Apply

Posted by

After reading Race against the Machine by Brynjolfsson and McAfee earlier this year I’ve gotten very interested in the topic of extreme automatization: the end of work. If most jobs are gone and done by robots/systems, how will this affect our society and how are political and economical systems going to react to this.

CGP Grey created this excellent 15 minute video that gives you a good introduction to the situation.

insiderPROFILES Magazine feature Design Studio Q&A

Posted by

sapinsiderprofile_cover SAPinsider featured our SAP Design Studio Q&A chat we did earlier this summer in its latest edition of the InsiderProfiles paper (!) magazine. In the article a selection of questions and answers from the Q&A chat is given.

Check the article below. If you’re looking for the whole Q&A transcript, follow this link.

You can find more information on SAPinsider insiderPROFILES Magazine here.