Reporting and Analytics for ERP

Get Involved. Join the Conversation.


    Anand DN
    Release 11 Data Lineage Guide for FSCM (Financials,...
    Topic posted September 28, 2016 by Anand DNBronze Medal: 1,250+ Points, last edited September 29, 2016, tagged BI Publisher, Fusion Financial reporting, Fusion Project reporting, Fusion Supply Chain Management reporting, OBI Answers, OBIEE Answers, OTBI, Reports 
    212 Views, 2 Comments
    Release 11 Data Lineage Guide for FSCM (Financials, Projects, Supply Chain)
    The Data Lineage Guide provides a mapping of the BI Subject Area columns to source data base tables and columns. It also has the View Object (VO) names for each column.

    What is it ?

    The Data Lineage (DL) Guide is a spread sheet that provides a mapping of OTBI Subject Areas and their Presentation Columns, i.e., the attributes and metrics used for report building on the one hand  and the transaction database tables and columns on the other and everything in between. Between the Subject Area Columns and the source database columns are the 'View Objects' or VO's that provide the abstraction layer on top of the source database. The VO names are provided as well.


    1. DL guide is for out of box functionality and does not contain any customer specific customization information, such as Flex fields created on site.

    2. DL Guide is available only to implementing customers and partners. It is NOT part of external facing  product documentation.

    Why use it?

    If you are an implementing customer or partner/SI, the DL guide helps you in understanding coverage of various source tables and columns, including out of box support available for Flex fields (DFF's and KFF's)

    If you are a report author, the DL Guide is perhaps the only document that provides a detailed documentation of Subject Area Folders (Presentation tables) and Columns. This is useful information while building ad-hoc reports.





    • Tim Welsh

      Thank you, this looks super helpful.  

      How can I identify database source tables/columns for the ones missing?  For instance, Beginning Balance and Ending Balance of "General Ledger - Balances Real Time"?  I notice many of the balances don't have a database table and column associated with them.  Same with Transactional Balances Real Time, there are many missing tables and columns.  

      • Anand DN

        Hi Tim,

        I contacted my engineering team on this and learn the missing columns come from 'expert mode' View Objects and need significant manual efforts to map. However, it is our objective to provide a comprehensive lineage document, which we are hopeful of providing in future releases.

        Meanwhile, if you are looking for lineage information for specific columns that you don't find in the spreadsheet, please raise an SR. They need to be resolved on a case by case basis.





    • Jairo Rojas Mendez

      This is great, will share with my customers. Thank you!