Apptio for All

Apptio for All

 View Only
Back to Library

Challenge 4: Report individual cost model allocation lines [+] 

Tue July 31, 2018 09:44 AM

Challenges are designed to help sharpen your TBM and Apptio skills. See title for rating: [+] Easy   [++] Moderate   [+++] Challenging

 

Can you believe we've already had one, two, three challenges in our 6 part series? You can start playing any time. If you get this one right, you'll earn 30pts and a TBM Pursuit game piece. There was a little drama around challenge 3. Let's see how #4 unfolds.

Question Closes Aug 31

@Chris Davidson says...

 

In my cost transparency project, I built a Cost model with about 20 model objects.

 

Here's an excerpt from the model--just the Applications object and its adjacent downstream neighbor objects:

 

I know how to build a report table which shows Cost per application.

 

I also know how to lock a report table to two (or even three) model objects, so for example my report could show all servers associated with a particular application (and show each server's estimated cost to support just that application).

 

But what I'm hoping to build now is a table showing per-application cost for each of the six inbound allocations shown above.

Here's a mockup of what I'd like to create:

 

...and if I can get that far, then I'd also like to try to convert the table into a chart. Another mockup below:

 

Is there any way to build this table and chart in Apptio? If so, how?






#ApptioforAll

Statistics
0 Favorited
7 Views
0 Files
0 Shares
0 Downloads

Comments

Dawn Kassube
Thu February 01, 2024 04:39 PM

Hello Chris,

Is there a way to include YTD Cost, YTD Budget and have the numbers convert to other currencies when using .Driver as a Row?  When I bring in Budget YTD, I receive the following error.  It converts fine for Budget, Cost, Cost YTD, and LTM.

Error:  Unsupported. Dated function 'Budget YTD' cannot be used on a .Drivers table with multicurrency


#ApptioforAll

Apptio Community Member
Mon August 12, 2019 06:10 AM

This just made my day a WHOLE LOT EASIER!  Thanks so much!


#ApptioforAll

Apptio Community Member
Tue June 11, 2019 10:57 AM

Perfect @Rhonda Keller 


#ApptioforAll

Apptio Community Member
Tue June 11, 2019 10:49 AM

Timely that you surfaced this @Supriya Sukumaran. I just met with @Andrew Mulvaney, @Michael Darragh� and @Demarcus Lloyd yesterday. They're going to help us reboot our learn and play series for the second half of 2019 :-) 


#ApptioforAll

Apptio Community Member
Mon June 10, 2019 10:49 AM

Congratulations!!!! @Steven Young@Juliet Orgain @Shannon Lynch @Suresh Sawlani Paula Foster @Axel Burkert @Scott Shulman @Michelle McGuire @Jenny Franklin @Jenny Franklin


#ApptioforAll

Apptio Community Member
Tue September 04, 2018 06:25 PM

Thank You!


#ApptioforAll

Apptio Community Member
Tue September 04, 2018 10:53 AM

This is exciting!  Congratulations to all of our winners!

@Steven Young @Juliet Orgain @Shannon Lynch @Suresh Sawlani Paula Foster @Axel Burkert @Scott Shulman @Michelle McGuire @Jenny Franklin

You should see the Community Pursuit 4th piece badge on your Community profile now.  


#ApptioforAll

Apptio Community Member
Tue September 04, 2018 09:48 AM

Megan Beasley check out the nine winners in round 4, ready for their points and badge update. I definitely see some names from earlier rounds in this list


#ApptioforAll

Chris Davidson
Sun September 02, 2018 09:11 PM

Congratulations to 9 of you who submitted a correct answer:

Steven Young
Juliet Orgain
Shannon Lynch
Suresh Sawlani
Paula Foster
Axel Burkert
Scott Shulman
Michelle McGuire
Jenny Franklin

 

Each model object's inbound allocation (also called a driver) value can indeed be placed into its own table column, and we can even manipulate the values using formula functions, for example summing Servers, Storage, and Mainframe drivers into a new separate table column called Infrastructure Cost. 

 

Fast method (legacy table)

Open the full-model (birds-eye view) diagram.

Select Applications object.

On header row of summary data table (appears below diagram in R11 or left of diagram in R12), right-click > Show/hide columns.

In Filter field, type: (Cost driver) including the parentheses.

Select and add all matching columns to the table.

Near the bottom of the summary data table, right-click an empty area > Copy to clipboard.

While editing a report: (bottom right) Paste all from clipboard.

 

Slightly slower method (ad hoc query table)

Add a new empty ad hoc query (AHQ) table to a report.

From Service Costing > Applications perspective, drag Application Name to Rows area of AHQ configuration area.

R11: Open to expand Calculations > Cost perspective, to view list of drivers. One by one, drag each down to Values area of AHQ configuration area.

R11 or R12: (top) Ribbon > Data > Insert > Insert formula column. Select Modeled Value option. Scroll through list and choose any driver containing (Cost) at the end of its name. Continue adding these columns one at a time to include all cost drivers.

Optionally create a stacked bar chart: (top) Ribbon > Ad hoc > Bar > Stacked bar.

 

Note: Use of these methods is not supported for report components locked to more than one model object.


#ApptioforAll