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.  Source Data Management Component

    Posted 12/22/15 02:57 PM

    Curious to know how others are using the Source Data Management Component

    @Judi Conces

     




    #CostingStandard(CT-Foundation)


  • 2.  Re:  Source Data Management Component

    Posted 12/23/15 08:51 AM

    Hi Michelle,

     

    Not the definitive list, but here are a couple of ideas:

     

    A fairly standard use-case is to use the SDM project to load a single set of raw data that you may need in different projects - each of which may require different types of transformations to meet the requirements of their individual projects.

     

    Another idea is to check your raw data quality using the SDM's data quality reports. Comparing these data quality reports to those in the destination project (post transforms) can give you some insight into your raw data and how/where you can improve your data quality.

     

    Thanks,

    Jon Strauss


    #CostingStandard(CT-Foundation)


  • 3.  Re:  Source Data Management Component

    Posted 12/23/15 09:23 AM

    Jon, what is the difference then between the Data Report in the Data & Allocations Sectioin on the Reporting tab vs the data quality reports?  Couldn't I check my raw data quality here as well?

     

    Thanks

    Michelle


    #CostingStandard(CT-Foundation)


  • 4.  Re:  Source Data Management Component

    Posted 12/23/15 09:39 AM

    Hey Michelle,

     

    You certainly could check your raw data in the Data Report (Data & Allocations Section) but you'd have to do so prior to doing any transforms/mappings. Those reports (in your project) are analyzing everything - both raw data and transformations.

     

    As an example - in my test SDM project I have ~85% Cost Source completeness with my raw data. Once I publish that raw data from SDM to my Cost Transparency project and that raw data is transformed - my number of records analyzed doubles and my completeness has risen to 93.4!

     

    I hope that answers your question.

     

    Cheers,

    Jon Strauss


    #CostingStandard(CT-Foundation)


  • 5.  Re:  Source Data Management Component

    Posted 12/24/15 07:57 AM

    Thank you Jon, I think so.

     

     

    Michelle


    #CostingStandard(CT-Foundation)