IBM Apptio

https://www.ibm.com/docs/en/apptio
Admin
IBM Apptio provides solutions for technology business management, helping organizations manage and...
Tokens:120,066
Snippets:1,125
Trust Score:10
Update:10 months ago
Show doc for...
Tokens:
Raw
### AI Cost Model Formula Example

Source: https://www.ibm.com/docs/en/apptio/-commercial/costing-standard/saas_topic=ai-tco-configuration-guide

This formula defines the core AI Cost model metric. It filters cost sources to include only OPEX Actuals (Fixed and Variable) and sums the AI Amount. It also filters for AI expenditure using the AI Tablematch.

```Formula
If(Cost Source Master Data.Cost Source Model Driver IN (“OPEX – ACTUALS – FIXED”, “OPEX – ACTUALS – VARIABLE”), Cost Source Master Data. AI Amount),0) Note: Filtered for AI expenditure, via AI Tablematch
```

--------------------------------

### Editable Table - Hourly Publish Schedule Option

Source: https://www.ibm.com/docs/en/apptio/-commercial/tbm-studio/saas_topic=releases-2024

Introduces an 'Hourly' option for the recurring publish schedule of an editable table, allowing hourly execution. This helps maintain accurate information during daylight savings time transitions. The start time can be adjusted for precise scheduling. This replaces previous methods of selecting daily recurrence with multiple start times.

--------------------------------

### Example Lookup Function Formula for Fixed/Variable Field

Source: https://www.ibm.com/docs/en/apptio/-commercial/costing-standard/saas_topic=upload-map-costing-standard-foundation-data

This formula demonstrates how to use the Lookup function within a spreadsheet or application to determine the 'Fixed/Variable' status for a given 'Account'. It references a 'Chart of Accounts Mapping' table, matching 'Account' numbers to their corresponding 'Fixed/Variable' classification.

```spreadsheet
=Lookup(Account,Chart of Accounts Mapping,Account,{Fixed/Variable})
```

--------------------------------

### AI Solution Users to Business Services Formula

Source: https://www.ibm.com/docs/en/apptio/-commercial/costing-standard/saas_topic=ai-tco-configuration-guide

This formula calculates the distribution of AI Solution Users to Business Services. It handles cases where direct mapping is zero, by using a fallback of 'All Business Services.AI Solution Total Users Prep'.

```Formula
If({AI Solution Users to Business Services (AI Platforms- AI Solution Users driver) }=0,{All Business Services.AI Solution Total Users Prep},0)
```

--------------------------------

### Map Account and Amount for Cost Source Master Data

Source: https://www.ibm.com/docs/en/apptio/-commercial/planning-standard/saas_topic=costing-configure-apptio-integration-datasets

Provides mappings and formulas for appending budget and forecast data to the Cost Source Master Data. This includes translating account, amount, and cost center information, and deriving additional fields like Is Labor and Is Project.

```table
Master Data field| Value  
---
Account| =Account  
Account Description| =Account Description  
Account Group| =lookup(Account, Account Master, Code, Account Group)  
Account Subgroup| =lookup(Account, Account Master, Code, Account Subgroup)  
Amount| =Amount  
Cost Center| =Cost Center  
Cost Center Name| =Cost Center Description  
Cost Center Owner| =Lookup(Cost Center, Department Master, Code, Cost Center Owner)  
Cost Pool| =Lookup(Account, Account Master, Code, Cost Pool)  
Cost Sub Pool| =Lookup(Account, Account Master, Code, {Cost Sub-Pool})  
Discretionary/Non-Discretionary| =Lookup(Account, Account Master, Code, {Discretionary/Non-Discretionary})  
Expense Type| =Expense Type  
Fixed Variable| =Lookup(Account, Account Master, Code, {Fixed/Variable})  
Is Labor| =IF(Cost Pool IN ("Internal Labor", "External Labor"), "Yes", "No")  
Is Project| =IF(Project ID="", "No", "Yes")  
Is Vendor| =IF(Vendor ID="", "No", "Yes")  
Journal ID| =Journal ID  
Journal Line| =Line Description  
Journal Line ID| =Journal ID  
Owner| =Lookup(Cost Center, Department Master, Code, IT Owner)  
Project ID| =Project ID  
Project Name| =Project Name  
Vendor ID| =Vendor ID  
Vendor Name| =Vendor Name  
```
Tokens:
Raw