♦ Applies to:  Applications on TBM Studio 12.9

This article contains a downloadable spreadsheet (at the bottom of the page) that lists all the data set changes needed to upgrade from Template v107 to v109.  For the instructions that go with this spreadsheet, see Upgrade Cost Transparency to the Latest Template Version. 

The R12.9 Data Set Changes file (attached below) summarizes the following data changes for applications on TBM Studio 12.9:

New tables added in R12.9:

• Applications Addressable Master Data
• Cost Source to IT Resource Master Data
• Other Labor Allocations Master Data
• IT Towers Foundation Master Data
• CLDY Transform Master Data
• Service Demand Planned Quantity
• Service Demand Planned Unit Cost
• Service Demand Forecasted Quantity
• Service Demand Forecasted Unit Cost

New R12.9 columns added to existing tables

• Applications Master Data
  
  • Business Fit
  • Business Fit Description
  • Technical Fit
  • Technical Fit Description
• Servers Master Data
  
  • IT Resource Tower
  • IT Resource Sub Tower
  • Spend Category
  • Savings Category Override
  • Is CSP
• Tickets Master Data
  
  • Application Name
  • Spend Category
  • Savings Category Override
• Storage Master Data
  
  • IT Resource Sub Tower
  • Spend Category
  • Savings Category Override
  • Is CSP
• Fixed Asset Master Data
  
  • Application ID
  • Application Name
  • Cost Pool
  • Cost Sub Pool
  • Spend Category
  • Savings Category Override
• IT Resource Towers Master Data
  
  • Application ID
  • Application Name
  • Cost Center
  • Cost Pool
  • Cost Sub Pool
  • Driver Type
  • Foundation Required Relationship
  • Is Labor
  • Object
  • Savings Category
  • Spend Category
  • Foundation Towers Installed
  • IT Resource Tower Type
• Labor Master Data
  
  • Application ID
  • Application Name
  • Spend Category
  • Savings Category Override
• Projects Master Data
  
  • Is Labor
  • Spend Category
  • Savings Category Override
• Time Tracking Master Data
  
  • Cost Center Name
  • Application ID
  • Application Name
  • Cost Sub Pool
  • Spend Category
  • Savings Category Override
• Vendor Master Data
  
  • Cost Center Name
  • Application ID
  • Application Name
  • Cost Center
  • Cost Pool
  • Cost Sub Pool
  • Is Labor
  • Spend Category
  • Savings Category Override
  • Project ID
• Contracts Master Data
  
  • IT Resource Tower
  • Is Labor
  • IT Resource Sub Tower
  • Spend Category
  • Savings Category Override
  • Hardware Contract
  • Software Contract
• Contracts to Applications Master Data
  
  • Application Name
  • OID Metafield
• All Business Services
  
  • Forecasted Cost
  • Forecasted Quantity
  • Planned Cost
  • Planned Quantity
• Business Unit Allocation Master Data
  
  • Forecasted Cost
  • Forecasted Quantity
• Apptio Value Explorer
  
  • Summary Use Case
  • Summary Use Case Description
  • New Product Name