Cognos 8 Drill Throughs( Need urgent help)

[usecognos]

Hi All

I am trying to drill through from Analysis Studio to Report Studio and getting unexpected results.



Issue: Cognos Not able to pass date values to the report. Comes up with a prompt page even when dates are not part of the analysis studio crosstab( I have used Country and Job Type as my rows and columns)

?Year? , ?Quarter? , ?Month? are all optional prompts on the Report Studio Report.

Drill through definition is defined correctly.
Defined for all the levels on the cube.

My date datatye in Cube and Report filter column is datetime. My database is Oracle


There are three drill through reports for the cube and all of them come back with a prompt page when I want to drill through on any intersection in the cube.

 

[mfgf]

Hi,

My guess is a mismatch in the datatypes, or issues with your date filter in Report Studio. See if the following is of any help,then get back to us if you're still struggling:

http://www.cognoise.com/community/index.php?topic=1191.0

Best regards,

MF.

 

[pttbcg]

I had the exact same issue and I had to contact Cognos Support. There are some issues with the in_range filter. I was given a hot site fix that resolved the problem. I would suggest contacting Cognos Support.

Cheers,

PT

 

[usecognos]

Hi mfgf/pthibideau,

I checked the Datatype both in Transformer Model and in my Report. They both are of type Datetime.

Also I have other drill through and cubes which work if I have a date either as a row/column or as context filter, but this one does not work.

I have logged a case in Cognos Support but I have not heard back from them.

Thanks

Sumit

 

[pttbcg]

I also had some that worked and some that didn't. There was no pattern (or at least none I could figure out). Also, I had to push the issue very hard with Cognos and it took over a week before they agreed there was a problem. I don't know how many times I asked about a hotsite fix before I got through to them.

Good luck!

pt

 

[pttbcg]

Something to try...Disable the filter for the date and see if other drill through points work.

Although, I think your problem is related to the bug I had, another colleague was having an issue using dates in Oracle and completely rebuilt the time dimension in the cube and that solved his problem.

 

[usecognos]

I had a new and intresting development.

My Drill Through Report Logic was quite complex, so I invested some time and reduce the complexity. Now the Drill Through Works on Time, it does not shows up a prompt page(with the same report column).

Now I have just one issue left which is it will not work unless some date is used as a filter from the cube to the report( this problem is across 10 cubes and 30 drill through reports used in the project)