the standard metric of cost per server only takes into consideration the IT tower Compute and divides it amongst the count of servers. I push other costs to servers, like storage, data center (like rent and utilities) as well as my NOC labor (which is in the delivery tower). I'm trying to calculate an all-in cost per server but I'm stuck. I need to somehow build a report on the server model object which houses all of those costs, but uses my server count (and my server RAM) as the denominator so I can come up with an all-in cost per server, not just at the compute tower level. 

Kyle,

Depending on how you would like to see the costs you could do the following.  I am assuming based on the comment that you pushed other costs to the Servers Object (i.e. Storage, Data Centers, and Delivery) you could do it a couple of ways.

1. You could create a report starting at the Servers object and drill down to the IT Resource Tower \ Sub-Tower to show the breakup of costs for each server.  This way it will show the Data Center, Storage, and Delivery costs (not to mention the compute costs). 

2. If you wanted to see which costs were coming to each object without drilling to the IT Resource Towers you could pull in the Drivers (and pull in the Storage driver, Data Center Driver, and Delivery Driver (from the IT Resource Towers)

Here is where you can find the driver.  If you select the object (i.e. Servers) you can see all the drivers that are sending cost into it.  

Hey Kyle,

Agreed with Ryan's comments above. Just to add a little bit:

Not sure what version of Apptio you are on, but in the latest version the 'Cost Per Server' metric is as follows:

=Cost/Servers Master Data.Server Count

The numerator utilizes the 'Cost' metric, which is a model metric (thus reporting off of the 'Cost' model) and will actually take into account all of the costs going into the particular object you are reporting off of . As expected, denominator will leverage 'Server Count'. If you're on an older version and your metric is different, I would recommend to create a metric that leverages the above calculation and I think it should get you exactly what you are looking for.

Definitely comment further if we can give additional clarity. 

Thanks,

Justin Zack

that does help, however I'd like two things. We have both Windows and Unix servers, and the costs are quite a bit different, so I'd like to report on cost per server at the Windows and Unix levels (which are both in the object). And also, rather than just reporting cost per server, I want cost per server GB of RAM. Maybe I will play with building and amending that metric as well as filters to see if I can get it to show me what I want.

the additional layer of complexity is that in my server master data set, I have both budget and actual servers, and I only want the server counts/server RAM to include ACTUAL servers, but at the moment it's pulling in ALL server counts. 

I didn't before, but I do now!

Hey Kyle,

Makes sense! 

I think you could create a simple table like this to achieve your desired outcome:

OS - I just pulled from 'Servers Master Data'

Cost Per Server - we already created this metric, per above threads, so just added this from the 'Calculations' perspective in Ad Hoc Query. 

Memory Unit Cost =Cost/Servers Master Data.Memory Capacity (I did this by 'Inserting' a column into my table on the reporting surface)

As Ryan mentioned, you will also want to add a filter to only include the applicable servers. 

Hope that helps!