IBM Apptio

Apptio

A place for Apptio product users to learn, connect, share and grow together.


#Aspera
#Apptio
#Automation
#FinOps
#Apptio
#ITAutomation
 View Only
  • 1.  Ad Hoc Report Question

    Posted 07/20/16 12:34 AM

    Hoping someone can shed some light on this one.  Trying to create a simple ad hoc report that shows dollars hitting Towers, Sub-Towers, and Cost Pools - is that possible?  I've tried creating separate perspectives, etc., but it doesn't seem to want to play nice.   Want to see what amount of dollars per cost pool is feeding what sub-towers that ultimately feeds the towers if that makes sense...  We sometimes get questions about the cost of servers or storage and we want to break out the baked in parts...






    #CostingStandard(CT-Foundation)


  • 2.  Re: Ad Hoc Report Question
    Best Answer

    Posted 07/20/16 09:26 AM

    AHQ_02.PNG

     

    The table above was created by combining:

    Cost Pool and Cost Sub Pool (both locked to Cost Source object)

    IT Resource Tower Name and IT Resource Sub Tower Name (both locked to IT Resource Towers object)

    Cost and Budget (metrics, found in the Calculations perspective)

     

    AHQ_01.PNG


    #CostingStandard(CT-Foundation)


  • 3.  Re: Ad Hoc Report Question

    Posted 07/20/16 11:13 AM

    Christopher, you're awesome - thank you so much!!!

    urock.jpg


    #CostingStandard(CT-Foundation)


  • 4.  Re: Ad Hoc Report Question

    Posted 07/20/16 11:26 AM

    You still rock, but I can't get it to work on my end.

     

    bummer.jpg


    #CostingStandard(CT-Foundation)


  • 5.  Re: Ad Hoc Report Question

    Posted 07/21/16 04:25 PM

    If you remove the tower and sub-tower columns, do the Cost Pool and Cost Sub Pool columns have values?


    #CostingStandard(CT-Foundation)


  • 6.  Re: Ad Hoc Report Question

    Posted 07/21/16 04:28 PM


  • 7.  Re: Ad Hoc Report Question

    Posted 07/22/16 10:51 AM

    If you haven't already, try also adding the Cost metric (from Calculations perspective) to the Values section of the ad hoc query configuration dialog.

     

    If the cost pool column is still blank, then something may be a bit off in the Cost model between the two relevant objects (Cost Source and IT Resource Towers). The model itself is a good place to investigate further.
    In the Cost model, right-click the IT Resource Towers object and Trace (i.e. trace all of its rows at once).
    Hopefully the Cost Source object is one of the ones lit up (in bold) during the trace, implying IT Resource Towers can trace at least one of its rows back to the Cost Source object.
    With the trace still active, select the Cost Source object.
    It may take a few moments for the Summary Data table to appear at the bottom of the screen, since you're drilling from one object to another.
    Right-click any column name in the Summary Data table, then: Show/Hide columns > Cost Pool (and Cost Sub Pool).
    Hopefully the Cost Pool column has valid values, not just blank cells.
    By conducting this model trace, you're replicating what the report table is doing.
    If the model trace works as expected, then something may be amiss with the report table instead.

    #CostingStandard(CT-Foundation)


  • 8.  Re: Ad Hoc Report Question

    Posted 07/22/16 09:25 PM

    @Chris Davidson, adding Cost worked - thank you!!!!


    #CostingStandard(CT-Foundation)