cancel
Showing results for 
Search instead for 
Did you mean: 

Create dimension in Universe Designer that uses two alias tables

Former Member
0 Kudos

Dear experts,

I need to create a dimension in Universe for "Country name".

I have a dimension "country code" that comes from TableA.Country_code. Accordingly to TableA.Country_type I will fill "Country name". My issue is that, if TableA_Country_type = '1' I must select TableB.Country_Name but, if Table A.Country_type = '2' I must select TableC.Country_Name.

Both Tables B and C are linked to Table A via Country_code. Both Tables B and C are alias of a Table Z.

Is this possible to have? What should I write on "Country name" object, in the universe?

Thanks is advance.

Cheers!

Inê

Accepted Solutions (0)

Answers (1)

Answers (1)

Former Member
0 Kudos

Object definition should be:

[Country_name]

Case

when TableA_Country_type = '1' THEN TableB.Country_Name

when TableA_Country_type = '2' THEN Tablec.Country_Name

End

Hope it helps you.

Thank You!!

Sent from iPhone