Cognos 8 Report Studio report based drill through

Unfortunately, it is currently not possible to decide on a per report base which user is able to do an drill through and which not. So, if you want to limit the access to the drill through functionality per report AND by user or by row we need to do a trick. The drill through report uses usually parameters which can be (if you know the syntax) also feeded by url.  By the way, drill through by direct url is even faster than the internal function of cognos 8, since Cognos 8 has to validate the request before executing the drill through report. So, if you need to save some seconds during drill through this is also an option. Details on how to open a report by url and feed the required prompt parameters can be read in the Cognos 8 BI Report Studio Guide. Before using such an feature, make sure that a misuse of the parameters isn´t possible (data security)…