You can use the SAP BW catalog source to extract metadata from an SAP BW source system.
SAP Business Warehouse (SAP BW) is a data warehouse product of SAP that is based on the SAP NetWeaver ABAP environment. SAP BW can transform and consolidate business information from any source system for reporting, analysis, and interpretation of business data. This data is accessible through built-in reporting, business intelligence and analytics tools as well as third-party software.
Extracted metadata
You can extract specific metadata from source systems that you connect to with an SAP BW catalog source.
Metadata Command Center extracts the following objects from an SAP BW source system:
•InfoArea
•Data Source
•InfoObject
•InfoObject Catalog
•Source System
•InfoSource
•Characteristic
•Key Figure
•Dimension
•Navigational Attribute
•InfoSet
•DataStore Object (DSO)
•InfoCube
•MultiProvider
•Transformation
•Transformation Rule
•Query
•Query Element or Field
•Workbook
•Advanced DSO
•Composite Provider
•DTP
•InfoObject as InfoProvider
•CDS View
The catalog source job extracts only CDS views that have queries.
•Open Hub Destination
Data profiling for SAP BW objects
Configure data profiling to run profiles on the metadata extracted from an SAP BW source system. You can view the profiling statistics in Data Governance and Catalog.
You can run data profiles on the following SAP BW objects:
•InfoCube
•MultiProvider
•DataStore Object (DSO)
The data profiling task runs profiles on the following data types:
SAP Data Type
Transformation Data Type
Range for Transformation Data Type
CHAR
String
1 to 104,857,600 characters
Fixed-length or varying-length string.
CUKY
String
1 to 104,857,600 characters
Fixed-length or varying-length string.
CURR
Decimal
Precision 1 to 28 digits, scale 0 to 28
DATS
Date/time
Jan 1, 0001 A.D. to Dec 31, 9999 A.D. Precision to the nanosecond.
DEC
Double
Precision 1 to 28 digits, scale 0 to 28
FLTP
Double
Precision 15, scale 0
INT4
Integer
Precision 10, scale 0
LANG
String
1 to 104,857,600 characters
Fixed-length or varying-length string.
NUMC
String
1 to 104,857,600 characters
Fixed-length or varying-length string.
QUAN
Decimal
Precision 1 to 28 digits, scale 0 to 28
TIMS
Date/time
Jan 1, 0001 A.D. to Dec 31, 9999 A.D. Precision to the nanosecond.
UNIT
String
1 to 104,857,600 characters
Fixed-length or varying-length string.
Compatible connectors
Before you configure an SAP BW catalog source, you must connect to the SAP BW source system.
Use the SAP BW connector to connect to the SAP BW source system.
For information about configuring a connection, see Connections.