Hi All,
I want to create a union query in Dimensional package. In my requirement I need to create a union of two measures in Dimensional package.
ex:
Query1
Country ColumnA
Query 2
Country Column B
Union query:
Country ColumnA&B.
A union would be:
Query1
Country ColumnA
Query 2
Country ColumnB
Union query:
Country ColumnA
Country ColumnB
A concatenation would yield "Country Column A Country Column B". I doubt you want that. Is there a relationship with the two members that is not being modeled?
I am not sure what to tell you.
You can create union in dimensional packages using the function UNION([member],[member]). You can't use the RS objetct "union" properly.