How to bypass opendocument login screen

In this article I’d like to show you a simple example of how to bypass the opendocument login. This is especially useful if you are trying to use an opendocument call to open up a web intelligence document from a 3rd party application. It’s quite simple, and you can expand the example to use trusted authentication if desired. Download...

April 9th, 2018 by David Lai 

First look and thoughts on Fiori-fied BI Launchpad

After seeing the Fiori BI Launchpad previews, I was so excited to finally get SAP BI 4.2 SP4 installed on our sandbox. It was literally like opening presents during Christmas as I couldn’t wait to try out the fresh new interface that would be similar to SAP ONE Support Launchpad . After the installation was complete, it was time...

September 13th, 2017 by David Lai 

Handling many-to-many joins using a bridge table (Part 1)

As a data warehouse architect, star schemas are great until we encounter the dreaded many-to-many fact to dimension scenario. For example, we have a Ticket Fact table and a Tag Dimension table. The cost metric is calculated at the ticket level, so tickets have the lowest granularity and hence the ticket fact table.   However tickets...

August 3rd, 2017 by David Lai 

CurrentDate() not what you think in Web Intelligence

In Web Intelligence there are a variety of helpful date functions that you can use. 2 in particular are CurrentDate() and CurrentTime(). You would think that CurrentDate() returns just the current date and CurrentTime() returns the current datetime. However both return the exact same result which makes it confusing, especially if you are using date dimensions where the time is stripped off. The funny...

April 10th, 2017 by David Lai 

Web Intelligence – Unable to insert comment

The ability to add commentary to web intelligence reports is a powerful new feature released in SAP BusinessObjects 4.2. However, it does not work straight out of the box. Here are some steps to get comments to work. (more…)
November 30th, 2016 by David Lai 

Mixing unmerged dimensions in Web Intelligence

The concept of merging queries in Web Intelligence is quite simple, however once you have a requirement of mixing unmerged dimensions in an output table, this is when it gets messy! Let’s take a look at the 2 sample queries below: Query #1 (Sale Revenue by Year): Year, Quarter, Sales Revenue Query #2 (Quantity Sold by State and Year): Year, State, Quantity Sold Each query contains two dimensions...

March 3rd, 2016 by Daniel Li 

SAP BusinessObjects Dashboard 4.1 Cookbook now available!

Time flies as the original cookbook which covered SAP BusinessObjects Dashboards 4.0 has been in publication for almost five years. Xavier Hacking and I would like to give a Big Thank You to those who have purchased and benefited from our original cookbook. We hope that it has proven to be a useful resource! Fast forward five years...

April 6th, 2015 by David Lai 

BEx Query greyed out in Web Intelligence

A common problem when trying to access a BEx Query from Web Intelligence is that we cannot! I want to build a query off the sales test query, however it is greyed out. Well here’s an easy fix. All you need to do is open the query up in BEx Query Designer, go to the Query menu and select Properties ...

March 19th, 2015 by David Lai 

Cascading Prompts in BOBJ Dashboards and WEBI

A cascading prompt, helps the user focus on values they want to include in the prompt without the need to go through every possible value. A great example comes from a list of cities around the world. Imagine if we had to go through a huge dropdown list every time in order to find our desired city. It would be much easier if we can first select a country, then province/state and then the city. This...

March 12th, 2015 by David Lai