How to create dimension in TM1 cube with 3 alias?

[initm1]

Hi everyone, I am trying to create dimension in TM1 cube with 3 alias but did come across any topic on how to achieve that. I know how to manually create a dimension without alias but for this topic I will need your help.

for example I want to create region dimension
1st alias with ShortName = UK
2nd alias with DescName = United Kingdom
3rd alias with FullName = UK - United Kingdom

thanks all!
regards!

[declanr]

You can manually go to edit element attributes and then create a new attribute of type alias.

Or use TI and:

Code: Select all

AttrInsert('DimName','','AliasName','A');

[initm1]

hurray! that work perfect! thank you Declan

Please help me load 3 columns of data from csv/.txt file to these 3 columns using ti or manually whichever is easier.

thanks again.

[Wim Gielis]

Please read the documentation of the software.

It's all about AttrPutS/N, CellPutS/N and functions like that.
There aren't a lot to be honest...

[initm1]

thanks Wim. I followed some turorials and i am able to load data. I actually asked the question in a wrong way.

How to add elements to my dimension with 3 alias not measures?

thanks again.

[Wim Gielis]

thanks Wim. I followed some turorials and i am able to load data. I actually asked the question in a wrong way.

How to add elements to my dimension with 3 alias not measures?

thanks again.

Which tutorials did you follow? Because DimensionElementInsert is pretty basic and pretty common.
As said, you will also need AttrPutS.

[EvgenyT]

Perhaps try learning basics of TM1 first ( there is plenty of documentation out-there) before wasting people's time on this forum...

ET

[initm1]

@EvgenyT, this might look very silly to you but I have spent hours trying to do this simple thing because I am new to this world.
the first answer

Code: Select all

AttrInsert('DimName','','AliasName','A');

itself was simple it is just that I'm doing it the wrong way.
I'm trying to learn the basics and I am asking questions here.
BTW, i still couldn't make it work, if it is that simple, you could have just told me what to do. thank you!

[Hippogriff]

Perhaps try learning basics of TM1 first ( there is plenty of documentation out-there) before wasting people's time on this forum...

ET

This is a bit unfair. The OP has numerous posts and they're not a fly-by-night poster. Other folk don't even need to bother reading someone's posts if they're not wanting to help, never mind replying like that. I am learning myself and there is a danger that new posters could feel very timid about asking questions if we receive responses like that. I think we know there is plenty of documentation out there, but we like to ask people who are more expert and are willing to share their knowledge (just like we do in real life). I hope this is constructive and not offensive.

[paulsimon]

Hi

You can use the TI Wizard to do this

Set your data source to the CSV file using the Browse button. Copy that to Data Source Name on Server.

Put in the number of title records - tip create CSV file so first row contains names of the fields with no space so TM1 can use them as variable names.

Variables Tab for the Code choose Contents as Element
For any Parents choose Consolidation
For Descriptions etc of the Code choose Attribute - repeat for the three Attributes

Maps
- Cube - leave as no Action
- Dimension
Element variable is Code

Enter Dimension Name - Action will automatically be Create if it doesn't exist

Consolidation Tab choose Cons Variable as Parent - probably will be auto completed anyway if you specified a parent

Attributes tab
Choose Attribute Variable as Description
Choose Element Variable as Code
Choose Attribute Type as Alias if you want this as an alternate name for the Code. NB The Alias must be unique

Save and Run it

Should work OK.

Amend The Create Actions to Update to run it again.

Look at the Advanced Tabs and see the TI Script that has been generated. Start learning.

Most real developers never use the Wizard. They write the Script directly, but it is a place to start.

Regards

Paul Simon