COGNOiSe.com - The IBM Cognos Community

Planning & Consolidation => TM1 => Topic started by: Atif.Hameed on 03 Nov 2010 08:36:23 AM

Title: View Zero out
Post by: Atif.Hameed on 03 Nov 2010 08:36:23 AM
Hi this is my first post in this forum. I have scanned through most of the posts and have found some valuable information so Thank you for that.

I am a TM1 developer and I would consider my expertise at intermediate to advanced level.

My question is about Zero out views. I have a process that has a a zero out view. The data that I am trying to zero out is just base level data. I checked the usual if there was  rule, consolidation etc and its just flat data that should clear out. when i run the process I see the record counts but the data doesn't clear. When I try clearing the data using the spread it clears just fine. Very Strange and Scary

Has anyone seen this before. Please let me know. Thanks.
Title: Re: View Zero out
Post by: guntu on 08 Nov 2010 11:46:12 PM

Hi Atif,

pls check below options:

select the top left corner cell of the portion to zero out
right click: Data Spread->Repeat
set value box to 0 and tick boxes Extend "right" and "down"

- from a TI process
in the prolog tab:
ViewZeroOut('Cube','View');

setup the 'View' to zero out then run that process

Please Confirm if its working or not!!

Regards,
Rajesh G



Quote from: Atif.Hameed on 03 Nov 2010 08:36:23 AM
Hi this is my first post in this forum. I have scanned through most of the posts and have found some valuable information so Thank you for that.

I am a TM1 developer and I would consider my expertise at intermediate to advanced level.

My question is about Zero out views. I have a process that has a a zero out view. The data that I am trying to zero out is just base level data. I checked the usual if there was  rule, consolidation etc and its just flat data that should clear out. when i run the process I see the record counts but the data doesn't clear. When I try clearing the data using the spread it clears just fine. Very Strange and Scary

Has anyone seen this before. Please let me know. Thanks.