Page 1 of 1
Zero out portion vs viewzeroout.
Posted: Mon Jan 25, 2010 8:35 pm
by 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?
Re: Zero out portion vs viewzeroout.
Posted: Mon Jan 25, 2010 11:48 pm
by 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?
Re: Zero out portion vs viewzeroout.
Posted: Tue Jan 26, 2010 1:15 am
by 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
Re: Zero out portion vs viewzeroout.
Posted: Tue Jan 26, 2010 7:54 am
by 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