ASCIIOUTPUT formate
-
- Regular Participant
- Posts: 155
- Joined: Fri May 20, 2011 8:17 am
- OLAP Product: Applix,Cognos TM!
- Version: applix9.0Cognos tm1 9.5.1
- Excel Version: Excel 2010 2007
ASCIIOUTPUT formate
Hi All,
I have asciioutput like this
asciioutput('exit.log',str_datum | ' ' | cube,
str_datum | ' '|cube1,
str_datum |' '|cube2 |);
And my out is
exit.log with below format
20120530145735 b_testuser3_ce,20120530145735 }ElementAttributes_b_testuser3_ce,20120530145735 }ElementAttributes_memo_b_testuser3_ce
BUT I want to see my out below format (means one below one)
20120530145735 b_testuser3_ce,
20120530145735 }ElementAttributes_b_testuser3_ce,
20120530145735 }ElementAttributes_memo_b_testuser3_ce
How to get one below one –is there any function in TI to get the above ?
Thanks for advance.
I have asciioutput like this
asciioutput('exit.log',str_datum | ' ' | cube,
str_datum | ' '|cube1,
str_datum |' '|cube2 |);
And my out is
exit.log with below format
20120530145735 b_testuser3_ce,20120530145735 }ElementAttributes_b_testuser3_ce,20120530145735 }ElementAttributes_memo_b_testuser3_ce
BUT I want to see my out below format (means one below one)
20120530145735 b_testuser3_ce,
20120530145735 }ElementAttributes_b_testuser3_ce,
20120530145735 }ElementAttributes_memo_b_testuser3_ce
How to get one below one –is there any function in TI to get the above ?
Thanks for advance.
-
- MVP
- Posts: 3704
- Joined: Fri Mar 13, 2009 11:14 am
- OLAP Product: TableManager1
- Version: PA 2.0.x
- Excel Version: Office 365
- Location: Switzerland
Re: ASCIIOUTPUT formate
May I kindly suggest the following:mincharug.shulft wrote:Hi All,
I have asciioutput like this
asciioutput('exit.log',str_datum | ' ' | cube,
str_datum | ' '|cube1,
str_datum |' '|cube2 |);
And my out is
exit.log with below format
20120530145735 b_testuser3_ce,20120530145735 }ElementAttributes_b_testuser3_ce,20120530145735 }ElementAttributes_memo_b_testuser3_ce
BUT I want to see my out below format (means one below one)
20120530145735 b_testuser3_ce,
20120530145735 }ElementAttributes_b_testuser3_ce,
20120530145735 }ElementAttributes_memo_b_testuser3_ce
How to get one below one –is there any function in TI to get the above ?
Thanks for advance.
1/ Stop
2/ Think
3/ Type
As opposed to going straight to item 3 and typing without stop and think.
I believe this should do what you want. I also believe that with 15 seconds devoted to stop and think you would be able to come up with this yourself.
asciioutput('exit.log',str_datum | ' ' | cube);
asciioutput('exit.log',str_datum | ' '|cube1);
asciioutput('exit.log',str_datum |' '|cube2);
-
- MVP
- Posts: 3235
- 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: ASCIIOUTPUT formate
You're too good for this world Lotsaram 
Next question: Help, my records are eaten up!
I put an ASCIIOUTPUT in the Metadata tab and an ASCIIOUTPUT in the Data tab and now I don't see the Metadata tab records!

Anyways, back to work again.

Next question: Help, my records are eaten up!
I put an ASCIIOUTPUT in the Metadata tab and an ASCIIOUTPUT in the Data tab and now I don't see the Metadata tab records!

Anyways, back to work again.
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: 101
- Joined: Tue May 12, 2009 8:20 am
- OLAP Product: TM1
- Version: 9.5.2
- Excel Version: Office 2010
Re: ASCIIOUTPUT formate
If you use the ASCIIOutput function to write to the same file in multiple procedures (tabs) of a TurboIntegrator process, the file will be overwritten each time it is opened for a new procedure.
- rkaif
- Community Contributor
- Posts: 328
- Joined: Fri Sep 05, 2008 6:58 pm
- OLAP Product: IBM Cognos TM1
- Version: 9.1 or later
- Excel Version: 2003 or later
Re: ASCIIOUTPUT formate
You are right but it was a joke from Wim Gielisanoops81 wrote:If you use the ASCIIOutput function to write to the same file in multiple procedures (tabs) of a TurboIntegrator process, the file will be overwritten each time it is opened for a new procedure.

Cheers!
Rizwan Kaif
Rizwan Kaif
-
- Regular Participant
- Posts: 155
- Joined: Fri May 20, 2011 8:17 am
- OLAP Product: Applix,Cognos TM!
- Version: applix9.0Cognos tm1 9.5.1
- Excel Version: Excel 2010 2007
Re: ASCIIOUTPUT formate
I have its almost same scenario.
I have an asciioutput file which is there in the prolog.
Whenever TI runs it’s over writing content which is there in the .txt BUT I don’t want to over the content so whenever TI runs the content has to add not to over write.
Is it possible?
I have an asciioutput file which is there in the prolog.
Whenever TI runs it’s over writing content which is there in the .txt BUT I don’t want to over the content so whenever TI runs the content has to add not to over write.
Is it possible?
-
- Regular Participant
- Posts: 155
- Joined: Fri May 20, 2011 8:17 am
- OLAP Product: Applix,Cognos TM!
- Version: applix9.0Cognos tm1 9.5.1
- Excel Version: Excel 2010 2007
Re: ASCIIOUTPUT formate
lotsaram ,
i am sorry actually i was not expert like you ,i just started learning
however i would really handsup to your support.
i am sorry actually i was not expert like you ,i just started learning
however i would really handsup to your support.
-
- MVP
- Posts: 3704
- Joined: Fri Mar 13, 2009 11:14 am
- OLAP Product: TableManager1
- Version: PA 2.0.x
- Excel Version: Office 365
- Location: Switzerland
Re: ASCIIOUTPUT formate
This is explained in the product documentation (reference guide).
This limitation has certainly been discussed elsewhere here on this forum. To save you the effort of searching basically if you want to capture custom log output from separate "procedures" (in other words "advanced" code tabs) then there is no option except to declare separate output file names for each procedure and then if you want it all in one file to use a batch file and executecommand to concatenate the files together.ASCIIOutput
This is a TM1® TurboIntegrator function, valid only in TurboIntegrator processes.
This function writes a comma-delimited record to an ASCII file.The ASCII file is opened when the first record is written, and is closed when the TurboIntegrator procedure (Prolog, Metadata, Data, or Epilog) containing the ASCIIIOutput function finishes processing.
......
If you use the ASCIIOutput function to write to the same file in multiple procedures (tabs) of a TurboIntegrator process, the file will be overwritten each time it is opened for a new procedure.
-
- MVP
- Posts: 3235
- 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: ASCIIOUTPUT formate
rkaif wrote:You are right but it was a joke from Wim Gielisanoops81 wrote:If you use the ASCIIOutput function to write to the same file in multiple procedures (tabs) of a TurboIntegrator process, the file will be overwritten each time it is opened for a new procedure.)


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: 2836
- Joined: Tue Feb 16, 2010 2:39 pm
- OLAP Product: TM1, Palo
- Version: Beginning of time thru 10.2
- Excel Version: 2003-2007-2010-2013
- Location: Atlanta, GA
- Contact:
Re: ASCIIOUTPUT formate
"Give a man a fish, and you feed him for a day; show him how to catch fish, and you feed him for a lifetime". You really are not doing yourself any favors just asking everyone else how to do something, especially when the answer is in the manuals. The only way to become an expert is to struggle and figure things out for yourself. Only come and ask when you've exhausted all other options, including using the search feature on this site!mincharug.shulft wrote:lotsaram ,
i am sorry actually i was not expert like you ,i just started learning
however i would really handsup to your support.
-
- Posts: 101
- Joined: Tue May 12, 2009 8:20 am
- OLAP Product: TM1
- Version: 9.5.2
- Excel Version: Office 2010
Re: ASCIIOUTPUT formate
Okkk ...rkaif wrote:You are right but it was a joke from Wim Gielisanoops81 wrote:If you use the ASCIIOutput function to write to the same file in multiple procedures (tabs) of a TurboIntegrator process, the file will be overwritten each time it is opened for a new procedure.)

Wim Gielis, who is currently a Business Intelligence consultant , responsible for implementing custom IBM Cognos TM1 applications And he don't know this ??
I was feeling soo proud about myself

