Numeric values not copying from source to target elaments
-
- 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
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
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
-
- 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
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
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
-
- 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
Then it would be something along the lines of:
vIndex = DIMIX( 'Version", CellGetS( 'cubename', dim1 element, dim2 element, ... ));
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
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
-
- 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
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...

Thanks a lot Guys...


-
- 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
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
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