What is Business Content ?
Business Content is a complete set of BW objects developed by SAP to support OLAP tasks. It contains roles, workbooks, queries, InfoCubes, key figures, characteristics, update rules, InfoSources, extractors for SAP R/3, and other mySAP solutions.
Wednesday, October 22, 2008
What is DataSource ?
What is DataSource ?
A DataSource is a structure in the source system that specifies the method for transferring data out of the source system. If the source system is R/3, replicating DataSources from a source system will create identical DataSource structures in the BW system.
A DataSource is a structure in the source system that specifies the method for transferring data out of the source system. If the source system is R/3, replicating DataSources from a source system will create identical DataSource structures in the BW system.
Wednesday, October 15, 2008
What is Delta update ?
What is Delta update ?
The Delta update option in the InfoPackage definition requests that BW load only the data that have been accumulated since the last update. Before performing a delta update, the delta process must be initialized.
The Delta update option in the InfoPackage definition requests that BW load only the data that have been accumulated since the last update. Before performing a delta update, the delta process must be initialized.
What is Full update?
What is Full update?
The Full update option in the InfoPackage definition requests that BW load all data that meet the selection criteria specified under the Select data tab.
The Full update option in the InfoPackage definition requests that BW load all data that meet the selection criteria specified under the Select data tab.
Friday, September 26, 2008
How many Tables are there in ODS?
ODS contains three tables namely
1. New Table 2. Active Table and 3. Change Log Table
1. New Table 2. Active Table and 3. Change Log Table
What is ODS ?
What is ODS ?
ODS is a BW architectural component that appears between PSA and InfoCubes and that allows BEx reporting. It is not based on the star schema and is used primarily for detail reporting, rather than for dimensional analysis. ODS objects do not aggregate data as InfoCubes do. Data are loaded into an ODS object by inserting new records, updating existing records, or deleting old records as specified by 0RECORDMODE value.
ODS is a BW architectural component that appears between PSA and InfoCubes and that allows BEx reporting. It is not based on the star schema and is used primarily for detail reporting, rather than for dimensional analysis. ODS objects do not aggregate data as InfoCubes do. Data are loaded into an ODS object by inserting new records, updating existing records, or deleting old records as specified by 0RECORDMODE value.
Tuesday, September 9, 2008
What is Workbook ?
What is Workbook ?
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 only need to name a workbook's title.
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 only need to name a workbook's title.
What is Query ?
What is Query ?
A BW query is a selection of characteristics and key figures for the analysis of the data in an InfoCube. A query refers to only one InfoCube, and its result is presented in a BEx Excel worksheet. The maximum number of characters allowed for the technical name is 30.
A BW query is a selection of characteristics and key figures for the analysis of the data in an InfoCube. A query refers to only one InfoCube, and its result is presented in a BEx Excel worksheet. The maximum number of characters allowed for the technical name is 30.
Wednesday, August 6, 2008
What is Aggregate?
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.
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.
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.
Wednesday, June 25, 2008
What is Transfer rule ?
What is Transfer rule ?
Transfer rules specify how DataSource fields map to InfoSource InfoObjects.
Transfer rules specify how DataSource fields map to InfoSource InfoObjects.
What is Transfer structure ?
What is Transfer structure ?
A transfer structure maps DataSource fields to InfoSource InfoObjects.
A transfer structure maps DataSource fields to InfoSource InfoObjects.
What is DataSource ?
What is DataSource ?
A DataSource is not only a structure in which source system fields are logically grouped together, but also an object that contains
ETTL-related information.
Four types of DataSources exist:
1.DataSources for characteristic attributes
2.DataSources for characteristic texts
3.DataSources for characteristic hierarchies
4.DataSources for transaction data.
The maximum number of characters allowed for the DataSources technical name is 32.
A DataSource is not only a structure in which source system fields are logically grouped together, but also an object that contains
ETTL-related information.
Four types of DataSources exist:
1.DataSources for characteristic attributes
2.DataSources for characteristic texts
3.DataSources for characteristic hierarchies
4.DataSources for transaction data.
The maximum number of characters allowed for the DataSources technical name is 32.
What is Communication structure ?
What is Communication structure ?
The communication structure serves as the structure in the InfoSource.
The communication structure serves as the structure in the InfoSource.
Monday, June 23, 2008
What is InfoObject Catalog?
What is InfoObject Catalog?
InfoObject Catalogs are used to organize InfoObjects. Two types of InfoObject Catalogs exist: one for characteristics and one for key figures. The maximum number of characters allowed for the technical name is 30.
What are types of InfoObject Catalog?
1. Characteristic InfoObject Catalog.
2. Key figure InfoObject Catalog.
InfoObject Catalogs are used to organize InfoObjects. Two types of InfoObject Catalogs exist: one for characteristics and one for key figures. The maximum number of characters allowed for the technical name is 30.
What are types of InfoObject Catalog?
1. Characteristic InfoObject Catalog.
2. Key figure InfoObject Catalog.
What is Key figure?
What is Key figure?
Key figures are numeric values or quantities, such as Per Unit Sales Price, Quantity Sold, and Sales Revenue. The maximum number of characters allowed for the technical name is 9.
Key figures are numeric values or quantities, such as Per Unit Sales Price, Quantity Sold, and Sales Revenue. The maximum number of characters allowed for the technical name is 9.
What is Application component ?
What is Application component ?
Application components are used to organize InfoSources. They are analogous to the InfoAreas in InfoCubes. The maximum number of characters allowed for the technical name is 32.
Application components are used to organize InfoSources. They are analogous to the InfoAreas in InfoCubes. The maximum number of characters allowed for the technical name is 32.
What is InfoSource ?
What is InfoSource ?
An InfoSource is a structure in which InfoObjects are logically grouped together. InfoCubes and characteristics interface with InfoSources to get source system data. The maximum number of characters allowed for the technical name is 32.
An InfoSource is a structure in which InfoObjects are logically grouped together. InfoCubes and characteristics interface with InfoSources to get source system data. The maximum number of characters allowed for the technical name is 32.
What is Source system ?
What is Source system ?
A source system is a protocol that enables BW to know where to find data and how to extract those 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, its technical name matches its logical system name. The maximum number of characters allowed for the technical name is 32.
A source system is a protocol that enables BW to know where to find data and how to extract those 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, its technical name matches its logical system name. The maximum number of characters allowed for the technical name is 32.
Thursday, June 19, 2008
What is Characteristic?
What is Characteristic?
Characteristics are descriptions of key figures, such as Customer ID, Material Number, Sales Representative ID, Unit of Measure, and Transaction Date. The maximum number of characters allowed for the technical name is 9.
Characteristics are descriptions of key figures, such as Customer ID, Material Number, Sales Representative ID, Unit of Measure, and Transaction Date. The maximum number of characters allowed for the technical name is 9.
Monday, June 16, 2008
What is InfoArea?
What is InfoArea?
InfoAreas are used to organize InfoCubes and Info Objects. Each InfoCube is assigned to an InfoArea. Through an InfoObject Catalog, each InfoObject is assigned to an InfoArea as well. The maximum number of characters allowed for the technical name is 30.
Enter Technical Name ZTEST and Description Test Info Area and Say YES
InfoAreas are used to organize InfoCubes and Info Objects. Each InfoCube is assigned to an InfoArea. Through an InfoObject Catalog, each InfoObject is assigned to an InfoArea as well. The maximum number of characters allowed for the technical name is 30.
Enter Technical Name ZTEST and Description Test Info Area and Say YES
Saturday, June 7, 2008
Creating an Info Cube
Creating an Info Cube
An SAP BW info cube includes a fact table and up to 16 dimension tables, 3 of which are predefined, i.e. Time, Unit, and Info Packages (defines extraction order and selection criteria for data load). In SAP BW, Info Cubes may be either a basic Cube, a Multi Cube, or a Remote Cube.
An SAP BW info cube includes a fact table and up to 16 dimension tables, 3 of which are predefined, i.e. Time, Unit, and Info Packages (defines extraction order and selection criteria for data load). In SAP BW, Info Cubes may be either a basic Cube, a Multi Cube, or a Remote Cube.
Subscribe to:
Posts (Atom)