Numeric values not copying from source to target elaments

Wim Gielis
MVP
Posts: 3240
Joined: Mon Dec 29, 2008 6:26 pm
OLAP Product: TM1, Jedox
Version: PAL 2.1.5
Excel Version: Microsoft 365
Location: Brussels, Belgium
Contact:

Re: Numeric values not copying from source to target elaments

Post by Wim Gielis »

Are you aware of the existence of the functions DIMIX, DIMNM, DTYPE, and similar ones ?
Best regards,

Wim Gielis

IBM Champion 2024-2025
Excel Most Valuable Professional, 2011-2014
https://www.wimgielis.com ==> 121 TM1 articles and a lot of custom code
Newest blog article: Deleting elements quickly
aravind.cgns
Posts: 51
Joined: Sun Sep 11, 2016 1:55 pm
OLAP Product: Cognos Tm1
Version: 10.2,11
Excel Version: 2007

Re: Numeric values not copying from source to target elaments

Post by aravind.cgns »

wim,

I know that the problem here is the values present in the elements of the measure dimension is passing from other dimension using picklist, if i use the dimix function here it gives the index numbers of source version and target version, i want the index numbers of values in the elements populated from picklist list dimension as mentioned in the previous post.

Thanks,
Arvind
Wim Gielis
MVP
Posts: 3240
Joined: Mon Dec 29, 2008 6:26 pm
OLAP Product: TM1, Jedox
Version: PAL 2.1.5
Excel Version: Microsoft 365
Location: Brussels, Belgium
Contact:

Re: Numeric values not copying from source to target elaments

Post by Wim Gielis »

Then it would be something along the lines of:

vIndex = DIMIX( 'Version", CellGetS( 'cubename', dim1 element, dim2 element, ... ));
Best regards,

Wim Gielis

IBM Champion 2024-2025
Excel Most Valuable Professional, 2011-2014
https://www.wimgielis.com ==> 121 TM1 articles and a lot of custom code
Newest blog article: Deleting elements quickly
aravind.cgns
Posts: 51
Joined: Sun Sep 11, 2016 1:55 pm
OLAP Product: Cognos Tm1
Version: 10.2,11
Excel Version: 2007

Re: Numeric values not copying from source to target elaments

Post by aravind.cgns »

Thanks a lot wim,declanr i have changed my TI Code accordingly such that it copies data from source customer to target customer and source version to target version. ASCIIOUTPUT() func was really helpful as suggested by wim i was able to trace like where i was going wrong and able to fix the code. This forum is really very helpful.

Thanks a lot Guys... :D :D
Wim Gielis
MVP
Posts: 3240
Joined: Mon Dec 29, 2008 6:26 pm
OLAP Product: TM1, Jedox
Version: PAL 2.1.5
Excel Version: Microsoft 365
Location: Brussels, Belgium
Contact:

Re: Numeric values not copying from source to target elaments

Post by Wim Gielis »

You're welcome !
Best regards,

Wim Gielis

IBM Champion 2024-2025
Excel Most Valuable Professional, 2011-2014
https://www.wimgielis.com ==> 121 TM1 articles and a lot of custom code
Newest blog article: Deleting elements quickly
Post Reply