*this content was updated on May 4, 2018 to fit with the recently updated backpack courses*
I am writing this post mainly for CT beginners that are working on building a cost transparency foundation project 1st backpack course in Apptio University. However, the concept and the formulas are the same in R11.
Understanding the Default Allocations in Apptio's Cost Transparency Application
In many, if not all cases, you will want to create your own allocations in your models but when you don't, you'll need to understand Cost Transparency's default or “out of the box” allocations.
The default CT allocations are based on a Data Relationship. This means when there are matching values in each column (on the sending object side and the receiving object side), the data tables can share information and dollars can flow. If there are not matching values, the dollars will not flow.
If you look at those columns in the master data tables (look in the Formulas step) you will see a formula. We need to make sure that the formulas are generating equal values or else our dollars will not flow.
Below is a table that shows the formula that is in the default allocation for getting dollars to flow from the Cost Source object to the Labor object. See the formula and then examples of what it generates for 2 different GL line items.
COST SOURCE MASTER DATA.Cost Source_Labor Key
LABOR MASTER DATA.Cost Source_Labor Key
Cost Source Master- Is Labor?
Cost Source Dollar
Flow from Cost Source to Labor Object?
=if(upper(Is Labor)="YES","Labor_Key"&&Cost Center&&Cost Pool&&Cost Sub Pool&&Labor Key Metafield,"CS_Labor_null")
="Labor_Key"&&Cost Center&&Cost Pool&&Cost Sub Pool&&Cost Source Key Metafield
Labor_Key – CC1565254222 – Internal Labor – Internal Labor –
Labor_Key – CC1565254222 – Internal Labor – Internal Labor -
This is especially important information to know when troubleshooting issues in your model.
Can you change those default allocations? Absolutely! And as mentioned above in many or most case you will want to do that based on your company data. You get a chance to do this in the 1st backpack too. So be sure to watch the Allocations video in the Videos and Documentation section of your backpack.
Happy Learning! :-)