Thank you for your feedback.
Form temporarily unavailable. Please try again or contact to submit your comments.

Create a cost model with the Cost Model form

Log in to subscribe to topics and get notified when content changes.

Create a cost model with the Cost Model form

You can create multiple cost models to process allocations. Use the Cost Model form to configure all possible settings available to the cost model.

Before you begin

Role required: cost_transparency_admin

About this task

You can select a cost model in The Data Definition stage when you set up allocations. You can also create a basic cost model from the workbench.


  1. Navigate to Financial Modeling > Cost Models > All.
  2. Click New.
  3. Fill in the form fields (see table).
    Figure 1. Financial Model form
    The financial model form
    Table 1. Financial Model form fields
    Field Description
    Name Name of the cost model.
    Description Description of the cost model.
    Used by Cost Allocation Check box to specify if the model is to be used for cost allocation.
    Model Owner The user who created the cost model.
    Data Source The source from where the data is taken.

    Data Source field is editable until financial modeling actions are not done.

    The application is preconfigured to point to the Budget Staged table as a data source for the Default Budget Cost Model as it is linked to ITFM Budget staged expenses.

    You also have the option not to select a data source. In such a case, the Workbench stages will not have the data cleansing stage as there is no financial data source to pull the expense lines from. Amounts would then be keyed in manually at the bucketing stage.

    Choose Segments for GL Expense Lines The Choose Segments for GL Expense Lines field is available only when Generate Controlled Cost Lines check box is enabled. You can choose segments to generate the GL expense lines in the itfm_allocation table.
    Carry Fields in GL Expense Lines Configure the data source fields that you want to carry over from the bucketing stage to the grooming and allocation stages.

    By default, the data source fields that are set Used for Bucket split as ‘true’ will be carried over from the financial data source General Ledger Staged table.

    Used by Budgeting Check box if the model is being used for budgets.
    Cost Transparency
    Fiscal Unit Defines the fiscal unit to be a month, quarter, or a period based on the fiscal calendar.
    Generate Controlled Cost Lines

    (Recommended). Helps in performance and saves database space.

    Check box to generate minimal cost lines aggregated at the account level only, in the itfm_allocation_aggregate table.

    You can define specific breakdown relationship between the segments required for business. Additional breakdown lines are generated in the itfm_allocation_breakdown table between the segments.

    Include Sub-Bucket info The Include Sub-Bucket info check box option is available when Generate Controlled Cost Lines check box is selected.

    If enabled, the generated cost lines and breakdown lines will hold sub-bucket information.

    User Group The user group selected is associated with the cost model. This restricts the cost model being accessed by other user groups who are not associated with the user group of type ITFM.

    Users with cost_transparency_analyst role can access default cost model and the cost model associated to his/her user group only.

    Users with cost_transparency_admin and system administrator roles can access all the cost models, including the default cost model.

    If the Used by Budgeting check box is enabled for the cost model, then users with appropriate budgeting role can view all the budget models.

    If the cost model is used for purposes of both budgeting and generating cost allocation lines, that is, if Used by Cost Allocation and Used by Budgeting check boxes are enabled, then the cost model can be accessed by all users.

  4. Click Submit.
  5. To download the cost model, click Download Cost Model button.

    You can download the cost model for the purpose of uploading it to, or deploying it in another instance to do cost modeling in a different pre-production environment. You can later move the cost model to other production environments.

    With the ability to download the cost model you can also download all the related tables of the cost model and the related elements such as segment definition and hierarchy, buckets, cleansing and grooming conditions, bucket allocations, rollups and rollup overrides, and consumption metrics.

What to do next

The buckets that use this cost model are shown in the Buckets related list.

You can also create an account bucket.

Map a unit cost metric to a segment of a cost model to generate unit costs.

The breakdown relationship to explicitly generate breakdown cost lines in the itfm_allocation_breakdown table for a given segment-segment mapping are shown in the Breakdown Relationships related list.

You can also define a sibling relationship to roll up accounts at the sibling level.