Hello,
I have a join query and would like create a drill down on some element in that query. It is possible ?
Nobody knows ?
I believe once a query is referenced, any/all dimensional functionality (ie: Drill down) is lost.
Reference Queries include UNIONs, INTERSECTS, straight references and yes, your JOIN query.
Typically drill down/up capabilities are only available on dimensional packages (based on OLAP cubes or modelled as DMR). If your package is one of these, then you should not usually need to join queries - dimensional reporting allows far more flexibility and can often negate the need for multiple-query reports.
If your package is purely relational (query subjects and query items) then drill down/up capabilities are not available, sorry.
MF.