Union of two columns data into one column

Subhakara Netala-Oracle

Summary: We want to combine(Union) two columns into one column as shown in below screenshot. Country will be the new column which is union of Primary and secondary.

Content (required): We have two Columns Primary and Secondary Country, we want to present both columns data into one column. Union report is not an option as every time it is not feasible for users to create union report. So either in RPD and in Report criteria is there any option to union two columns into one column?

Version (include the version you are using, if applicable):

Code Snippet (add any code snippets that support your topic, if applicable):

Gianni Ceresa

Model your table in the RPD as having 2 sources, one targeting the first column and one targeting the second column. The tool will do the job of doing the 2 queries and joining the results together.

Subhakara Netala-Oracle

Thanks Gianni. Will it work if columns come from two different dimension tables? I dont think this will work.

Gianni Ceresa

The physical tables can be 1, 2, 10 or how many you want. It's up to you to decide how to model them, to give them a role.

Of course if you have data problems (missing way of connecting things) even modelling isn't going to help you. But otherwise it doesn't matter if it's the same table or not, as long as you have enough elements to model them together as a dimension (they aren't dimensions before this point, they are just physical tables, they do become part of a logical dimension only after you define them as sources).

Subhakara Netala-Oracle

Hi Gianni,

Can you please share any screenshot on how to model this or give me more steps on how to do this. I thought having 2 source means 2 LTS in logical table, please confirm.

Gianni Ceresa

Yes, 2 LTS is what I had in mind as that's the only way in the RPD to get a union result. Otherwise you can of course build a view or a unified table in your database, but if have that option you probably wouldn't be asking