Search found 83 matches
- Thu Aug 01, 2019 12:15 am
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Two sets of count in a dimension
- Replies: 1
- Views: 1776
Two sets of count in a dimension
Hello, I need to calculate revenue generated by buildings (a utility company) i.e. One building (parent) can have up to four types of services (child), electric, water, gas & BTU (number of services vary, some buildings only provide electric, or electric & water or electric & gas...can b...
- Mon Mar 19, 2018 8:23 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Model setup
- Replies: 2
- Views: 2060
Re: Model setup
Thank you so much Paulsimon for replying. I’m sorry that my question is not clear enough but you understood everything correctly. Your reply is so helpful and I really appreciate all the details you put in there especially the written rules. I will go implement these in TM1 for sure! Best regards, L...
- Sun Mar 18, 2018 6:31 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Model setup
- Replies: 2
- Views: 2060
Model setup
Hello I’m new to TM1 and trying to use TM1 to mimic my forecast model in Excel. In my excel model (forecast year 2018 to 2022) monthly revenue is calculated as number of units per building * admin fee per month per building however each building has a different billing start month, I.e. if a buildin...