Why tm1

And the nice charts. If things ever get out of control really big and you have multiple servers in multiple environments say, more than 10 machines , it might be worth having a look at configuration management tools that will allow you to:. Save my name, email, and website in this browser for the next time I comment. TM1 at Scale. April 30, Parallel TI Execution framework A famous one. TM1 combines the freedom, flexibility and familiarity of spreadsheets with the power and control of an enterprise database.

TM1 uses the same cell-oriented concepts as spreadsheets, but can support collaboration among thousands of users, using terabytes of data and deeply complex modelling to match real-world business needs. He designed TM1 from the ground up specifically to solve complex, forward-looking business modelling problems associated with budgeting, forecasting and financial reporting.

In this way, TM1 is a natural evolutionary step after spreadsheets — providing the intuitive power and flexibility of spreadsheets and scaling it to the enterprise.

Like spreadsheets, TM1 is valuable to business users because it allows them to combine multiple data sources along with user input to create the business models that underpin real business decision making.

You get instant results because TM1 is smart enough to calculate only the changes quickly in memory, and not have to recalculate the entire data model every time a value changes. Any user makes a change and everyone sees the result instantly. This allows for coordinated and fast collaboration.

No waiting. You get much more time for further collaboration and analysis of your business. It can also be deployed using a hybrid of on premise and cloud as required. Exploring TM1. Turbo Integrator. What is TM1 and Planning Analytics? History, Components and Uses. The gods and the photo of me stuck in the centre of the Iboglix development team's dartboard know that I'm never reluctant to lay criticism, but I like to think that I keep it to situations where it's warranted.

I'm afraid that your examples aren't it. It has the best integration with Excel of any product that I can think of. Active forms take over entire rows? Of course they do, there's no other realistic way of making them work within the nature of an Excel worksheet. This necessarily involves both deleting and inserting rows as required. If you want to have a pretty chart or something off to the right of it say that's fine, but first of all if it's tied to the data in the active form then I'd hate to see the code needed to get it to display properly when the number of source rows are variable.

That's an Excel thing, not a TM1 thing. If the number of source rows aren't variable, then you don't use an active form, you use a fixed block of DBRWs. That way you can have whatever your heart desires on either side of them. The fact that active forms can have multiple sections and that you can have multiple forms on a worksheet, all dynamically restructuring the sheet on the fly and doing it at quite remarkable speed including formatting the newly created rows in almost any way you want based on criteria that you can set yourself, with the only requirement that you give it a free hand on its own rows, makes it a remarkable piece of technology.

Think about it for a minute.