New to BI

[Former Member]

Hi ,

I am new to BW & I know most of the concepts theorytically..

I have loaded the cube from file & am comfortable with this .

I would like to work with data from ECC LOCOCKPIT .

Is there any practice excersise I could try so that I can become familiar with extracting data from ECC

I do have acess to BI & ECC system.

Thanks

[Former Member]

hi

Before you try to work with a complex extraction like LO COCKPIT, its better you try to work on simpler ones like Generic Extraction from ECC tables so that you familiar with the extraction process from ECC first. Its a simple process:

1. Create a DS using transaction RSO2 in ECC.

2. Set the parameters for the DS.

3. Replicate the DS into BI, after confirming the RFC existence between ECC & BI.

4. Create an Infocube with respect to this replicated datasource.

5. Create transformation for this Infocube wrt such DS.

6. Create IP to fetch data from ECC to BI DS PSA.

7. Create DTP to fetch data from DS PSA to Infocube.

Hope this wud be a g8 exercise to start with.

Thanks,

Uday

[Former Member]

My recommendation is to tackle the LO Cockpit after you become familiar with the different type of extractors, i.e. delta enabled, real time data acquisition, etc. Start by creating a small Z table, or use ZFLIGHTS and with transaction SBIW, create a generic extractor. Test it in RSA3 in R3. Then replicate it into BW. I

If you really want to jump into the LO Cockpit, the transaction is LBWE. From there find the datasource you want to activate, activate it and generate it. Then go into your BW system and initialize the delta w/o data transfer. If everything works right so far, you should see the delta queue in RSA7 in R3.

Then post an SD document, run the collection job (scheduled via LBWE) and see the data in the delta queue in RSA7. Then run the data into BW by running a delta load.

[Former Member]

Hi,

Please check this step by step guide to configure LO cockpit extraction:

[LO Cockpit Set up|http://www.sdn.sap.com/irj/scn/index?rid=/library/uuid/50326ace-bac2-2b10-76bb-bd1a20ed2b57&overridelayout=true]

Regards,

Kams

[Former Member]

Hi,

One possible exercise could be:

- Create Custom extractor in ECC. for example an extractor of a std table.

- Replicate in BI

- Create a Transformation

- Create a ODS ( opcional )

- Create another Transformation ( opcional )

- Create a Cube

- Create a Process Chain to load the cube.

Regards,

Dani.

[Former Member]

If i have to extract the material master or customer master into a std cube could you let me know how do i define the the custom extractor.

I know for the locockpit you maintian the data source & run the steps like

Maintian Datasource

Replicate

Run the set up tables

created Info package & DTP .

I would appreciate the steps to read in a std ecc table.

Thx

[Former Member]

Hi -

First of all we don't have to load any master data into Cubes. For practice you can load into cubes. We load them directly to Masterdata infoproviders like (0Material_ATTR or 0customer_ATTR).

To create custom master datasource based on table/view. First go to rso2 in ECC and select master data attribute and give some ZNAME then click on create button. now give either your view or table and other required parameters in creation screen. now save your datasource and replicate into BI.

Anesh B

[Former Member]

I create a custom data source using the following steps

1. created master attributes

2. Application Component as "MM" & table as MARA

3. Saved the Data Source

While using RSA3 I could not view the newly created data source , I was only able to see datasource starting with 0.

I was able to run RSA3 on this data source & the result set was about 1000 records

How do I view the newly created data source in ECC.

I am unable to find the newly created data source ON BI side & hence unable to relicate this.

(I created the data source as a local object on the ECC side).

Thx

Defjam