1 Reply Latest reply on Aug 11, 2015 6:59 PM by Thomas Dodds

    Using Session Variable OBIEE

    2953248

      Hi,

       

      I have a table Employees with this columns(idEmp,FirstName,LastName,FullName,Gender,Job) what i need is stock the value of FullName in a variable i created a new  session Variable "SV_Emp" and i created a new Initialization Block with this query "Select FullName from Employees where Gender=':promptGender'

       

      What i need  in OBIEE is create a new analysis and i add a column and i edit the formula and call my variable (all this i did it ) after that i need to create a prompt with a list contains 2 value (F and M)

      then i need to link my prompt with my variable for example if i select the "F" from the prompt i need to get the Full Name of my all employees who the gender are F and if i select the "M" from the prompt i need to get the Full Name of my all employees who the gender are M

       

      i don't know if can i do this with the Session Variable but this is my idea if they are any suggestions or another method can i use it please tell me

       

      Thanks