Data masking vs Business object security in SAP BusinessObjects

In the previous article, we talked about how to implement data masking using data security profiles at the universe level to prevent users from viewing sensitive data. Data Masking in SAP BusinessObjects However we can also use business security profiles to limit users from accessing certain objects. In this article, I’d like to present my thoughts on both methods. (more…)
February 23rd, 2019 by David Lai 

Data masking in SAP BusinessObjects

One of the cool features with Information Design Tool and UNX universes is the ability to point to different table views depending on your security profile. Because of this, we can easily perform data masking, which allows us to mask restricted data. For example, I have 2 different types of users. Group FULL who can see all revenue/cost measures, and Group PUBLIC who can see revenue measures but...

January 14th, 2019 by David Lai 

Checklist of items to watch out for when applying an SAP BusinessObjects patch or service pack upgrade

Every time I apply a service pack upgrade or patch at a client site, I’m always excited about the features or fixes. However it is very annoying that any customizations get overwritten. This includes items such as: Branding, Single Sign-On, Modifications to the login page The following is a checklist of items that I backup beforehand when applying a service pack or patch upgrade (more…)
December 19th, 2018 by David Lai 

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 the custom.jsp here (more…)
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 to log in to the new BI Launchpad. So I typed in the url http://server:8080/BOE/BI,...

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 can be tagged with multiple describers. A ticket can be¬†interesting,...

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