2 Replies Latest reply on Feb 2, 2015 9:46 PM by SriniVEERAVALLI

    Displaying datatype and applycing a condition on it

    Maraprik

      Hey Gurus,

       

      I would like to know if its possible to display the datatype of a field in OBIEE

       

      for example

       

      Lets say I have field 'Location' and the values would be

       

      123

      abc

      xyz

      000

      456

       

      i need another two fields besides is saying

       

      123  Numeric/ INT   Y

      abc  Char                N

      xyz  Char                N

      a12   varchar            N

       

      The 'Y' is for numeric and 'N' is for characters.

       

      Is this possible in obiee answers. Please let me know

       

      regards

       

      Ram