Content Browser: BW Object Relationships Cube

InfoCube InfoCube: 0BCTCBC01

This InfoCube is useful for managing Content in a BW System. It can be used to determine which customer-defined or SAP Business Content is used or available in various areas. It can also be used to find which specific objects are used in a given area.

The following central object categories are defined for use in this InfoCube:

  1. Role

  2. Role Folder

  3. Workbook/Template

  4. View/Query

  5. InfoProvider

  6. InfoSource

  7. DataSource

It is therefore possible to find which objects of different types are used together. For example, it is possible to find which Queries rely on a particular DataSource (for transactional data). However, it is not possible to find the relationship between objects of the same category – for example, the relationship between InfoProviders is NOT available in this cube.

The focus of this cube is transactional data. Therefore the following restrictions apply:

  • Characteristics are only included as InfoProviders if they are inserted in the InfoProvider tree in the administrator workbench

  • Only InfoSources for Flexible Update are included.

  • Only DataSources for transactional data, or for Characteristics which are used as InfoProviders are included.

  • The objects can be arranged according to hierarchies including the InfoArea and Application Component Hierarchies of SAP BW.

Data Modeling

Requires

Object Type

Name

Technical Name

InfoObject

Calendar Year

0CALYEAR

InfoObject

DataSource

0CB_DS

InfoObject

DataSource Count

0CB_DSCT

InfoObject

InfoProvider

0CB_IP

InfoObject

InfoProvider Count

0CB_IPCT

InfoObject

Flag: Query to InfoProvider Direct Relationship

0CB_IPDIR

InfoObject

InfoProvider Type

0CB_IPT

InfoObject

InfoSource

0CB_IS

InfoObject

InfoSource Count

0CB_ISCT

InfoObject

Object Version

0CB_OV

InfoObject

Role Folder

0CB_RFLD

InfoObject

Source System

0CB_SRCSYS

InfoObject

View/Query Name

0CB_VQ

InfoObject

View/Query Count

0CB_VQCT

InfoObject

View/Query Type

0CB_VQT

InfoObject

Workbook/Template Name

0CB_WT

InfoObject

Workbook/Template Count

0CB_WTCT

InfoObject

Workbook/Template Type

0CB_WTT

InfoObject

Change Run ID

0CHNGID

InfoObject

Record type

0RECORDTP

InfoObject

Request ID

0REQUID