on 10-13-2010 4:52 PM
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ê
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
85 | |
23 | |
11 | |
9 | |
8 | |
5 | |
5 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.