Print Page - drill down doesnt work in my query

Title: drill down doesnt work in my query
Post by: philelmousse on 12 Apr 2011 06:10:28 AM

Hello,

I created a join query of 2 queries which contain differents level set. The result of the query is some data item. But when i use that query in a crosstab I cant make drill down anymore. How should i do ?

Title: Re: drill down doesnt work in my query
Post by: philelmousse on 13 Apr 2011 08:13:55 AM

Nobody ? How to make drill down with data item ? Or should I change my joined query ?

Title: Re: drill down doesnt work in my query
Post by: CognosInMaine on 13 Apr 2011 08:19:45 AM

I don't have an answer but perhaps explain how you are trying to make a drill down report might help out.

Title: Re: drill down doesnt work in my query
Post by: philelmousse on 13 Apr 2011 08:47:08 AM

I just create a crosstab with my joined query and enable the drill down with the basic option.

Title: Re: drill down doesnt work in my query
Post by: PRIT AMRIT on 13 Apr 2011 08:49:30 PM

Have you got a Relational Package or DMR or CUBE as a source?

Well, just enabling drill option in Report Studio will not be of any mean unless you have a CUBE or DMR package as your source for reporting.

I suppose enabling drill up/down option in a Data Item means you have a Relational Package? If yes, then it's not possible.

Thanks
Prit

Title: Re: drill down doesnt work in my query
Post by: philelmousse on 14 Apr 2011 09:55:42 AM

Data come from a star schema. Can i change my joined query to make the drill down available for it ?

COGNOiSe.com - The IBM Cognos Community

IBM Cognos 8 Platform => COGNOS 8 => Report Studio => Topic started by: philelmousse on 12 Apr 2011 06:10:28 AM