URGENT:-Sales Data Extraction

[Former Member]

Hi..

I have a requirement of loading data for sales DataSource(2lis_11*,12*,13*) in BW side.

As i know the sales DataSources is more compatible with InfoCube.

Unfortunately our reporting tool does not support reporting for infocube data, that's why i have to load data in DSO only.

I have created a DSO and loaded data into DSO, but i m not getting correct data in DSO(for 2LIS_13VDHDR, VDITEM).

First i have executed DTP for Item data After that executed for header. but data get double in DSO Active table.

Note: DSO contain transformations for both Header & Item DataSources

How it can be possible to get correct data.

Please help me out.

thanks in advance.

[former_member182997 · Accepted solution]

Using correct logic  correct data can be get in the data target.
Check how DSO is getting a new record. If this logic is understood, you will get to know what should be the key fields and how data should be transferred into DSO depending on these key fields so that data records are unique in each row.
Also what changes you should bring in transformation and the DTP.
there are options of handling duplicate data records at DTP level did you notice?

Tweaks you can use:
Include the characteristic for which PSA entries are unique in nature. (such as ROCANCEL)
Use handle duplicate records  in DTPs
Also using Delta after 1 full load is always recommended.
Use of overwrite for KF

Check what you need from header data and accordingly modify the transformation. Unassign unnecessary fields. Do the same for all the three datasources.

thanks

[Former Member · Accepted solution]

Hi BI,

My Scenario it that, i have to load data for:

2LIS_11*

2LIS_12*

2LIS_13*

What i have done..i have created a DSO(for 2LIS_13* DS) and also created separate transformation for both Header and item data.

Is it possible to get correct data for both datasource(2LIS_13_VDHDR, VDITEM) in a single DSO?

And also explain the detail for loading process

Thanks

[former_member195163 · Accepted solution]

Hi,

why don't you implement the correct standard flow, using the InfoCube, and then create specific DSOs for each Infocube?

thanks

[former_member220624 · Accepted solution]

Hi Avinash,

Generally item and header level are loaded to two different dso's and then to a cube.

If you use a single dso you will get double records.

Since you don't want to include the cube you can think about using a Multi provider based on the two dso's and report on that..

Regards,

Amit

[Former Member · Accepted solution]

Hi..Amit,

We are using Microsoft SSRS(for reporting), it does not support application level reporting..it only support table level reporting that's why i m using DSO only because it accept DSO Table to build query and generate report. This is the main problem...that i m using DSO instead of InfoCube.

and also it wont,t support Multiprovider

[Former Member · Accepted solution]

Hi Giuliano Gaudino,

Is it possible to use DSO on the top of InfoCube,While InfoCube is upper level InfoProvider than DSO?

Thanks.

[former_member195163 · Accepted solution]

Hi,

Yes it is. You can try it and let me know.

Regards

Giuli

[former_member195163 · Accepted solution]

I made the same thing for the Infocube CO-OM: Costs and Allocations (0COOM_C02) because the reporting is by Qlik View and the source structure must be DSOs

[former_member220624 · Accepted solution]

Hi Avinash,

In that case you can load to the two dso's for header and item and then to an info-cube.

After that create a third dso on top of the cube and check for the key-figure properties (addition/overwrite) in the transformation and load.

Hope this helps.

Regards,

Amit

[Former Member · Accepted solution]

hi   Giuliano Gaudino ,

I have created a DSO on the top of InfoCube. here is my data load sequence:

Data Load for InfoCube:

1. Transformation from DataSource(2LIS_13_VDHDR, 2LIS_13_VDITEM) to InfoCube.

2. First executed DTP for 2LIS_13_VDITEM and then 2LIS_13_VDHDR.

but In InfoCube, fields are empty for 2LIS_13_VDHDR  DataSource.

Data Load for DSO:

Tranformation from InfoCube to DSO.

but also in DSO , fields are empty for 2LIS_13_VDHDR

Please help me out..

Thanks

[former_member195163 · Accepted solution]

Hi Kumar,

did you do the right steps to initialize in ECC the LIS extractor?

LO Cockpit Step By Step

Regards

[Former Member · Accepted solution]

Hi Giuliano Gaudino,

Q..did you do the right steps to initialize in ECC the LIS extractor?

A..Yes.

Problem is that if i execute the DTP for VDHDR first, then i get Data for header only.

and if i execute the DTP for VDITM, then i get data only for Item.

Suggest me How to resolve it.

Thanks.

[Former Member · Accepted solution]

Hi Giuliano Gaudino,

I did as u have said...i have kept a DSO on the top of InfoCube.  I have loaded data for few fields in to InfoCube for my testing purpose and now i m getting correct data for these fields.

but i have a doubt that, there are two DataSource in which some fields are common in both..so i want to know that how to map same filed from both DataSource in same InfoCube.

Do i need to map same fields in both transformation?

for example:VBELN, FKART, FKDAT, BZIRK fields are in both DataSources(2LIS_13_VDHDR, VDITM)..how to map it for a single InfoCube. Because my InfoCube contains transformatin from these two DataSources.

Please suggest me for above.

let me try it for real time load, i will let u know.

Thanks.

[former_member195163 · Accepted solution]

Hi avinash kumar,

you can maps both because you have key fileds for each trasformation that created different rows.

Regards

[Former Member · Accepted solution]

Thanks for ur response.

let me try it, i will let u know if any concerns.

thanks.

[former_member195163 · Accepted solution]

any poits for me?

[Former Member · Accepted solution]

now it works fine for init., let me see it for delta.

Thanks GG

POINT ASSIGNED.

[Former Member · Accepted solution]

Hi Avinash,

Amit steps is standard flow based on the SAP implementation. Like for example if some one wants to use header or Item and need to lookup then he cant do it on InfoCube ( you can but need to use function module).

If you desire to do this solution to implement make sure you need to write some start and End routine  programming.

Let us know if you have any questions.

Thanks

Ganesh Reddy.