I need to create a obiee prompt for column say for example : I have a table having columns department number and department name . Now i need to filter my analysis by using department prompt , In the prompt i want to show department name for user to select and to analysis i want to pass department number.
Please any one help me out with solution