Inventory Marker Updates
Initialization INFOCUBE LEVEL and DATASOURCE LEVEL 7.0
IF 3.0 FLOW TRANSFERLEVEL SELECT OPENING BALANCE
SELECT OPENING BALANCE IN GENERAL TAB (BX ONLY)
IPACK LEVEL SELECT GENERATE INTI(BX)
IPACK LEVEL INITDELTA(BF,UM)
BX WITH MARKER
BF WITHOUT MARKER
UM WITHOUT MARKER
DELTALOAD
BX Wont Support Delta.
BF WITH MARKER
UM WITH MARKER
Friday, August 7, 2009
Thursday, July 2, 2009
Update Types in BI
Update types in BW/BI
With the update type, you control whether a key figure/data field is updated in the InfoProvider.
Functions
For InfoCubes:
Depending on the aggregation type you entered in the Key Figure Maintenance for this key figure, you are given the options Addition or Maximum or Minimum. If you choose one of these options, new values are updated in the InfoCube.
The aggregation type (addition, minimum & maximum) determines how key figures are updated where primary keys are the same. Thus the total, the minimum or the maximum for these values is formed for new values.
If you entered one of these aggregation types in the key figure definition, it is transferred for the update. Otherwise, the aggregation type addition is automatically selected.
• If you choose no update, the key figures are not updated in the InfoCube, meaning that no data records are written in the InfoCube with the first data transfer, or that data records that already exist, will remain in place with subsequent transfers.
For InfoObjects:
Only the Overwrite option is available. With this option, new values are updated to the InfoObject.
For ODS Objects:
1. Depending on the type of data and DataSource, you have the options Addition, Minimum, Maximum or Overwrite. If you choose one of these options, new values are updated in the ODS object.
For numerical data fields, you are given a proposal for the update type through the characteristic 0RECORDMODE. If only the after-image is delivered, the system proposes Overwrite. However, it could make sense to change this: For example, with the meter data field “# Changes”, which is filled with a constant 1 but still has to be updated through addition, although only an after-image is delivered.
Characteristic 0RECORDMODE is used to pass indicators of the DataSource (from SAP systems) to the update.
You do not need characteristic 0RECORDMODE as long as you do not load delta requests in the ODS object or only from file DataSources.
a. Addition:
Addition is not supported with the data types CHAR, DAT, TIMS, CUKY and UNIT. To be able to use the addition function, make sure the DataSource is compatible with an additive delta.
b. Overwrite:
Whether overwriting is supported is determined by the delta-compatibility of the DataSource.
In this example, the order quantity changes after it has been loaded into BW. With the second load process the data is overwritten since it has the same primary key.
First load process
Document No. Document Item Order Quantity Unit of measure
100001 10 200 Pieces
100001 20 150 Pieces
100002 10 250 Kg
Second load process
Document No. Document Item Order Quantity Unit of measure
100001 10 180 Pieces
100001 20 165 Pieces
When you update data, the system keeps to the time sequence of the data packages and requests. You have to decide the logical order of the update yourself. Meaning, for example, orders must be requested before deliveries; otherwise the wrong results may appear when you overwrite the data.
c. If you choose no update, the data fields are not updated in the ODS object, meaning that no data records are written in the ODS object with the first data transfer, or that data records that already exist will remain in place with subsequent transfers.
With the update type, you control whether a key figure/data field is updated in the InfoProvider.
Functions
For InfoCubes:
Depending on the aggregation type you entered in the Key Figure Maintenance for this key figure, you are given the options Addition or Maximum or Minimum. If you choose one of these options, new values are updated in the InfoCube.
The aggregation type (addition, minimum & maximum) determines how key figures are updated where primary keys are the same. Thus the total, the minimum or the maximum for these values is formed for new values.
If you entered one of these aggregation types in the key figure definition, it is transferred for the update. Otherwise, the aggregation type addition is automatically selected.
• If you choose no update, the key figures are not updated in the InfoCube, meaning that no data records are written in the InfoCube with the first data transfer, or that data records that already exist, will remain in place with subsequent transfers.
For InfoObjects:
Only the Overwrite option is available. With this option, new values are updated to the InfoObject.
For ODS Objects:
1. Depending on the type of data and DataSource, you have the options Addition, Minimum, Maximum or Overwrite. If you choose one of these options, new values are updated in the ODS object.
For numerical data fields, you are given a proposal for the update type through the characteristic 0RECORDMODE. If only the after-image is delivered, the system proposes Overwrite. However, it could make sense to change this: For example, with the meter data field “# Changes”, which is filled with a constant 1 but still has to be updated through addition, although only an after-image is delivered.
Characteristic 0RECORDMODE is used to pass indicators of the DataSource (from SAP systems) to the update.
You do not need characteristic 0RECORDMODE as long as you do not load delta requests in the ODS object or only from file DataSources.
a. Addition:
Addition is not supported with the data types CHAR, DAT, TIMS, CUKY and UNIT. To be able to use the addition function, make sure the DataSource is compatible with an additive delta.
b. Overwrite:
Whether overwriting is supported is determined by the delta-compatibility of the DataSource.
In this example, the order quantity changes after it has been loaded into BW. With the second load process the data is overwritten since it has the same primary key.
First load process
Document No. Document Item Order Quantity Unit of measure
100001 10 200 Pieces
100001 20 150 Pieces
100002 10 250 Kg
Second load process
Document No. Document Item Order Quantity Unit of measure
100001 10 180 Pieces
100001 20 165 Pieces
When you update data, the system keeps to the time sequence of the data packages and requests. You have to decide the logical order of the update yourself. Meaning, for example, orders must be requested before deliveries; otherwise the wrong results may appear when you overwrite the data.
c. If you choose no update, the data fields are not updated in the ODS object, meaning that no data records are written in the ODS object with the first data transfer, or that data records that already exist will remain in place with subsequent transfers.
Wednesday, June 24, 2009
What is SAP Portal?
SAP NetWeaver Portal [1] (formerly known as SAP Enterprise Portal, EP) offers a single point of access to information, enterprise applications, and services both in and outside your organization. It provides you the tools to manage this knowledge, to analyze and interrelate it, and to share and collaborate on the basis of it. With its coherent interface, role-based content, and personalization features, the portal enables you to focus exclusively on data relevant to your daily decision-making processes. SAP Enterprise Portal is one of the building blocks in the SAP NetWeaverTM architecture. Users only need a desktop and a Web Browser, and can begin work once they have been authenticated in the portal.
Tightly integrated into SAP Enterprise Portal are the knowledge management and collaboration capabilities of SAP NetWeaver, which allow users to share information, and to work together using that information.
Knowledge Management offers capabilities that everyone can use to distribute and access unstructured information within an organization through a heterogeneous repository landscape.
Collaboration brings users, information, and applications together to ensure successful cooperation. All collaboration tools and channels are easily accessible directly from the portal. These tools include collaboration rooms, instant messaging, chat, e-mail, and calendar integration.
SAP Unification Server enables an enterprise to integrate the resources of its information systems and provide unified access to its structured data. It is the engine driving the unification of databases, legacy systems and enterprise applications in SAP Enterprise Portal.
The Portal is used for different purposes.
* Internationalization
* Personalization
* Integration
* Authorization
SAP NetWeaver Portal is the platform for running Web Dynpro applications or Dyn Page applications created by SAP or custom designed for connecting to some ERP functionality.
Tightly integrated into SAP Enterprise Portal are the knowledge management and collaboration capabilities of SAP NetWeaver, which allow users to share information, and to work together using that information.
Knowledge Management offers capabilities that everyone can use to distribute and access unstructured information within an organization through a heterogeneous repository landscape.
Collaboration brings users, information, and applications together to ensure successful cooperation. All collaboration tools and channels are easily accessible directly from the portal. These tools include collaboration rooms, instant messaging, chat, e-mail, and calendar integration.
SAP Unification Server enables an enterprise to integrate the resources of its information systems and provide unified access to its structured data. It is the engine driving the unification of databases, legacy systems and enterprise applications in SAP Enterprise Portal.
The Portal is used for different purposes.
* Internationalization
* Personalization
* Integration
* Authorization
SAP NetWeaver Portal is the platform for running Web Dynpro applications or Dyn Page applications created by SAP or custom designed for connecting to some ERP functionality.
Wednesday, October 22, 2008
What is Business Content ?
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.
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.
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.
Subscribe to:
Posts (Atom)