Its kind of really urgent and important to me.
I have a prompt which hold the emp name. In the list of values i need only the list which comes when is join the emp table with the fact.
Like is its a SQL it would be lik this.
from w_emp_d e, fact f
where e.row_wid= f.emp_wid
Select the Choice list values in the column prompt editor and enter the logical sql.
It will give u the joined list if the emp table and the fact is joined in rpd.