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.  Bus Services & Bus Unit Report

    Posted 08/08/16 10:47 PM

    Hello, trying to create a report that shows business service spend by business unit.  I can get it to work fine with just cost, but when I try and add the YTD component, it flops - unsupported combination.  Any ideas?  Thanks much!!

     

     Query









    #CostingStandard(CT-Foundation)


  • 2.  Re: Bus Services & Bus Unit Report

    Posted 08/09/16 12:29 PM

    Hi Jenny,

     

    What you can try and do is create a brand new formula coloumn and put the Cost YTD formula in it. Then publish it to a perspective and lock it to a specific object (Business Services or Business Units). Then pull it in to the new report component you are trying to make. Sometimes doing the configuration that way can work because it forces the formula to look at only that object.

     

    Let me know if you have any questions,

    Lauren Griessel


    #CostingStandard(CT-Foundation)


  • 3.  Re: Bus Services & Bus Unit Report

    Posted 08/09/16 01:25 PM

    I tried adding a formula column (sorry for not mentioning earlier), but it wouldn't let me - or are you saying maybe do that in a new table, and then publish?  Thank you!


    #CostingStandard(CT-Foundation)


  • 4.  Re: Bus Services & Bus Unit Report
    Best Answer

    Posted 08/09/16 01:51 PM

    No worries  Do it in a new table, publish and lock it to the relevant object and then make sure you lock the other fields to that you are trying to pull in. 


    #CostingStandard(CT-Foundation)


  • 5.  Re: Bus Services & Bus Unit Report

    Posted 08/09/16 01:57 PM

    Will do - thank you!!


    #CostingStandard(CT-Foundation)