Page 1 of 1
Percentage based allocation
Posted: Wed May 08, 2013 9:37 am
by roy2087
Hi, Can anyone suggest how to apply percentage based allocation logic in Cogos Tm1?
(User hase to put target amount that need to get allocated on certain allocation Percentage)
Thanks in advance.
Re: Percentage based allocation
Posted: Wed May 08, 2013 10:32 am
by rmackenzie
One fairly standard approach is to have a second cube holding the percentages that is used in a cube rule:
Code: Select all
['$ allocated'] = N: DB ( 'Cube1', !Dimension1, !Dimension2, !Dimension3, '$ before allocation' ) *
DB ( 'Percentage Lookup', !Dimension2, 'Percentage' );
Note in this abstract example, '$ allocated' and '$ before allocation' are elements in the measure dimension of 'Cube1'. Note that 'Cube1' and 'Percentage Lookup' have a shared dimension which facilitates the look-up. The feeder would be:
Code: Select all
['$ before allocation'] => ['$ allocated'];
I wonder if you've read these
guidelines regarding asking questions on the forum. To get a better answer to your question, you should supply more information regarding the set-up of your cubes (including names, dimensions, dimension order etc), any rules you've already written, and a brief explanation of the business problem. As it stands, you've got a very general answer to a very general question. HTH.