Dynamic drill through

[MKA]

Hi

I'm creating a POC at a client and the request is as follows:

There is a corporate cube in place, containing all information on an aggregated level. The main reports (in report studio are based on this cube). Whenever a user wants more detail, a drill through is foreseen to go to a detail report. This report is based on a cube with all the details included. So far so good, but here's the tricky part, there is a detail cube for each region. When drilling through, the correct detail cube (source) needs to be chosen to show the correct details. The drill through can be done based on customer and using an attribute in the customer dimension we know which cube to use.

In addition to that, when a user drills on a dimension that is not linked to a region, he should be presented the option to choose which detail cube he wants to use.

And drilling should not only be possible in report studio reports, but also in analysis studio.

Does any of you have experience with this dynamic cube drill through? All suggestions are welcome.