Drilling through from cube report in the date field to a relational report

[dcgirl]

I have 2 reports created in RS, Source and Target Reports.  I am using Cognos version 8.4.  Source Report is built from a cube has a time dimension (Year) and a measure (Revenue).  Target report is a relational report with Order Date and Revenue columns.   I have a drill through link set up between Source and Target using the Order Date Prompt.  When I click on value "2008" in the Source report, the value is not getting passed to the Target report.  The filter in Target report is follows:  Sales.Sales Query.Order_Date in_range ?Order_Date?  Any Ideas on what I am doing wrong?  I have used the same filter in 8.3, and didn't have any issues.  Somehow it doesn't work in 8.4

Source Report

Year    Revenue
2008   2,000
2009   3,000

Target Report

Order Date   Revenue
5/20/2008    2,000
1/1/2009     1,000
2/1/2009     2,000

[Filip.Cuppens]

Dear DCGirl,

have you been able to solve this issue ? Seems like I have a similar issue Drilling through from Analysis Studio to Report Studio on a Date Range. It worked in 8.2, but does not work anymore after upgrade to 8.4.

Regards

[billylodz]

why in_range not =

and you pass year but in source you use date. use year too

[Filip.Cuppens]

BilliyLodz,

I used in_range because it is documented like that by IBM Cognos.

Not sure what you try to explain with 'Pass year, but in source use data'. How do you dynamically filter your target report then ? I would like to be able to Drill Through on year Level, on Month level or Data level, or even on a list of dates. For as far as I know, that will not be possible if you only pass Year to the target report.

Regards

[billylodz]

look on parameter witch is passed to detail report
it's category code, in my case    ("2007-01-01","2007-12-31")

and you need to have the same in destination report.

so one solution is to pass something else (like caption([year])
or to create Dita item in destination to match the ParamValue

[Filip.Cuppens]

That's exactly what I did. I created a 8.4 Report Studio report with a Prompt [Date] in_range ?pmrptDate?. In the Drill through Definition we passed the Date dimension to the Date Prompt.

In case we drill through from analysis studio to the drill through report, and we verify the passed source values, we indeed see the date - item will be passed in a format [YYYYMMDD]-[YYYYMMDD], but if we verify the parameter mapping to the report studio report the date prompt is not receiving any values.

So I think we've set up the Drill Through definition correct, and I think there is a bug in the Cognos software or the documentation is not correct. So I'm looking for someone who has set up the drill through definition like documented by IBM Cognos in Cognos 8.4 and was actually able to drill through on the dates.

Regards

[twlarsen]

How is your Cognos directory structure set up?

For example, I had the same problem when I had my relational package, and then my cube package located beneath the relational package.  When I moved the cube package to directly under public folders, it worked.

It was a pain to figure out it was something this simple.

Do any other drill throughs work for you or is it just this one?

Just a thought,

Todd

[sr71_mavericky]

Hi DcGirl ... were you able to resolve this issue??

We are facing the exact same issue and can not figure out how to pass the dates off to the drillthru report.

Any help will be greatly appreciated!!

Thanks
mavericky

[Eskild]

Hi all. This is a bug in Cognos 8.4 FP2.
(Every thing works fine in 8.3)
It's correct to use the in_range function when you drill from a cube to a relational model report.

Regards
Eskild

[jd]

HI all,

anybody have the solution for this issue. Same issue I am goinh through now, I am trying to pass the parameter to map the source report. in the view target mapping I can see the display value and use value dispaly valus is showing 2007 use value is showing 007-07-0. I am not sure how to achive this issue why the use valus is showing hyphen between the numbers.

any idea??

[sr71_mavericky]

Found the solution after a lot of back and forth with cognos support.

You need to install fix pack 2 (FP2) and two additional hotsite fixes:

for windows install hotsite fixes are:
c8bisrvr_win32_8.4.29.1046
c8bisrvr_win32_8.4.29.1060

for AIX
c8bisrvr_aix32_8.4.29.1046
c8bisrvr_aix32_8.4.29.1091

open a ticket and they should be able to provide the fixes to you

peace
mav

[mrcool]

Hi laxmi..Could you please let me know how you resolved your issue. I am facing similar issue with my report.

Thanks,
MC

[MFGF]

Hi laxmi..Could you please let me know how you resolved your issue. I am facing similar issue with my report.

Thanks,
MC

It was a bug in the initial 8.4 release.  If you have 8.4.1 or a later fixpack for 8.4 the issue is resolved.

Regards,

MF.