TI process to read out a string-calculated cell

Post Reply
Wim Gielis
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

Post by Wim Gielis »

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

Post by jstrygner »

This ASCIIOutput is in Prolog/Epilog, or is on Metadata/Data and cubeview is the source for TI?
Wim Gielis
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

Post by Wim Gielis »

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

Post by lotsaram »

Which version? Sounds like a bug.
Wim Gielis
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

Post by Wim Gielis »

lotsaram wrote:Which version? Sounds like a bug.
Hmmm, very strange, now it works again as it should...
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
Post Reply