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 

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 

Auto Incrementing a dimension primary key in SSIS

While working with SSIS to generate star schemas, a common problem I faced was populating a dimension table from another table that did not contain any ids for the items being inserted. If you would try to insert the dimension data without any keys, an error would be thrown since the id field cannot be null. An easy solution is to have a script populate the id column. In this example we take a table...

March 10th, 2009 by David Lai