TM1 Forum

Hi All,
Has any one used any form of goal seeking with a goal cube in TM1? Any pointers would be greatly appreciated.

Thanks,
Ashish

Btw just after posting this question, I realized this might be a very generic query - just like how to write a rule and FAQs section has cautioned against posting such generic queries, but I could not help in this case. I absolutely do not know anything about how to implement goal seeking in TM1 and I suspect that unless I get some basic understanding, I might not even be able to post my query any less generically then this.

Thanks,
Ashish

Goal seeking is an iterative function and can only be done procedurally. In Tm1 terms this means via TurboIntegrator. Although it's not that common I'm aware of a number of TM1 applications that use this approach where it's necessary and there is no other way to calculate the required result.

lotsaram wrote:Goal seeking is an iterative function and can only be done procedurally. In Tm1 terms this means via TurboIntegrator. Although it's not that common I'm aware of a number of TM1 applications that use this approach where it's necessary and there is no other way to calculate the required result.

Although not necessarily practical, it is possible to do this iterative type calculation with a combination of rules and dimensionality. I had a client once that that wanted to allocate expenses from a certain group of cost centers to other cost centers, and the group of cost centers that had allocations coming in had to also turn around and allocate them out. I wanted to do this in TI but they insisted on rules. The answer was to create a "Pass" dimension so that the initial amounts were in the "Base" element and then each round of allocations was in a "Pass" (Pass 1, Pass 2, Pass 3) where Pass 1 was the starting point for Pass 2, Pass 2 was the starting point for Pass 3, etc., until there was nothing left to allocate. This is bascially the same theory behind goal setting.