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.
Answer
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])
