TBM Workgroups

Expand all | Collapse all

How to specify drivers while allocating in the model

  • 1.  How to specify drivers while allocating in the model

    Posted 04-26-2020 22:57

    Hi Team, i have a scenario as below.

     

    we have an object O1, with various drivers say D1,D2,D3,D4 and we need to allocate the cost from O1 to object O2 but only the cost coming from D1,D2,D3. could you please let us know how to achieve this in the R12 model?

     

    we appreciate any quick assistance.



  • 2.  Re: How to specify drivers while allocating in the model

    Posted 05-15-2020 15:53

    Hi Team, does anyone have suggestion for the question?



  • 3.  Re: How to specify drivers while allocating in the model

    Posted 07-14-2020 20:57

    Create a new field called [Allocation Origin] within your O1 table. Create duplicates of the existing rows and adjust numeric values where needed so you don't get a larger value. The difference with each of the duplicated rows is the [Allocation Origin] field. Your duplicated row count for each unique object item would be equal to how many distinct [Allocation Origin] values you need.

     

    EXAMPLE

    • Originally, App object has 3 unique rows.
    • [Application Origin] values were needed for "Servers", "Projects" and "Other".
    • App object now has 9 rows (3 original rows X 3 unique [Allocation Origin] values).
    • Rows with [Allocation Origin] equal "Other" retained all numeric values. All other rows had their numeric values set to zero (to avoid skewing).
    • When allocating from the "Servers" object, the To condition includes criteria to target App object rows where [Allocation Origin] equals "Servers".
    • When allocating from the "Projects" object, the To condition includes criteria to target App object rows where [Allocation Origin] equals "Projects".
    • When allocating from any other object, the To condition includes criteria to target App object rows where [Allocation Origin] equals "Other".