Search found 83 matches

by lynnsong986
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...
by lynnsong986
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...
by lynnsong986
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...