Use of Tm1 Views

[manu0521]

I know we use tm1 views to viewzero out data or clear data in the cube based on the view.

What is the advanatage of having views, is it temporary storage? and how does it work in relation to view zero out. Does it ensure data validation by zeroing out and adding back specific data.

Thanks,

[David Usherwood]

I know we use tm1 views to viewzero out data or clear data in the cube based on the view.

What is the advanatage of having views, is it temporary storage? and how does it work in relation to view zero out. Does it ensure data validation by zeroing out and adding back specific data.

How would you propose to clear the cube area without defining a view?
What makes you think that viewzeroout 'adds back specific data'? It clears the area of the cube defined by a view.

[Wim Gielis]

Having large views for doing zeroouts manually (on the cube itself) is not a good practice.
Chances are that a user opens up such views and consumes a lot of memory.
Better would be to script certain zeroouts in Turbo Integrator, building up temporary views and subsets, doing a zeroout, and then destroying the views and subsets again.

If you do not use the views, they do not take up memory. Don't have them sitting around in the TM1 database.

[RJ!]

Hi Wim,

Does that mean that when you've restarted TM1 Service, that TM1 will trawl through all of your Views and load them into Memory?
Or does the view only go into memory once a user/process calls the view?

If so, might explain some of our growing Cube issues...

[David Usherwood]

Views are not automatically loaded into memory on startup. If you want this to happen (and it will help performance for users) you should specify a startup chore to include a set of ViewConstruct commands.

[Wim Gielis]

Hi Wim,

Does that mean that when you've restarted TM1 Service, that TM1 will trawl through all of your Views and load them into Memory?
Or does the view only go into memory once a user/process calls the view?

If so, might explain some of our growing Cube issues...

As David pointed out, this cannot be the reason of growing cube sizes. That has got to be something different.

[RJ!]

Thanks guys, that was my thinking as well, just wanted to check!