If you are unable to create a new account, please email support@bspsoftware.com

 

News:

MetaManager - Administrative Tools for IBM Cognos
Pricing starting at $2,100
Download Now    Learn More

Main Menu

View Zero out

Started by Atif.Hameed, 03 Nov 2010 08:36:23 AM

Previous topic - Next topic

Atif.Hameed

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.

guntu


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.