on 02-14-2008 6:24 AM
hi gurus,
We are implementing SAP BW(sap netweaver2004s/BI7.0).As new version having lot of changes we need guidance.
After activation of standard infoobjects,cubes and datastore objects how to load the data into bw from SAP(ECC5.0 source system)?.What are the next steps we need to do?..Pls help us with the step by step in detail.
points will be assigned
satish
Hi
check on the BI best practices. Step by step solutions are provided
Regards
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
hi
first take data in PSA(infopackage)
then
I Then Carry on with the transformation & then DTP as ususal.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi,
we have two types of extractions 1) Application specific 2)cross application
under applicatin specific -->we have customer genenrated and business content extractions
under customer generated means LIS, CO-PA, FI-SL(i.e no ready made data source in business content so we have to generate datasource)
Business content means there is ready made business content datasource so we can use it
LIS,LO --> when ever we go for extracting logistics informatin
CO-PA--> for financial info
under cross APplicaion
Generic extraction-->table, view, infoset query, function module
Generic extractors are of 3 types:
1. Based on table/view
2. Based on Infoset Query
3. Based on Function module
The first 2 are straight forward extraction.
Check this blog for more info on fn module extractor:
genric exraction in real time scenarios
1.When Business content does not include a datsource for your application.
2.Business content requires additional enhancements that need datathat is not supplied by SAP BW.
3.The application does not features it's own generic data extraction method
4.you use your own programs to fill your tables in SAP Systems
LO -Realtime
This topic is explained by Roberto Negro for more details on LO and LIS extraction. Check the below link from roberto:
https://www.sdn.sap.com/irj/sdn/weblogs?blog=/pub/u/21406 [original link is broken]
COPA
Basically COPA- Profitability Analysis enables you to evaluate market segments, which can be classified according to products, customers, orders or any combination of these, or strategic business units, such as sales organizations or business areas, with respect to your company's profit or contribution margin.
The aim of COPA system is to provide your sales, marketing, product management and corporate planning departments with information to support internal accounting and decision-making.
Please check this COPA document:
http://help.sap.com/printdocu/core/Print46c/en/data/pdf/COPA/COPA.pdf
Pls chk this cookbook for step by step;
http://www.erpgenie.com/sapgenie/docs/MySAP%20BW%20Cookbook%20Vol%201.pdf
http://www.erpgenie.com/sapgenie/docs/MySAP%20BW%20Cookbook%20Vol%202.pdf
Step by step Generic extraction:
How To doc link
https://www.sdn.sap.com/irj/sdn/howtoguides
LIS Steps..
T.code - :MC18 create field catalog
1. Characteristic Catalog
Application-01-Sales and Distribution, 02-Purchasing, 03-Inventory Controlling, etc..
Catalog category 1. Characteristic catalog, 2. Key figures catalog 3. Date catalog Select characteristic catalog and enter, click on characteristic select the source table and it will be display the relevant source field and select the source field, copy + close, copy.
Save, similarly create key figures catalog
T.code : MC21 create infostructure
Example
Inforstructure : S789
Application 01
Choose characteristic select the catalog, select the fields, copy + close Choose key figures catalog select the key figures ,copy + close, save and generate
T.code MC24 create updating
Infostructure : S789
Update group : 01- Sales document, delivery, billing document ,enter Select the key figures click on rules for key figures give suggest rules, copy save and generate Click on updating (activate updating) Select the infostructure set periodic split 1. Daily, 2. Week, 3. Month, 4. Posting period Updating 1)No updating,2)Synchronous updating (V1), 3)As synchronous updating (V2), 4)As synchronous updating (V3),
T.code LBW0 - Connection of LIS Information structures to SAPBW Information structure : S786 Select the radio button-Setup LIS environment and Execute.
Select the radio button-Generate data source and Execute.
For Delta update:
Select the radio button-Generate updating and Execute Select the radio button -Activate / deactivate and Execute.
T.code SBIW Display IMG (implementation guide) Setting for applications specific data source logistics Managing transfer information structure setup of statistical data applications specific setup of statistical data perform statistical setup sales.
Choose activity
Setup Orders, deliveries, billing
Choose the activities enter the infostructure (S789), give name of the run, date of termination, time of termination, No. of tolerated faulty documents. Then execute
T.code RSA3 Extractor checker
Give the data source name eg. 2LIS 01S789 and execute, result will get some records Go to BW side replicate data source Assign infosource Create infocube Create update rules create infopackage and schedule the package with initialize delta process.
For delta update :
In R/3 side
T.code MC25, set update (V1) or (V2) or (V3)
T.code LBW0, choose generate updating and execute then choose activate / deactivate and execute
BW side - create infopackage and schedule the package with delta update.
First time if your scheduling the infopackage -in R/3 side T.code :MC25 -Udating set to No update,insted of selecting the update V1,V2,V3.
If your doing the Delta update:in R/3 side T.code :MC25-Updating set to either V1 or V2 or V3. and the to T.code :LBW0 -Select the radio button Active/deactivate and Execute.
and schedule the infopackage with delta update.
Modules for LIS :
SD,MM, PP,QM..
Deltas for LIS:
After setting up the LIS environment, 2 transparent tables and 1 extract structure is generated for this particular info structure. Within transaction SE11 you can view the tables SnnnBIW1, SnnnBIW2 and the structure SnnnBIWS and the InfoStructure itself Snnn
The tables S5nnnBIW1 & SnnnnBIW2 are used to assist the delta update process within BW.
Extract structure SnnnnBIWC is used as an interface structure between OLTP InfoStructure and BW
The OLTP system has automatically created an entry in the control table TMCBIW. Within transaction SE16 youll see, that for your particular InfoStructure the field BIW active has the value X and the field BIW status is filled with value 1 (refers to table SnnnBIW1).
The orgininal LIS update program RMCX#### will be enhanced within the form routines form Snnnbiw1_update_.... and form Snnnbiw2_update
With the transaction SE38 youll see at the end of the program starting at line 870 / 1006, that the program is enhanced within a BIW delta update coding
Within the flag Activate/Deactivate the update process into the delta tables (SnnnBIW1/Sn5nnBIW2) is swichted on/off. In the table TMCBIW is defined, which table is active for delta update.
Note: The delta updating is client dependent !
pls chk this link:
LO EXTRACTION
Go to Transaction LBWE (LO Customizing Cockpit)
1). Select Logistics Application
SD Sales BW
Extract Structures
2). Select the desired Extract Structure and deactivate it first.
3). Give the Transport Request number and continue
4). Click on `Maintenance' to maintain such Extract Structure
Select the fields of your choice and continue
Maintain DataSource if needed
5). Activate the extract structure
6). Give the Transport Request number and continue
Next step is to Delete the setup tables
7). Go to Transaction SBIW
8). Select Business Information Warehouse
i. Setting for Application-Specific Datasources
ii. Logistics
iii. Managing Extract Structures
iv. Initialization
v. Delete the content of Setup tables (Transaction LBWG)
vi. Select the application (01 Sales & Distribution) and Execute
Now, Fill the Setup tables
9). Select Business Information Warehouse
i. Setting for Application-Specific Datasources
ii. Logistics
iii. Managing Extract Structures
iv. Initialization
v. Filling the Setup tables
vi. Application-Specific Setup of statistical data
vii. SD Sales Orders Perform Setup (Transaction OLI7BW)
Specify a Run Name and time and Date (put future date)
Execute
Check the data in Setup tables at RSA3
Replicate the DataSource
Use of setup tables:
You should fill the setup table in the R/3 system and extract the data to BW - the setup tables is in SBIW - after that you can do delta extractions by initialize the extractor.
Full loads are always taken from the setup tables
The Lo-cockpit procedure is go with LBWE Transaction
so that you can get Applications 02,03,...etc
Under that you have
Extract structures
select your data source here Be sure that First you InActive that Then go with LBWG "Delete setup data"
here you can give the application No example 02(if your application is Purchase)
then once again LBWE go with Maintanace Tab select your Fields then your Datasource is Active position then You have to Fill the Data
then go with Extractor Checker RSA3
First create transformation and then DTP to schedule data from Datasource to target.
follow below links for clear idea.
http://help.sap.com/saphelp_nw70/helpdata/en/43/03b1f4dc636e72e10000000a422035/frameset.htm
fro transormation
http://help.sap.com/saphelp_nw70/helpdata/en/f8/7913426e48db2ce10000000a1550b0/frameset.htm
for creating transformation
http://help.sap.com/saphelp_nw70/helpdata/en/d5/da13426e48db2ce10000000a1550b0/frameset.htm
for DTP
http://help.sap.com/saphelp_nw70/helpdata/en/c5/85e5414f070640e10000000a1550b0/frameset.htm
Hope it helps.
Regards
CSM Reddy
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
61 | |
9 | |
7 | |
6 | |
6 | |
6 | |
5 | |
5 | |
5 | |
5 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.