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.  Eval Function Question

    Posted 03/09/21 04:06 PM
    Can the Eval Function be used in transform steps of a table?  The Apptio documentation for this function indicates it can only be used in report columns and as dynamic text (html on a report?):

    Where to use

    This function can be used in:

    • Formula columns in report tables
    • Dynamic text

    I do not see datasets in this list.  I was able to get it to work in a formula section in one of my table transforms but am concerned about future ramifications of using a function where the documentation states the function can only be used in a report column or as dynamic text.

    Thank you!
    Jeanne Grzelak


    #CostingStandard(CT-Foundation)


  • 2.  RE: Eval Function Question

    Posted 03/09/21 05:02 PM
    Jeanne, it is possible to use Eval in Tables, however it can be computationally expensive depending on how it is being used.
    What does your formula look like?


  • 3.  RE: Eval Function Question

    Posted 03/10/21 09:16 AM
    Eric,

    Thank you for your response.  I have created a table with two fields in the upload file (below is a snippet - the actual table will have about 22 rows):

    Unit of Measure Quantity
    PCs "={End User Devices Master Data}:{Device Count}[{Device Count}=1]"
    FTE-Hrs "={Business Unit Allocation Master Data}:{Employee Headcount}[{Employee Headcount}>0]"
    Lab Machines "={End User Devices Master Data}:{Device Count}[{Lab Machine}=1]"
    Network Devices  "={Network Devices Master Data}:{Device Count}[{Device Count}=1]"


    Then I added a formula section in the transform where (using the Select column to edit) the Quantity field changes to:

    =eval((mid(Quantity,2,len(Quantity)-2)))   => to evaluate the data lookup

    The final table looks something like this:

    Unit of Measure Quantity
    PCs 2000
    FTE-Hrs 10000
    Lab Machines 3000
    Network Devices 2500



    This table will used with the Tablematch function.  Another table in our project will use the Tablematch function to grab the appropriate Quantity depending on the unit of measure.

    Do you think this process will be computationally expensive?  

    Thank you so much for your help!

    Jeanne 






    Original Message


  • 4.  RE: Eval Function Question

    Posted 03/10/21 04:33 PM
    Given the small size of your table, you should be a-ok.
    Original Message


  • 5.  RE: Eval Function Question

    Posted 03/11/21 01:21 PM
    Awesome!  Thank you for your help Eric!
    Original Message


Related Content