Document toolboxDocument toolbox

Scope of SAP BW Connector

Object Level

Data Lineage at Object level for BW Entities.
We export two files: one file with all the relations of BW Entities (“Relations”) and one file with more details (e.g. Technical Name and descriptions) (“Details”) of the entities.

In the “Relations” file only entities are included that have a connection in a data flow. E.g. an Advanced DSO without an incoming or outgoing transformation or an Composite or Open ODS View on top is not listed in the data.

The supported entities for the standard edition are the following:

  • BW Queries

  • Restricted Key Figures

  • Calculated Key Figures

  • Composite Providers

  • Advanced Data Store Objects (ADSO)

  • Open ODS Views

  • InfoSources

  • DataSources

  • InfoObjects as InfoProviders

  • Open Hub Destinations

  • Aggregation Levels

  • AfO Workbooks stored in BW

  • MultiProvider

  • Data Store Objects

  • InfoCubes

  • InfoSets

  • HybridProvider

  • HANA Artifacts consumed by Composite Providers and Open ODS Views

In Standard Edition we display the relations of InfoProvider to reusable Key Figures (restricted and calculated Key Figure) only. The definitions of key figures and their relation among each other and BW Queries are part of the Premium Edition.

Field Level

Data Lineage at Field/InfoObject level for BW Entities.

Every origin of and between Fields and InfoObjects will be part of the premium edition.

Which mappings are supported:

  • Mappings in Composite Providers

    • Direct Assignment

    • Formulas

    • Constants

  • Mappings in Open ODS Views

  • Assignments/rules in Transformations

    • Description of rules in Transformations

    • Type of rules in transformations (Constant, Formula, Field Routine, Lookup, End Routine, Start Routine, Expert Routine Direct Mapping)

    • Value of constants rules

    • Definition of formulas rules

    • Lookup object of lookup rules

All field and InfoObjects Mappings are supported for the BWonHANA entities only. That are the following:

  • BW Queries

  • Composite Providers

  • Advanced Data Store Objects (ADSO)

  • Open ODS Views

  • InfoSources

  • DataSources

  • InfoObjects as InfoProviders

  • Open Hub Destinations

  • Aggregation Levels

  • HANA Artifacts consumed by Composite Providers and Open ODS Views

Definition of Key Figures

The Premium edition reads out also the definitions of key figures on Reporting level. The definition of the following entity types are collected:

  • Calculated Key Figures

  • Restricted Key Figures

  • Local Formulas

  • Local Selections


Limitations

  • No differentiation is made between different rule groups.

If you want to see more in the Metadata API. Get in touch with us and create a Feature Request at https://bluetelligence.atlassian.net/servicedesk

© 2024 bluetelligence GmbH. All rights reserved.
No part of this publication may be reproduced or transmitted in any form or for any purpose without the express permission of bluetelligence GmbH. The information contained herein may be changed without prior notice. bluetelligence and Performer Suite and their respective logos are trademarks or registered trademarks of bluetelligence GmbH. SAP, ABAP, BAPI, SAP NetWeaver, SAP BI, SAP BW, SAC, and other SAP products and services mentioned herein as well as their respective logos are trademarks or registered trademarks of SAP AG in Germany or an SAP affiliate company. All other product and service names mentioned are the trademarks of their respective companies.
Impressum – Legal Notice: https://bluetelligence.de/en/imprint
Privacy policy: https://bluetelligence.atlassian.net/wiki/spaces/DMA/pages/4188635149/Privacy+Policy
Atlassian privacy policy: https://www.atlassian.com/legal/privacy-policy