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.
Subscribe to:
Posts (Atom)