Filter Delegate Advanced - Improve your datamodel

If you're not familiar with the basics of filter delegate, please refer to this article before continuing reading.

Any datamodel of a certain size holds some dimensions and measures that are not directly related.

That means that you can't drill on a dimension and expect another table with measures from a not-directly related table to respond.

It could look like this:

If you drill on reasons for Absence, you won't get a "reaction" from the table on the right-hand side, because Absence Reasons are not directly related to the fact table where the seniority numbers are located.

So - when you clcik an Absence Reason, the datamodel doesn't support "passing" or delegating that filter to the fact table holding seniority.

Without filter delegate, it will look/behave like this:

No change in the table on the right-hand side.

Now we set up a filter delegate on the left-most table that delegates the filter to Employee and tries again.

So that's it - we managed to actually improve the datamodel that lies beneath the analysis.

NOTE: This requires some knowledge of how the data model has been created, and should be used carefully.