TM1 Forum

Hello gurus

I am kind of new to TM1 hence seeking your help.
I have a question on TM1 cube development, I am clear about creating dimensions, cube and loading the data. In my requirement also includes that user has to feed budget information for current year so system should forecast for next 5 years based on the history.

Here are my questions

1. How can I create a entry page for user input (budget)
2. help me in understanding the calculation in forecasting budget based on the history?

I really appreciate your help

Thanks
MK

That's an incredibly open-ended question. I don't know how much help you are going to get from this forum without narrowing your questions down. I could write a book just about your second question itself. Think of TM1 like a multi-dimensional Excel spreadsheet. Just like you can decide how you want to forecast data based on history and then in Excel write the formula(s) to do that, so can you in TM1. The only difference is in TM1 there more than two-dimensions (most likely) and the formula writing part is a different programming language than A1 = B1 + C1.

My recommendation on the forecast question is to think about how you want the relationship between history and the future to work, formula-wise, and then build a spreadsheet to do just that. Then all you'll have to do in TM1 is to figure out how that relationship works including the other dimensions in the cube and then how to write the code. The TM1 Rules Guide should help with writing the code. For that matter, you really should read all the TM1 documentation. I am going to guess, based on your questions, that you haven't taken the time to do that. I know it is somewhat overwhelming but skipping that step and running to the forum for help will probably not be very fruitful for you. Most people, including me, are more inclined to help someone who's made an effort to give it a go themselves.