Hello all,
Had a busy week at customers and my brain doesn't work at full speed anymore I'm afraid.
I have a simple cube, 2 dimensions. Last dimension contains a string element called 'String'. Then, I have a very basic rule like:
['Elem','String']=S:'10';
'Elem' is just a simple element in the first dimension of the cube. If I just put this line of code in a TI process:
AsciiOutput('testfile.cma',CellGetS('MyTestCube','elem','String');
the file is indeed created, but with no contents (except for the 2 double quotes). The 10 does not show up in the file.
I also tried by feeding, including feedstrings and so on (cell is indeed fed), to no avail.
What am I missing here please?
Best regards, have a good weekend,
Wim
TI process to read out a string-calculated cell
-
- MVP
- Posts: 3241
- 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:
TI process to read out a string-calculated cell
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
-
- MVP
- Posts: 195
- Joined: Wed Jul 22, 2009 10:35 pm
- OLAP Product: TM1
- Version: 9.5.2 FP3
- Excel Version: 2010
Re: TI process to read out a string-calculated cell
This ASCIIOutput is in Prolog/Epilog, or is on Metadata/Data and cubeview is the source for TI?
-
- MVP
- Posts: 3241
- 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: TI process to read out a string-calculated cell
Hello,
The line of code is in the Prolog (or Epilog) of a process with data source 'None'.
If I do the same but the 10 is written directly (not rules-calculated) in the cube, it works perfectly and it appears in the text file.
Wim
The line of code is in the Prolog (or Epilog) of a process with data source 'None'.
If I do the same but the 10 is written directly (not rules-calculated) in the cube, it works perfectly and it appears in the text file.
Wim
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
-
- MVP
- Posts: 3706
- Joined: Fri Mar 13, 2009 11:14 am
- OLAP Product: TableManager1
- Version: PA 2.0.x
- Excel Version: Office 365
- Location: Switzerland
Re: TI process to read out a string-calculated cell
Which version? Sounds like a bug.
-
- MVP
- Posts: 3241
- 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: TI process to read out a string-calculated cell
Hmmm, very strange, now it works again as it should...lotsaram wrote:Which version? Sounds like a bug.
I swear yesterday it didn't

Anyway many thanks for the attention.
Wim
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