Cognos Analytics

Hey everyone,

Have a series of related questions about drill-throughs in Cognos Analytics, for which I will ask forgiveness if they are answered in the documentation and I just missed it (many such cases).

1. I have a dashboard built off of  TM1 Cube (whatever the latest or penultimate build of TM1 is) in CA 12.0.4. We use a Period Months dimension (202411 = November 2024, etc.) which has an inordinate number of attributes for various things, such as month start and end dates, etc.
   
   
   1. How can I expose those attributes to a drill-through mapping so I can for example pass 2024-11-01 to a pStart_Date parameter and 2024-11-30 to a pEnd_Date parameter in a report?
      
      
   2. If I cannot, is there a way I could pass '202411' or '2024 Nov' to a pMonth parameter in the report and then derive the start and end date parameter values from that before the report is itself run?
      
      
      1. The idea here is I want to be able to create ONE report that has the relevant data filtered with a start and end date and then use it in as many drill-through contexts as possible, rather than my current idea of creating multiple copies of the same report and then futzing with their parameters to accommodate the drill-through source (such as one copy that filters based on the month passed, another copy that filters based on start date and end date passed, etc.

Thanks,

Tom

EDIT in response to Philipp & Andrei (I think the type of thread I created doesn't let me respond to "answers" directly; life-long learning is this week's theme, it seems):

The Dashboard source is TM1 and so yes it is dimensional. The source for the report is relational (data module built off of datasets, fwiw).

I'm not having a problem defining working drill-throughs per se (I can for example use the TM1 'Business Segment' dimension elements and map them to a pBusiness_Segment parameter in the target report and that works just fine), the question is more around either:

• how one can, or even whether one can, leverage the attribute data on a TM1 dimension for drill-throughs,
• or, failing that, if there's a way in a CA report to "pre-process" a parameter to have it populate different parameters before the report is "run" (as in my example, passing '2024 Nov' to a pMonth parameter and having the pStart_Date and pEnd_Date come out to 2024.11.01 and 2024.11.30 respectively, and then having the report query be filtered by those latter two date parameters).