IBM Apptio

Apptio

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


#Aspera
#Apptio
#Automation
ย View Only
Expand all | Collapse all

Editable Table Lookup Function Not Refreshing

  • 1.  Editable Table Lookup Function Not Refreshing

    Posted Thu October 26, 2023 11:55 AM

    Hello All, would appreciate any thoughts or help with an issue regarding looking up a value from an Editable Table, using the "Lookup_From_Editable" function. 

    My team has built an editable table, for our end users to capture and update the value in a "status" column (Valid Values include: "Validated", ""In-Progress", "Validated").  In a separate dashboard, we have a table that looks up the value of this column from the editable table (please see formula pasted below).  However, it seems as if this function does not refresh the dashboard, when an update is made to the editable table.  

    For example, if both the dashboard and editable table show a value of "Not Validated", but we then update the editable table to a value of "Validated", the dashboard will still show a value of "Not Validated".  How can we get the dashboard to refresh and show the latest value from the editable table?

    Formula:

    =Lookup_From_Editable(Applications Master Data.App ID,TBM Application Status Mapping,AlfabetID, Validation Status)

    If there is a better way to achieve the end result, not using this particular function, we are definitely open to hearing that as well.  Thanks!


    #CostingStandard(CT-Foundation)


  • 2.  RE: Editable Table Lookup Function Not Refreshing

    Posted Fri October 27, 2023 02:30 AM

    I haven't tried that, @Samir Banker, didn't even know about the Lookup_From_Editable() function ๐Ÿ˜ฎ๐Ÿ˜ฎ๐Ÿ˜ฎ

    I'm trying Editable Tables these days, and I have created a transform of it. For that you'll need to promote the changes, but then a regular Lookup() will work. Not sure if this is what you want.



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