Challenge 1: Lock report table to three model objects [++]

Document created by Employee on Feb 5, 2018Last modified by rhonda on Apr 5, 2018
Version 8Show Document
  • View in full screen mode


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


Ready to play? In 2018, Christopher Davidson will have 6 different challenges for you. Answer as many as you can. Each challenge you answer correctly will earn you a wedge for your virtual game piece and 30 points. In December we'll see who earned the most pieces and if anyone has collected them all.


Your chance to earn the first piece starts now and is only open until Feb 28th. Read through the problem, and submit your answer to get in the game. Here we go...  


Chris says,


I have a model report (R12) in my cost transparency project, showing how Cost flows from IT Resource Towers (filtered on just Compute rows) object to Applications object (in this case showing each application name):


So far, so good. I reset the model report view and started again, this time at the Cost Source object, clicking on Internal Labor as the starting cost pool. Then I clicked Compute to show how just my labor-specific server (compute) costs flow to each application:



Notice the per-application costs are lower than before. That's what I expected, since the second screenshot is limited to just my internal labor costs, not total costs. The second screenshot effectively locks the cost model to three objects: Cost Source, IT Resource Towers, and Applications. Oracle CRM for instance has an estimated $10,309 of server-related labor cost (or labor-related server cost, if you prefer).


Now I want to see this same information in a regular report table.

I began by locking a new report table to two Cost model objects: IT Resource Towers and Applications.

Then I filtered to show just Compute (server) cost:



Time to add the last ingredient. I dragged Cost Pool from (left) Tables > Cost Source into Rows section of the ad hoc component configuration:



But I see only a warning message: "Cannot lookup across 3 objects."


Is there any way to modify the report (without modifying the model or data tables) to show only the internal labor-related server cost per application?

27 people found this helpful