1 Reply Latest reply on Aug 26, 2014 3:25 PM by Souro

    Need limited data in the prompts


      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