Samuel Chmiel
What to Expect
Dataedo automatically imports the following from the SAP BusinessObjects Web Intelligence module:
- Connections
- Universes with fields and folders
- Documents with variables
- Reports with visualizations and fields
- Freehand SQL queries with scripts and fields
- Column-level lineage from source database tables and views to Documents and Reports by parsing Freehand SQL queries
- Column-level lineage from Universes to Documents and Reports
Connections
SAP BusinessObjects connections are imported as Dataedo Linked Sources. These connections allow you to specify where the lineage to an external data source should point. However, SAP BusinessObjects does not provide detailed connection information that would enable automatic mapping to other data sources. If the linked source is manually mapped to an external source, the data lineage will be automatically updated during subsequent imports of changes from the SAP BusinessObjects data source.
Lineage in Documents
SAP BusinessObjects documents contain Variables calculated using formulas. These Variables and their formulas are imported, and automatic lineage is established to the source fields of each Variable.
Lineage in Reports
When the SAP BusinessObjects REST API provides links, column-level lineage is established from visualizations and fields to Document Variables, Freehand SQL query fields, and Universe fields.
In example below: - The Quarterly Sales.Top customers by sales amount report includes ProfitMargin in the visualization, which is a Variable in the Quarterly Sales document. There is column-level lineage from the report to the document. The Quarterly Sales.Top customers by sales amount report uses fields from the Quarterly Sales.Query 2 query in the visualization, and there is column-level lineage from the report to the query.
Lineage to external data sources
When the Linked Source mentioned in the Connections section is mapped to the appropriate external documentation in Dataedo, subsequent imports will establish column-level lineage from Freehand SQLs to external documentation. This lineage is computed if the SQL query is supported by the Dataedo SQL parser.
