SAP Tutorials

A time-dependent entire hierarchy is a time-dependent hierarchy whose nodes and leaves are not time-dependent.

A time-dependent hierarchy structure consists of nodes or leaves that are time-dependent, but the hierarchy itself is not time-dependent.

Transfer rules specify how DataSource fields are mapped to InfoSource InfoObjects.

A transfer structure maps DataSource fields to InfoSource InfoObjects.

An update rule specifies how data will be updated into their targets. The data target can be an InfoCube or an ODS object. If the update rule is applied to data from an InfoSource, the update rule’s technical name will match the InfoSource’s technical name. If the update rule is applied to data from an ODS object, the update rule’s technical name will match the ODS object’s technical name prefixed with number 8.

A variable is a query parameter. It gets its value from user input or takes a default value set by the variable creator.

A BW workbook is an Excel file with a BEx query result saved in BDS. BW assigns a 25-digit ID to each workbook. Users need merely name a workbook’s title.

SID (Surrogate-ID) translates a potentially long key for an InfoObject into a short four-byte integer, which saves I/O and memory during OLAP.

A source system is a protocol that BW uses to find and extract data. When the source system is a non-SAP system, such as a flat file or a third-party tool, the maximum number of characters allowed for the technical name is 10. When the source system is an SAP system, either R/3 or BW, the technical name matches the logical system name. The maximum number of characters allowed for the technical name is 32.

A star schema is a technique used in the data warehouse database design to help data retrieval for online analytical processing.

For a SQL statement, many execution plans are possible. The database optimizer generates the most efficient execution plan based on either the heuristic ranking of available execution plans or the cost calculation of available execution plans. Statistics is the information that the cost-based optimizer uses to calculate the cost of available execution plans and select the most appropriate one for execution. BW uses the cost-base optimizer for Oracle databases.

System Administration Assistant is a collection of tools used to monitor and analyze general system operation conditions.

The system landscape specifies the role of each system and the paths used in transporting objects among the various systems.