5 Replies Latest reply: Oct 4, 2013 9:35 AM by Srini VEERAVALLI RSS

    Substring

    970365

      Hi

      We are using OBIEE11g.I have Dashboard prompt Date and Client

      Client values like XXXXXXUS,BBBBBBIN.........

      i set presentation variable(Var_Country).

      Now i set Report filter column Country Code equal to presentaion variable

      My Country Code Should be US,IN...i dont want to set substring in the prompt column.But i have to filter based on country code only.so i set filter Country_code=@{substring(@{var_Country},7,8)} but it return error.

       

       

      How can i filter only Country Code values.

       

       

      Thanks

      Gram