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.
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 '+'