ODS contains three tables namely
1. New Table 2. Active Table and 3. Change Log Table
Friday, September 26, 2008
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.
Subscribe to:
Posts (Atom)