If you are unable to create a new account, please email support@bspsoftware.com

 

News:

MetaManager - Administrative Tools for IBM Cognos
Pricing starting at $2,100
Download Now    Learn More

Main Menu

drill down in a join query

Started by philelmousse, 05 May 2011 02:22:57 AM

Previous topic - Next topic

philelmousse

Hello,

I have a join query and would like create a drill down on some element in that query. It is possible ?

philelmousse


rockytopmark

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.

MFGF

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.
Meep!