Platform

Platform

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

 View Only
Expand all | Collapse all

Editable Tables

  • 1.  Editable Tables

    Posted Fri May 13, 2022 01:56 AM
    I was wondering if anyone uses editable table for allowing end users to update / enhance data in apptio.  I have create a process using an editable table on a report to put project information in about actuals. 

    1. The next step is to save the data to the editable table 
    2. Publish the data to the transformed table.
    3. Data is looked up from the cost source to the transformed table.  

    Is this how you use editable tables or do you have different use cases.  

    Thanks.
    #TBMStudio


  • 2.  RE: Editable Tables

    Posted Mon May 16, 2022 08:56 AM
    Similar to what you said is my experience. 

    At my old company, we had an editable table that had a list of vendors, cost centers, and other metadata from the ledger. We had a report that showed all the vendor/cost center combos that needed to be mapped to a tower. Ideally, the user would go in to the report and map the vendor/CC to the tower.

    1. That data is saved in the editable table.
    2. A "regular" table that used the editable table as the source and had all our pipeline steps in it (formulas, etc) .
    3. Referenced that regular table when we needed that editable table data (lookups, lookupex, etc)

    We would have one lookup return a concatenated "key" field that was just split out in its final destination.


  • 3.  RE: Editable Tables

    Posted Tue May 17, 2022 03:01 AM
    Edited by Guillermo Cuadrado Tue November 05, 2024 06:20 PM

    We don't use the full set of capabilities, i.e. we don't promote the data. We use it instead for simulation exercises:

    We have a report that displays the number of servers related to an application. One column allows the application owner to enter a new number of servers, and the report will calculate the new monthly cost.
    Apptio keeps the data (in PRD), but it updates nothing, nor does it trigger any calculation jobs.
    For our use case, data is volatile, so we don't have to run it to the process as described by @Michael Enslein.

    ​P.S.
    I resuscitated a previous post on application rationalization that now uses Editable Tables here (link).


    ------------------------------
    Regards, Guillermo
    ------------------------------



  • 4.  RE: Editable Tables

    Posted Tue May 17, 2022 10:43 AM
    @Guillermo Cuadrado very intriguing!  Maybe Bill could write something up about how y'all did that?  🙃😎🐱‍👤🙌​


  • 5.  RE: Editable Tables

    Posted Tue May 17, 2022 10:49 AM
    I'll do that, @Jenny Franklin. That would be easy, and I should be able to finish it by the end of this week.
    I've been struggling with a novella about TBM adoption​, which is causing me to lose sleep, as I cannot quite find the story 😮😮😮👀👀👀

    ------------------------------
    Regards, Guillermo
    ------------------------------



  • 6.  RE: Editable Tables

    Posted Tue May 17, 2022 11:21 AM
    @Guillermo Cuadrado - The most successful adoption I've seen is when TBM was embedded in processes.  At a prior gig, it was part of the project process - no one could get a business case approved by Finance without submitting their business case with their TBM numbers.  Finance would then determine the hard and soft savings that would result from them retiring certain apps (perceived benefits of the new thing they were requesting).  If apps/services were going away as a result, of course not all resources/infrastructure would be retired, so that would be seen as soft savings as the resources would be used elsewhere.  Any infrastructure that could be decommissioned or any contracts that could be closed out or reduced would go in the hard savings column.  As a result of having TBM included in the overall project process, IT and Finance were in lockstep.  Very nice! ​


  • 7.  RE: Editable Tables

    Posted Thu May 19, 2022 07:06 AM
    I agree, @Jenny Franklin. Makes sense. Paraphrasing Pink Floyd, "Wish that were here".​

    ------------------------------
    Regards, Guillermo
    ------------------------------



  • 8.  RE: Editable Tables

    Posted Thu May 19, 2022 09:17 AM

    My all time fave band 💕😊

    TripControl




  • 9.  RE: Editable Tables

    Posted Thu May 19, 2022 07:08 AM
    I had written about it, but I guess it got lost in the migration from jiveon to the current community platform.
    Will reconstruct the post and add whatever I might need to update @Jenny Franklin​

    ------------------------------
    Regards, Guillermo
    ------------------------------



  • 10.  RE: Editable Tables

    Posted Thu May 19, 2022 09:18 AM
    Thank you as always @Guillermo Cuadrado!! 🐱‍👤🙌😎​


  • 11.  RE: Editable Tables

    Posted Fri May 20, 2022 09:00 AM
    I have resurrected the original post from 2020-Bill and the 'Rat Pack' (link). I still need to update it, as it's missing the reference to the editable tables, as per this topic. That's how I built the simulation engine. More details, next week.
    Happy reading and do ask questions if needed!

    ------------------------------
    Regards, Guillermo
    ------------------------------



  • 12.  RE: Editable Tables
    Best Answer

    Posted Tue May 17, 2022 09:56 AM
    Editable Tables and the Table Upload feature can enhance the value of your TBM processes by federating out data maintenance to the data owners or those who best understand the data.  Here is a set of use cases enabled by editable tables which I have seen across different companies​:

    • Budget Variance Commentary - column to explain large variances
      • Drive Allocations - labor allocations table upload, GL line item allocations (% split mappings), Cost Source to cost pool, tower mappings
        • Capture Actual Volumes for BU consumption / chargeback - Table Upload feature for app/service owners to upload tables on the reporting surface
        • Data Cleansing / Enhancement – GL - enter flags for re-postings; cleanse GL actuals then feed to ITP for accruals and reclass line items that are missing vendor/supplier info
          • Reference Files for ApptioOne Plan / IT Planning  – used to maintain reference files shared with ITP
            • Row Level Security – maintain permissions
              • Service Catalog / Rate Management – maintain pricing information
              • End User Insights – (new Apptio product) - enable end user device table maintenance
              • Planning - capture # of planned labor hours
              • Demand Planning - (new Apptio product) - capture the projected volume consumption

              Let me know if you are using editable tables in your company for other use cases.  



              • 13.  RE: Editable Tables

                Posted Tue May 17, 2022 11:03 AM
                @Ed Hayman Thanks for the examples but one of the issues I am having is dealing with large volumes of data.  I am not sure if is in our environment or how the report is set up.  Currently, I have an editable table that helps map our CapEx data to project information.  It is only around 600 rows of data but if I have to reload that data.  I have to copy and paste the data into 200 or chunks of data and then save it each time.  it would be nice to be able to import larger data sets.


              • 14.  RE: Editable Tables

                Posted Tue May 17, 2022 11:25 AM
                Have you tried using regular tables with lookup or tablematch functions vs an editable table?  Why is the editable table used - do folks update the data there directly within Apptio?


              • 15.  RE: Editable Tables

                Posted Tue May 17, 2022 11:37 AM
                @Jenny Franklin This issue is that our source systems are very old legacy systems and we can not capture the project information before the data is loaded into the GL systems.  This leaves Apptio to capture the GL data and then have rules that can tie the data to the project information for reporting.  We could just have this as a normal load table but I was trying to get the Users more ability to update the data without TBM Admin stepping in.


              • 16.  RE: Editable Tables

                Posted Tue May 17, 2022 11:56 AM
                @Michael Enslein  Are you maintaining the editable table information in TBM Studio or in an Editable Table report component?  If in TBM Studio, I recommend you use the Editable Table report component that may require you to submit a support request to enable it in your environment. 

                The Editable Table report component provides a download and upload feature to export and/or import directly from the reporting surface.  Assuming you get a new list of CapEx data each month, it would be an easy "upload" without having to copy/paste 200 rows.   ​​


              • 17.  RE: Editable Tables

                Posted Tue May 17, 2022 12:48 PM
                  |   view attached
                @Ed Hayman thanks for the information we have the report feature turned on for our reporting but I don't see anything that would allow the for upload or download into this table.  ​


              • 18.  RE: Editable Tables

                Posted Tue May 17, 2022 01:59 PM
                @Michael Enslein  Please download the Editable Tables in R12 deck and look at the Upload / Download on the Reporting Surface feature.    ​​


              • 19.  RE: Editable Tables

                Posted Tue May 17, 2022 02:03 PM
                @ed Hayman Thanks I have seen this before but we are only on Server Version 12.9.14-333.  So we can not use them until we are scheduled for an upgrade.  Thanks again!  I do love this presentation.  Great information.