Join Now
Wiiisdom | Analytics Governance SolutionsWiiisdom | Analytics Governance Solutions
  • Solutions
    • By Initiatives
      • analyticsops-solution AnalyticsOps
      • technology-solution Embedded Analytics
      • icon-scale-analytics Scale Analytics
      • icon-regulatory-compliance Regulatory Compliance
      • icon-enable-rpa Enable RPA
      • icon-cloud-analytics Move to the Cloud
    • By Industries
      • financial-solution Financial
      • government-solution Government
      • healthcare-solution Healthcare
      • insurance-solution Insurance
    • By Technologies
      • sap-bo SAP BusinessObjects
      • sap-data-services SAP Data Services
      • tableau-software Tableau
      • power-bi Power BI
  • Products
    • wiiisdom-ops Wiiisdom Ops
      • tableau-software Wiiisdom Ops for Tableau
      • sap-bo Wiiisdom Ops for SAP BusinessObjects
      • power-bi Wiiisdom Ops for Power BI
    • 360suite 360Suite for SAP BusinessObjects
      • favicon-eyes 360Eyes
        Metadata & Impact Analysis
      • favicon-live 360Live
        Live Monitoring
      • favicon-bind 360Bind
        Automated Regression Testing
      • favicon-univ 360Univ
        Universe Management Tool
      • favicon-cast 360Cast
        Report Bursting & Scheduling
    • 360suite 360Suite
      • favicon-view 360View
        Administration & Maintenance
      • favicon-plus 360Plus
        Disaster Recovery, Backup & Promotion
      • favicon-vers 360Vers
        Versioning & Lifecycle Management
      • favicon-safe 360Safe
        License Compliance
      • favicon-init 360Init
        Project Creation
  • Resources
    • Resource Center
    • Webinars
    • Events
  • About Us
    • Our Mission
    • Careers
    • Partner Program
    • News
  • Contact Us
4   
By Yasmina Couty SAP BusinessObjects SAP Data Services 360Suite Analytics Quality October 15, 2020

Lire cet article en Français france-drapeau

End-To-End Data Lineage For SAP BODS

cover-data-lineage-sap-bods

Understanding Data Lineage 

Data Lineage states where data is coming from, where it is going, and what transformations are applied to it as it flows through multiple processes. It helps understand the data life cycle. For any transformations applied to data, it’s very useful to conduct an impact analysis so you understand the consequences of an action or the extent and nature of change it may cause. Thanks to our solution, 360Eyes, you can do just that — know exactly the activity of your data from start to finish in SAP BusinessObjects, and if you have SAP Data Services, we can go even further. 

Why Should You Carry Out Data Lineage? 

Before I delve into the importance of data lineage, it’s important to know that being able to document SAP BO Data Services metadata is also not something to ignore. Documenting will provide higher transparency of your data with the ability to see any changes made within the ETL process. Whereas documenting shows you what’s going on in your ETL, data lineage exposes the relationships between the data embedded in the ETL process definitions. This information can then be used by business users to generate knowledge about the organization. From a technical perspective, it makes development processes easier for Universe and report developers. Economically, it decreases time expenditure for maintenance and development of the various sources to the data warehouse. On the business level, it means better governance, shorter training cycles, fewer losses of corporate knowledge, acceptance, and trust in the system due to greater transparency about the origin and processing of the data. 

 

With 360Eyes for SAP BODS, end-to-end lineage allows you to retrieve different metadata to track:

  • Source database (i.e. OLTP (online transaction processing)/transactional datastore)
  • ETL processes (i.e. project, job, workflow, dataflow, transforms)
  • Target database (i.e. reporting data mart/data warehouse)
  • Universes
  • Reports (i.e. WebI, Crystal Reports)
  • Objects (dimensions, details, measures)

 

This is the complete data lineage flow from start to finish: 

Below are examples of what business users would be interested in knowing through data lineage: 

  • By WebI – I want to know which Universes and which SAP Data Services objects are used in my WebI.
  • By Universe – I want to know which WebI is connected to the selected Universe and which objects it’s coming from in SAP Data Services.
  • By SAP Data Services – I want to know which Universes and WebI are using the selected SAP Data Services Table (or column).

 

Know Your Data From The Inside Out

Carrying out data lineage is important in understanding the life cycle of your data because it allows you to identify any relationships between the data embedded in the ETL process definitions. With 360Eyes, you can be reassured that you know your data from the inside out, from SAP BusinessObjects to SAP Data Services. Request your demo here.

Related posts

bec-improve-sap-businessobjects
November 30, 2020

How BEC Better Serves Its Customers with Improved SAP BusinessObjects Promotion Management

READ MORE
archiving-clean-up-sap-businessobjects-cover
October 29, 2020

Automate your SAP BusinessObjects archiving

READ MORE
documenting-sap-bods-metadata
September 18, 2020

Documenting SAP BODS Metadata With 360Suite

READ MORE
360EyesBusiness Objects MetadataSAP Data Services360EyesDS
Yasmina Couty / About Author
More posts by Yasmina Couty

Related Posts

documenting-sap-bods-metadata
Documenting SAP BODS Metadata With 360Suite
4
18 Sep 2020
preparation-migration-business-objects-orange
How Orange Prepared For Its SAP BusinessObjects Migration
0 0
29 Jul 2020
business objects solutions
Thinking Out of the Box

If you are following GB&SMITH you may have read my previous post a ‘decade of success’, then, you already know…

4
06 Sep 2017
business objects assessment
Business Objects BI on BI Assessment

For the last decade, we helped our Business Objects clients to maximize their SAP BI investments and reduce associated costs….

4
19 Sep 2017
harley-davidson-trophy-roi
Harley-Davidson Saved More Than $1 Million with 360Suite
0 6
20 Feb 2018
bi-on-bi-360eyes
How City of Chicago uses BI on BI to improve metadata management, increase security, and save money
0 5
08 Feb 2018
lockheed-martin-use-case
Reducing Costs, Increasing Automation, and Improving Visibility for Self-Service Reporting at Lockheed Martin
0 0
12 Mar 2019
business objects migration solutions
360Suite – Your new 3 best friends for SAP BusinessObjects migration

At Xoomworks BI we view the GB&Smith 360Suite of tools as administration intelligence for SAP BusinessObjects. Planning a BI 4.1…

0 3
06 Oct 2016
support-gdpr-sap
Support your GDPR project with 360Suite for SAP BusinessObjects

360Suite tools for SAP BusinessObjects will help you be GDPR compliant GDPR, originally adopted in April 2016 by the European…

5
06 Sep 2017
compare business objects universes
Taking full advantage of 360Suite #2 – Compare Universes

Have you ever wanted to know what the differences were between a Business Objects Universe in 2 different environments? I…

3
06 Mar 2017
Calculation Engine changes
Find Calculation Engine Changes in SAP BusinessObjects

In the past, we discussed the value of 360Bind in how to mitigate risks with automated regression testing. 360Bind is an…

0 3
03 Oct 2016
performance-testing
Business Objects Performance Testing
0 3
01 Jun 2018
Metadata and BI on BI in Business Objects
0 5
12 Feb 2018
vanderbilt-business-objects-sucess-upgrade
Vanderbilt University Medical Center Business Objects Upgrade and Epic Install
0 1
08 Aug 2018
epa-use-case
Reducing Costs and Maximizing SAP BusinessObjects Investments at EPA
0 0
19 Mar 2019

Information

  • Careers
  • Press
  • Terms & Privacy Policy
  • Legal
  • Supplier Code of Ethics

Support

  • Helpdesk
  • Downloads
  • Documentation
  • Knowledge Base
  • Release Notes

Latest news

  • How SAP Ariba Improved Its SAP Data Services Documentation Capabilities
    March 16, 2023
  • What is BI Testing?
    March 8, 2023

Connect With Us

  • Making trusted decisions together
  • Français
2023 © Copyrights Wiiisdom.
All Rights Reserved.

Request your trial for Wiiisdom Ops

Wiiisdom Ops supports Tableau Server and Tableau Online (now Tableau Cloud).
For custom installations, 3rd party authentication and single sign on, an initial setup may be required.
Please refer to our documentation and do not hesitate contacting us at: contact@wiiisdom.com.