What is Aggregate?
An aggregate is a subset of an InfoCube. The objective when using aggregates is to reduce I/O volume. The BW OLAP processor selects an appropriate aggregate during a query run or a navigation step. If no appropriate aggregate exists, the processor will retrieve data from the original InfoCube.
Wednesday, August 6, 2008
What is Multi-cube ?
What is Multi-cube ?
A multi-cube is a union of basic cubes. The multi-cube itself does not contain any data; rather, the data reside in the basic cubes. To a user, the multi-cube resembles a basic cube. When creating a query, the user can select characteristics and key figures from different basic cubes.
A multi-cube is a union of basic cubes. The multi-cube itself does not contain any data; rather, the data reside in the basic cubes. To a user, the multi-cube resembles a basic cube. When creating a query, the user can select characteristics and key figures from different basic cubes.
What is PSA ?
What is PSA ?
PSA is a data staging area in BW. It allows us to check data in an intermediate location, before they are sent to their destinations in BW.
PSA is a data staging area in BW. It allows us to check data in an intermediate location, before they are sent to their destinations in BW.
Tuesday, July 29, 2008
What is BW Monitor ?
What is BW Monitor ?
BW Monitor displays data load status and provides assistance in troubleshooting if errors occur.
BW Monitor displays data load status and provides assistance in troubleshooting if errors occur.
What is BW Scheduler ?
What is BW Scheduler ?
BW Scheduler specifies when to load data. It relies on the same techniques used for scheduling R/3 background jobs.
BW Scheduler specifies when to load data. It relies on the same techniques used for scheduling R/3 background jobs.
Tuesday, July 1, 2008
What is Update rule ?
What is Update rule ?
An update rule specifies how data will be updated into a target. The data target can be an InfoCube or an ODS object. If the update rule is applied to data from an InfoSource, its technical name will match the InfoSource's technical name. If the update rule is applied to data from an ODS object, its technical name will match the ODS object's technical name prefixed with number 8.
An update rule specifies how data will be updated into a target. The data target can be an InfoCube or an ODS object. If the update rule is applied to data from an InfoSource, its technical name will match the InfoSource's technical name. If the update rule is applied to data from an ODS object, its technical name will match the ODS object's technical name prefixed with number 8.
What is InfoPackage ?
What is InfoPackage ?
An InfoPackage specifies when and how to load data from a given source system. BW generates a 30-digit code starting with ZPAK as an InfoPackage's technical name.
An InfoPackage specifies when and how to load data from a given source system. BW generates a 30-digit code starting with ZPAK as an InfoPackage's technical name.
Subscribe to:
Posts (Atom)