All about Business Intelligence

Excel2007 is a great tool for power users/analysts to access a SSAS cube. They can slice ‘n dice the data as never before and even make appealing reports on the fly. Yet the new drillthrough capability is not completely bug free. First of all, it is impossible to drillthrough if the user has selected multiple values in a filter hierarchy or in a row or column axis. Okay, that is a restriction with the current state of SSAS2005. (I’ll explain how to get around it via MDX in another post.) What is worse is that in certain situations it does allow a drillthrough but then displays wrong results.

Read more »

We are facing a problem when applying simple dimension security: it disables drillthrough.

The business case is simple enough: there are two usergroups, one that is denied access to a specific dimension and one that is allowed to see its contents. (In theory we would like to completely hide that
dimension for the first group, but that is impossible - vote for this issue here.)

To implement this we have set the Allowed Member Set to {} for all attributes of the particular dimension. It works as expected.

But… the drillthrough stops working for the users that have no access to the dimension (the drillthrough does not contain elements from that dimension). There are no frivolous calculated measures, no cell security, …

Read more »