Cell level Drill Through --- cognos 8

[KVBR]

Hi,

Can we do Cell level Drill through in cognos 8.

Here is my requirement:

Year
------
2004
2005
2006

I have a column Year, when i click 2004, it should open report1 with parameters.
If i click 2005, it should open report2 with parameters.
If i click 2006, it should open report2 with parameters.

Note:
We can do this through Conditional Layout OR Block.
As per performance issue can we have any alternative.

Thanks,
KVBR

[Blue]

I assume you are talking about Analysis Studio as you failed to mention which tool in Cognos 8 BI you are talking about.

With Analysis Studio the drill through is either scoped on a particular dimension level or the whole cube.  You cannot simply click on a cell and expect to drill-through to a re-defined target.  Instead you right-click on the cell and a form pops up that may or may not contain a list of possible targets you can drill-through to.  These drill-through options are defined in Cognos Connection as Drill Through Definitions.

Cognos 8 BI has added some new features but has also lost some that were available in PPES.

[KVBR]

It is Report Studio

[clelkinsBERRY]

In report studio, have the Fiscal year 'List column body' selected only.

Then, Right Click > Drill Throughs

Click new in the bottom left hand corner. (to rename the drill through select the 'ae' symbol between new and the X delete in the bottom left hand corner)

Then under 'Report:' Click the Ellipsis (...) and Navigate to the report of interest.

Then decide what Action: (probably 'run report') and Format: (probably HTML or PDF) you'd like to happen.

We always open ours in a new window ... so I would suggest to select the 'Open in new Window' box

Now,

Click the edit button (pencil)

This opens up the parameters THAT EXIST ON THE REPORT YOU ARE ATTEMPTING TO DRILL TO.

If nothing exists here, then the parameters are not defined in the Report you are attempting to drill to.

Do this.  Then return.

If some do exist then under Method:

Decide if you: 'Do not want to use the parameter' for the drill through.
                      'Pass Data Item Value'  ~ which whatever you click on (i.e. 2006, 2005, or 2004)  This would
                                                                be the parameter passed to the Year prompt you hopefully
                                                                have on the report you are trying to drill to.
OR
                       'Pass Parameter Value' ~ which passes whatever the current parameter value is for the
                                                                parameter

Then whichever you choose for each Parameter under 'Value':

Select the Parameter you are wanting to pass to the drilled to report.

Hope this helps.

[KVBR]

hi, i need based on list value it should call different report with required parameters. Not Drill thourgh.

[anirudha]

KVBR!

I guess this might help you.You might want to follow these steps:

1) Unlock the [YEAR] column in the list report. Drop two more [YEAR] columns so that you have a SINGLE column header and <YEAR><YEAR><YEAR> in the column body.
2) Now open the Condition Explorer and creat a new String Variable, say YEAR. In the Expression Definition box enter following statements as per your set of Data Items.

CASE
WHEN [YEAR]=2004 THEN 'SHOW'
ELSE 'HIDE'
END

In the same way creat two more variables say, YEAR1(use 2005) and YEAR2(use 2006).

3)Make sure that unlock is enabled. Now ckick the first one [YEAR] and then Select YEAR Style Variable from the Propperties. Apply the conditional formatting. When SHOW, keep the default format. When HIDE,ewt Box Type property to 'none', so that [YEAR] is not visible. Double click the Greened Vertical bar to apply conditional formatting.
Repeate the above procedure for remaining two columns.

4) After that you need toset up Drill Throughs.
I guess you have 3 reports to be drilled through.
Set up drill throughs from these three columns i.e. [YEAR],[YEAR1] and [YEAR2] to three target reports.

I guess this will fix the issue.

Let me know if this wasnt clear enough.

-Anirudha.

Hi,

Can we do Cell level Drill through in cognos 8.

Here is my requirement:

Year
------
2004
2005
2006

I have a column Year, when i click 2004, it should open report1 with parameters.
If i click 2005, it should open report2 with parameters.
If i click 2006, it should open report2 with parameters.

Note:
We can do this through Conditional Layout OR Block.
As per performance issue can we have any alternative.

Thanks,
KVBR

[KVBR]

thanks anirudha,
Ã,  Ã,  Ã,  Ã,  Ã,  But the problem is i have to call 15-20 report formats.

The other way of approach we can do is, creating dynamic URL using HTML control.

Here is the way:
1)Ã,  Ã,  Ã,  Ã,  Ã, Creat a calculated value which contains the urls.
Ex: CASE
WHEN [YEAR]=2004 THEN <a href="http://your report url &para1=2&para2=2004" /> [year]
WHEN [YEAR]=2005 THEN <a href="http://your report url &para1=2" /> [year]
ELSE
WHEN [YEAR]=2006 THEN <a href="http://your report url &para1=2&para2=2006&para3=01" /> [year]
END

2) Add an HTML Item to the report
3) Set the expression property to the calculated column.

This is best approach i have currently with me.
Note: This will work for List reports. Cross tab won't allow html element.
Still i am looking for approach which will work in Cross tab too.


KVBR

[anirudha]

HI,

Yes in case there are 15-20 reports i would also have gone with URLs. But the main problem with them is when drilled through Reports wont open in a new window as well as when you deploy from one Developement to Test, you have to change the URL to point to proper reports.
Anyways, it was nice talking to you.

-Anirudha.

thanks anirudha,
Ã,  Ã,  Ã,  Ã,  Ã,  But the problem is i have to call 15-20 report formats.

The other way of approach we can do is, creating dynamic URL using HTML control.

Here is the way:
1)Ã,  Ã,  Ã,  Ã,  Ã, Creat a calculated value which contains the urls.
Ex: CASE
WHEN [YEAR]=2004 THEN <a href="http://your report url &para1=2&para2=2004" /> [year]
WHEN [YEAR]=2005 THEN <a href="http://your report url &para1=2" /> [year]
ELSE
WHEN [YEAR]=2006 THEN <a href="http://your report url &para1=2&para2=2006&para3=01" /> [year]
END

2) Add an HTML Item to the report
3) Set the expression property to the calculated column.

This is best approach i have currently with me.
Note: This will work for List reports. Cross tab won't allow html element.
Still i am looking for approach which will work in Cross tab too.


KVBR