Zero out portion vs viewzeroout.

[John Hammond]

Hi

I have just tracked a reconciliation problem down to TM1 view clearing technology.

TI tabs > maps > cube > zeroout portion DOES NOT WORK

but

viewzeroout in the prolog DOES.

Has anyone else encountered this problem? NB My view to be zero'ed out was called 'All' so did I hit some keyword problem or is this zeroout on the TI tabs just flakey?

[lotsaram]

Hi John,

All that the TI mapping wizard does is to write code for you (and not very good code, there is plenty on that topic on this forum ...)
Have a look at the prolog under the advanced tab on the process you have used the mapping wizard on, has a ViewZeroOut command been inserted? Have you selected the correct view that you wanted to zero out?

[Martin Ryan]

Bear in mind when you use the wizard that the automated code in the Prolog/Metadata/Data/Epilog tabs is only generated when you click on the tabs. This means that if you make any changes to the Data Source/Variables/Maps tabs (including the viewzeroout info) you need to go to the Advanced tab, then click on each of the Prolog/Metadata/Data/Epilog tabs to ensure the code is updated.

As lotsa alludes to, most TM1 users prefer to avoid the wizard after they have built up the skills to type the code in themselves.

Martin

[John Hammond]

Thanks Martin and Lotsaram

I always wondered why I saw people clicking on all the tabs when they ran a TI process. Will look for the code next time as of course TM generates code and doesn't do things by magic!

John