cancel
Showing results for 
Search instead for 
Did you mean: 

2LIS Extractors issue

Former Member
0 Kudos

Hello Experts,

we have one LO extarctor which is pulling information from standard ECC table.

but we require some information from a custom table.

Is it possible to tweak the extractor and include the custom table as well for LIS extractor?

What would be the challenges and risk involved here?

Regards,

Ankie

Accepted Solutions (1)

Accepted Solutions (1)

Former Member
0 Kudos

Hi Ankie,

               Yes you can pull Data from your custom table along with your Standard Extractor. For that you need to enhance your extractor.Prerequisite is at least on key field must match between two tables.

 

There are so many  threads regarding this topic you can google it.

Thanks

Ravindra.

Former Member
0 Kudos

HI Ravindra,

Suppose my extractor is based on VBAP and VBUP table , if we add the extra field from some Z table in extract structure, will that field be visible in communication structure in LBWE with other vbap and VBUP fields?

Regards,

Ankie

RamanKorrapati
Active Contributor
0 Kudos

No, Enhanced fields won't be visible at Communication structure which we can see at LBWE.

But you can see them at RSA6 and RSA3 with your data source.

Because we added enhanced fields to extract structure.

Enhanced fields need to unhide at RSA6. Be default those are hidden.

Answers (3)

Answers (3)

Former Member
0 Kudos

Hello Experts,

I need to build a new flow here in BW in which I have a existing cube loading full load daily and deleting previous requests.

I want to build another DSO( as i need to put some filter through start routine and put this information in DSO and then I will build cube on top of it ) on that. I would like to clear my doubt on that before I start:-

1- which DSO should I create on top of the cube, standard or write optimized?

2- initially I have to load full data to DSO through full load from cube, can I use delta DTP after that ?

will it pick the changed and new records after that?.

Regard,

Ankie

karthik_vasudevan
Active Contributor
0 Kudos

Hi Ankie

All your questions are very generic. Everything is possible with small changes here and there.

Be more specific in what records you have and why do you want to do this with an example or screenshots.

Please close this thread and open a new one which will help others to search based on the title of the discussion.

Regards

Karthik

Former Member
0 Kudos

Hi Ankie

Before giving a thought to create DSO on top CUBE, check the no.of characteristics in cube, as all these act as keys in cube, as you know DSO has a limitation of key fields , you can accommodate only 16.

the reason I am asking you to check this is because, DSO key figure values may get summarized if CUBE key fields are not equal to DSO key fields.

Former Member
0 Kudos

Hi Jyothi,

There are around 30 chars in cube.

will it be not possible to create a DSO on top of cube for my scenario ?

Regards,

Ankie

former_member183519
Contributor
0 Kudos

Hi Ankie,

Is it possible to tweak the extractor and include the custom table as well for LIS extractor?

Yes, using Append structure we can enhance LIS DS.

What would be the challenges and risk involved here?

use last section on link:(Enhance it, but mind the queue !)


Regards,

Hitesh

karthik_vasudevan
Active Contributor
0 Kudos

Hi Ankie

Yes, it is possible to enhance the LIS datasources.

There are lot of documents available out there to do this simply. Few are given below. Go through them and start you activities. When you get stuck, let us know. We will help you out.

How-to enhance LO-Cockpit DataSources with delta-relevant fields - SAP NetWeaver Business Warehouse ...

http://www.sdn.sap.com/irj/scn/go/portal/prtroot/docs/library/uuid/60cc14a4-8b48-2d10-6cba-f2b11ba95...

http://www.sdn.sap.com/irj/scn/go/portal/prtroot/docs/library/uuid/00c1f726-1dc2-2c10-f891-ddfbffdb1...

https://scn.sap.com/thread/1396489

Regards

Karthik