IBM Apptio

IBM Apptio

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

 View Only
Expand all | Collapse all

Is there any simple way to find out if a data field is being used elsewhere in the model for calculation?

  • 1.  Is there any simple way to find out if a data field is being used elsewhere in the model for calculation?

    Posted Tue July 14, 2020 09:59 AM

    Hello, I'm new to Apptio and wanted to ask if there is an easy way to find out if a specific data field in a table is being used in a formula or imported anywhere else in the model? 

     

    It seems whenever we are trying to remove a data field, we aren't entirely sure of the impact on CT model and having a difficult time trying to locate where this will cause issues.





    #CostingStandard(CT-Foundation)


  • 2.  Re: Is there any simple way to find out if a data field is being used elsewhere in the model for calculation?

    Posted Wed July 15, 2020 11:08 AM

    Documenting every nook and cranny in the model helps - then you can do a quick CTRL+F to look for it, but takes a lot of time to document everything .  I do see that it's easier to quickly eyeball if other tables are impacted, though, with R12 (didn't have that ability in R11, I don't believe).  But if you check out a table, you can see other tables in bold font indicating that they rely on something in the table you have checked out.  

     

    Here's a few other resources that are trickled around on TBM Connect:

     

    Documenting Your Model 

    Apptio Allocation Strategy.docx 

    What is the best practice for documenting allocation/model changes?

    @Anil Mudumbu


    #CostingStandard(CT-Foundation)