Cognos drill-through

Question

How to strip off the first word from a measure being selected in a chart in a source report and pass it to a target report so that it is consumed by a crosstab in that 2nd (target) report?

So, for example, my Source report has a measure called [High Risk %]. I want to pass the first word 'High' to a target report so that it filters the Risk Level dimension to only show [High] risk level data. The Risk Level dimension only has 3 values (High, Medium and Low).

This seems like it shouldn't be that big of a deal but I can't figure it out. How to do this in a prompt macro?

Answer 1

Create a calculated data item in the parent query which does this. Include it in the chart query, and pass that instead.