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

TM1 Best practice

Started by bloggerman, 12 Aug 2011 07:13:39 PM

Previous topic - Next topic

bloggerman

Does Tm1 precalculate the numbers and store or does it on demand when we run a report like DMR. I am assuming it should behave like transformer

dssd


dusherwo

The answer is both  :D
When a client app asks for data from TM1, it calculates and delivers the data, then stores the values in server RAM until data changes (in that cube or in a cube affecting that cube).
There is a precalculate Turbo Integrator function ViewConstruct. From our tests (admittedly on an earlier version) it made reporting quicker, but not instant (which a fully calculated TM1 view should be after it is first used).
So be careful to manage user input if you want good performance.