Clarification on 7.0 Standard datasource

[Former Member]

Hi,

There are some standard datasources like 2lis_02_ITM and 2lis_02_SCL .

How to load the data into cube as there are update rules and transfer rules crated for the standard cube.

Data is loaded into PSA. Shall I have to create transformations or can I do anything with the update rules/transfer rules.

Please suggest me the procedure.

Thanks in advance!

[Former Member]

Hi pallavai,

have you installed Standard Cube for the mentioned Data Sources.

Then you have to run schedule.

Check the Data Targets selected or not in Data Target tab in Info Package.

If the Standard Cube is installed then no need to create transformations.If you want to migrate then it is necessary to Create Transformations.

There is no Standard Tarnsformations available to install.

Let us know status..

Reg

Pra

[chemicala_srimallikarjuna]

Hi,

LO Cockpit Step By Step

LO EXTRACTION

Go to Transaction LBWE (LO Customizing Cockpit)

1). Select Logistics Application

SD Sales BW

Extract Structures

2). Select the desired Extract Structure example 2LIS_13_VDITM 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 T-Code 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 (T-Code 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 (T-Code 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

Some more 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

*pls assign points,if links are useful*

Regards

CSM Reddy