Hi All -
Can you please help me in getting a substring function in obiee 11g logical layer ?
we would like to print only the values upto first space. i.e., we would like to see only
Trying substring and length but not working.
I got the solution.
SUBSTRING('ABC 2.0' from 1 for Locate(' ', 'ABC 2.0')-1)