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
Even i had the same query
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.