debug turbo integrator

Post Reply
nicola531
Posts: 43
Joined: Thu Oct 22, 2009 7:58 am
OLAP Product: TM1
Version: 9.5.1
Excel Version: 2007

debug turbo integrator

Post by nicola531 »

Hello everybody,

do you know if there is a way to debug a turbo integrator process?
in order to understand where I make errors on my process.

Actually I would like to know if there is printline to see the content of a variable.

Thanks ind advance for you help.

Nicola
Wim Gielis
MVP
Posts: 3233
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: debug turbo integrator

Post by Wim Gielis »

Hi there

You can use ASCIIOUTPUT to print a fixed text or the contents of a variable to a text file.

Some points to take into account:
  • The first argument of that function should be the file name. If you do not specify the path location, the database directory is used.
  • Separate with comma's what you would like to output in the text file.
  • The CMA file extension is often used for this kind of files.
  • Numeric data should be converted to a string if you want to output them using ASCIIOUTPUT. Use for instance the NumberToString function.
  • Depending on the version of TM1, make sure the length of 1 sentence in the output file is not too long.
  • Any ASCIIOUTPUT statement in the Metadata or Data tab to a file, will overwrite (hence, delete) that file. This means that an ASCIIOUTPUT statement in the Prolog tab to the same text file will not have the intended purpose.
  • I regularly use a temporary cube or dimension to hold data, and be able to evaluate the process. Delete the cube or dimension afterwards, or clear the area in the cube.
  • The ProcessQuit and ItemReject functions are also good tools to evaluate processes.
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
User avatar
Martin Ryan
Site Admin
Posts: 1989
Joined: Sat May 10, 2008 9:08 am
OLAP Product: TM1
Version: 10.1
Excel Version: 2010
Location: Wellington, New Zealand
Contact:

Re: debug turbo integrator

Post by Martin Ryan »

Hi Nicola,

Cubewise have a non-free third party app that can help with this.

(Disclaimer: I do a bit of work for them).

Martin
Please do not send technical questions via private message or email. Post them in the forum where you'll probably get a faster reply, and everyone can benefit from the answers.
Jodi Ryan Family Lawyer
Post Reply