ASCIIOUTPUT formate

Post Reply
mincharug.shulft
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

Post by mincharug.shulft »

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

Post by lotsaram »

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.
May I kindly suggest the following:
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);
Wim Gielis
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

Post by Wim Gielis »

You're too good for this world Lotsaram :-D

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
anoops81
Posts: 101
Joined: Tue May 12, 2009 8:20 am
OLAP Product: TM1
Version: 9.5.2
Excel Version: Office 2010

Re: ASCIIOUTPUT formate

Post by anoops81 »

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.
User avatar
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

Post by rkaif »

anoops81 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.
You are right but it was a joke from Wim Gielis :))
Cheers!
Rizwan Kaif
mincharug.shulft
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

Post by mincharug.shulft »

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?
mincharug.shulft
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

Post by mincharug.shulft »

lotsaram ,
i am sorry actually i was not expert like you ,i just started learning
however i would really handsup to your support.
lotsaram
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

Post by lotsaram »

This is explained in the product documentation (reference guide).
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.
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.
Wim Gielis
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

Post by Wim Gielis »

rkaif wrote:
anoops81 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.
You are right but it was a joke from Wim Gielis :))
:D :D
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
tomok
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

Post by tomok »

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.
"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!
Tom O'Kelley - Manager Finance Systems
American Tower
http://www.onlinecourtreservations.com/
anoops81
Posts: 101
Joined: Tue May 12, 2009 8:20 am
OLAP Product: TM1
Version: 9.5.2
Excel Version: Office 2010

Re: ASCIIOUTPUT formate

Post by anoops81 »

rkaif wrote:
anoops81 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.
You are right but it was a joke from Wim Gielis :))
Okkk ... :D I was thinking WTF...

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 :D :D
Post Reply