TM1 Forum

I am becoming comfortable in Turbo Integator, and have started writing my own code. Whoo-hoo!

I want to know if I can make it skip a generated statement, which throws out an error.

I am using TI to transfer a calculated result from last year (DecTotal) into an OpeningBal of this year. That works great in the code that I wrote after the generated statement.

However, in the generated statement part it attempts to write DecTotal of the old years cube into the new years cube, which does not work because DecTotal is a calculated value. I would like TI to totally skip that line of code, but it won't let me even comment out that line.

Any advice?

Carolyn,

I am unsure what you really need the generated statements for in this case. You could probably get whatever you need using the prolog and epilog tabs to generte views which could create/delete views you could use for this load. I don't know of a way to populate anything within the generated statements themselves. If you need any assistance or more clarity regarding how to construct the views, just reply.


Steve

Carolyn wrote:I want to know if I can make it skip a generated statement, which throws out an error.

Take out the code behind the generated statement.

Carolyn wrote:I am becoming comfortable in Turbo Integator, and have started writing my own code. Whoo-hoo!

I want to know if I can make it skip a generated statement, which throws out an error.

I am using TI to transfer a calculated result from last year (DecTotal) into an OpeningBal of this year. That works great in the code that I wrote after the generated statement.

However, in the generated statement part it attempts to write DecTotal of the old years cube into the new years cube, which does not work because DecTotal is a calculated value. I would like TI to totally skip that line of code, but it won't let me even comment out that line.

Any advice?

1. Copy your generated statements to below the generated statements area (on each "advanced" tab)
2. Go back to the variables tab and make each variable type "other"
3. Now go back to the advanced tabs and add in error handling, edit your code, whatever.

Note that this is an INTERIM strategy for you. Ideally you would not be using the wizard at all to generate code but be writing the code from scratch. The wizard has severe limitations when it comes to doing anything with more than a 0.1 degree of difficulty. (In your case though you might just be able to edit the processing view to skip calculated values, over time though you should learn to construct the views programatically as well.)