Clear the data in an existing view

Introduction

A frequently used procedure within Turbo Integrator processes, is a zero out code. This means erasing all data that are part of a view. You can zero out an existing view (as shown in this article), or you can zero out a view that you set up with TI code.

TI code

The syntax is pretty simple. Put in the Advanced > Prolog tab:

VIEWZEROOUT(name of the cube,name of the view);

For instance: VIEWZEROOUT('Capex','all 2010 data');

Disadvantage

This way of proceeding has one big disadvantage. The view physically exists in the database, and generally uses a large amount of memory when opened. TM1 end users could browse to the large view, open it and thereby increase the memory used on the TM1 server (often drastically in case of a large view). In such cases, it is far better to set up the view using TI code, perform the zeroout and destroy the view again. Look at other TM1 articles on this website to find custom code. Alternatively, set the view as Private and at least give it a name with prefix ‘ZZZ_’ for example. Then, it is listed at the bottom of the alphabetically sorted list of views on any given cube.




Homepage

Section contents

About Wim

Wim Gielis is a Business Intelligence consultant and Excel expert

Other links