Search found 5 matches

by ldwnt
Mon May 20, 2013 9:41 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: TM1 Server translation
Replies: 7
Views: 6146

Re: TM1 Server translation

I'd agree with lotsaram here. If you can avoid renaming dimensions and cubes, do it. It's going to be a lot of work! If you absolutely have to rename all the cubes and dimensions, using TI isn't a perfect approach. The main reason I say this is that there are certain parts of the model TI does not ...
by ldwnt
Mon May 20, 2013 9:31 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: TM1 Server translation
Replies: 7
Views: 6146

Re: TM1 Server translation

You export data out of a cube using the ASCIIOutput function. You can find good resources of pre-built library to export data from any cube and iterate through objects over at http://www.bedrocktm1.org/ However 2 words of caution about your approach. 1/ TM1 is typically used for modelling and repor...
by ldwnt
Tue May 14, 2013 3:04 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: TM1 Server translation
Replies: 7
Views: 6146

TM1 Server translation

Hi guys, Recently I get a task to translate a TM1 Server (including dimensions and attributes, cubes and rules, TI processes, applications) from Japanese to English, and then make it support multi-language. Frankly speaking, I'm totally new to TM1. Based on some learning from TM1 documents, I figure...
by ldwnt
Wed May 08, 2013 2:45 am
Forum: Useful code, tips and tricks
Topic: Dimension utilisation - finding redundant dimensions
Replies: 21
Views: 43701

Re: Dimension utilisation - finding redundant dimensions

I wonder if there's any way to find out the exact number of dimensions associated with a cube in TI? You just make the while condition check for the result of the tabdim function (returns a blank string if the dimension index argument is a number greater than dimensions in the cube). i=1; While( Ta...
by ldwnt
Tue May 07, 2013 5:33 am
Forum: Useful code, tips and tricks
Topic: Dimension utilisation - finding redundant dimensions
Replies: 21
Views: 43701

Re: Dimension utilisation - finding redundant dimensions

The attached TI process will cycle through the list of dimensions and find out which cubes they are used in. If a dimension is not used then it puts out "-" in the cube column. This can help you identify which dimensions are no longer being used. Thanks for the process example. But I noti...