How to write back to DB by referencing to a Code but display both Code and Text

[deadsea]

Hello All:

I am very new TM1 with some coursework under my belt with sample data from IBM, however, no real world experience. Hoping my query is something simple, which I can't search on because I am not sure what keywords to search on. My imaginative search terms return whole world of garble :(

Story: I have created a basic cube with following structure using samples:

TestCube:

->Products Dim
-->Product ID is Element (name and other info are attributes)
->Measure Dim
-->Instead of numerical measure elements I have instead drop downs for two measures: CountryOfOrigin and HasDuty

For both of the pick lists I have created dimensions which show up when browsing the cube as:

1) CountryofOrigin drop down shows values (Country Code + Country Name) -> CHI - China, GER - Germany, ITA - Italy, etc.
2) HasDuty Dropdown shows only 1 value -> X (used as an indicator)

So far so good and liking it! Now, I thought of a scenario where I want to display the CountryofOrigin dropdown as described above, but I only want to send/store the three letter abbreviation of the country in the cube, via TI Process that I will create to write back to the database (but I still want to display the full abbrevation + full name in the front end).

I have Country Code attribute in my measure dimension and but I cant figure out what I need to do next to leverage that. And I also have the dimension that translates the country code and country description in my CountryofOrigin picklist dimension and I am sure I can somehow use that mapping, but cant figure out how to achieve this.

Not sure if this is standard or not, but in the real world the descriptions can change but the Codes will remain same so by having only the code being written back to the DB or another TM1 cube, we will have some sanity.

Thanks for your help.