1 Reply Latest reply: Aug 26, 2014 10:25 AM by Souro RSS

    Need limited data in the prompts

    986359

      Hi All,

       

      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.

       

      select e.emp_name

      from w_emp_d e, fact f

      where e.row_wid= f.emp_wid

       

       

      Thanks,

      LonaD