Creating a Prompt Value based on Another Prompt

We have 3 lists on a report. each based on a different source query on a different cube. Source query A has dim1.region and dim2.region
values of both columns are the same.
Source query B has dim1.region. Source query C has dim2.region.

I have a prompt based on source query A for region. lets call this ?Prompt1? and it is based on dim1.region, but Ican put the dim2 region in the cognos query promptA

Using ?Prompt1? to filter lists based on query A & query B works fine.
But of course not on query C.

How can I populate a ?Prompt2? to filter C? I don't want the users to have to select region twice. and both region fields are in cognos query promptA.

I've played with caption function, to try and use just ?Prompt1? but get errors.

something close. but i know for sure in toolbox some user ask this question few weeks back. Sachin help the user to solve this issue. pls search on the toolbox and I will also look into my database as well.

What errors are you getting?
You should be able to do what you want by using the caption (which is a string)
and then building the member from that for dime2.region.
The syntax is tricky as sometimes you have to put in quotes or double quotes or
square brackets. If you are constructing the member expression, it has to be
exactly what is being expected.? This is sometimes easy to do by itself so you
can easily display it in the report as a data item and then verify that all the
quotes, brackets, etc are exactly where they should be.?

A few things.
First are you putting this as a detail filter or a filter function in a therefore creating a member set? In dimensional reporting you really don't want to use detail filters aa they really hurt performance.
Second, in dimensional there aren't rows so I don't really understand the Comment about rows. Can you explain more of the issue?

then, you have to get the input as a string. so you would need to extract the caption from the selected region on promptA and pass it to parameter. To do this, you could use master detail. master query would have the caption calculation. if needed, trim it.

Copyright 1998-2015 Ziff Davis, LLC (Toolbox.com). All rights reserved. All product names are trademarks of their respective companies. Toolbox.com is not
affiliated with or endorsed by any company listed at this site.