I have column called Contact where am getting two values seperated by semicolon(;) and in dashboard i want to give the hyperlink for two values which give me details of the both the cotact person.
Please let me know how can i achieve this in OBI 10 g
Thanks for the response... I tried to do this and my contact column is not having only two values, some have one and some have 3 and 4 also. so please let me know how to do this...
and i dont see the split function in Data format... i know how to use substring and it wont suits here
Edited by: IndraKumar on Mar 27, 2013 9:08 PM