Concatenate two columns

Some time you will get request to concatenate two column.You can do with help of concatenate formula.

Here i am concatenating Year and month

Formula  : ("Date (Common)"."Year" )||'-'||("Date (Common)"."Month Name")

Thanks and Regards 

Rakesh Patil
rakeshpatil002@gmail.com

OBIEE Foundation Suite 11g Certified Implementation Specialist