Union in Dimensional Package

[yvswamy]

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.

[bdbits]

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.

[lucnieto]

You can create union in dimensional packages using the function UNION([member],[member]). You can't use the RS objetct "union" properly.