Can you pass a string to a target report member in a drill-thru report?

[longhorndkr]

I've seen very little documentation for this although it sounds like it shouldn't be that big of a deal. My problem is how to strip off the first word from a measure being selected in a chart from A) a Source report and pass it to B) 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' of that measure to a target report so that it filters my Risk Level dimension in that Target report to only show [High] risk level data. The Risk Level dimension in the Target report only has 3 values (High, Medium and Low) so if they select High Risk % in the first report I know they want to see High Risk data in the seond report.   

This seems like it shouldnt be that big of a deal but I can't figure it out. Can someone maybe suggest how to do this in a prompt macro??

THANK YOU FOR ANY HELP! Braindead Dave

[longhorndkr]

Oh yah, I'm going against cube data, fyi. 

I would think that I would just need to create a data item (let's call it 'Risk') in the Source report using some IF THEN or CASE logic to pull from the Measure (in my case I created a set called RiskLevels that contains High Risk %, Medium Risk % and Low Risk % measures). 

CASE
WHEN (ParamDisplayValue([RiskLevels]) like 'High Risk'  ) THEN ([High])
WHEN (ParamDisplayValue([RiskLevels]) like 'Medium Risk'  ) THEN ([Medium])
etc. . .
END

I then created a prompt in the Target report called 'Risk Prompt' to pull the value from Risk in the drill-thru defs but for some reason, I keep getting a prompt for Risk Level before the second target report ever appears. 

How do I pass that sucker?

Thanks again!