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

Using business security profiles to limit users from accessing certain objects using both methods

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!