How To Concate Three Strings In Elasticube

Question: I have requirement to combine and show the dimension. There are two dimensions Product and Product_Family. I want to display it as single dimension in charts like "Product 1 | Product Family 1", "Product 2 | Product Family 1", so on.

Solution: If all dimensions are of string data type it will be enough to use the '+' sign between them and the '|'.

If they are not strings yet, you can use the TOSTRING() function before using the '+'

You can also use the Concat function:

Concat(Concat([Product1].''),[Product2]) 

Or  Concat([Product1],[Product2])