5 Replies Latest reply on Oct 4, 2013 2:35 PM by SriniVEERAVALLI

    Substring

    Govi

      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