cancel
Showing results for 
Search instead for 
Did you mean: 

We have issue with one BW report. The data for one custom/enhanced field is not getting populated in BW after January 21.

Former Member
0 Kudos

BW not picking data from custom field in SAP due to profile change of ALE_BW and ALEREMOTE

data for one custom/enhanced field is not getting populated in BW after January 21.

Background: Previously we have access for SAP_ALL and SAP_NEW fro userids ALE_BW and ALEREMOTE

Now we have removed SAP_ALL profiel from these due to Audit.

Now

BW not picking data from custom field in SAP due to profile change of ALE_BW and ALEREMOTE

data for one custom/enhanced field is not getting populated in BW after January 21.

I have checked ALE_BW and ALEREMOTE userids having below profiles

S_BI-WHM_RFC Business Information Warehouse, RFC user in the Warehouse

S_BI-WX_RFC Business Information Warehouse, RFC-User Extraction

Can you please check and suggest.

Screen shots. Data is not displayed in PSA YBQ, but it si availabel in ECC system YDQ

Accepted Solutions (0)

Answers (4)

Answers (4)

mohdshadab_shaikh
Active Participant
0 Kudos

Check in rsa3 (with calender day as filter beyond Jan 21) or in the currently delta queue rsa7, if value is supposed to get populated first. For the field to be checked, you can track back by looking the data source for the field.

anshu_lilhori
Active Contributor
0 Kudos

Hi,

can you share the piece of code written for that enhanced field.

Regards,

AL

Former Member
0 Kudos

It is pulling data fine as per logic in RSA3

till Jan 20 Data were coming fine in Production/Quality as per logic

there was no change either in SAP or BW side, Apart from profile change of ALE_BW and ALEREMOTE (We removed SAP_ALL, SAP_NEW and assigned S_BI-WHM_RFC and S_BI-WX_RFC)

0 Kudos

hi raju,

If you feel that changed profiles causing this, in next day load itself you won't get single record during extraction. so this is not authorsiation.

Please debug at info pack.

Thanks

Former Member
0 Kudos

BUT BW team said that this is Authorization issue only..We are using BW 3.5 version

0 Kudos

Hi Raju,

While doing extrcation, authorsation is not specific to field wise.Given/changed profiles are sufficnt to extract data.

Please go thru below link.

http://scn.sap.com/thread/115151

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

if its authorisation issue, info pack won't get records, its get 0 zero records. your missing some records there might formule issue or someing thing.

Try to debug you will know the casuse.

THanks

Former Member
0 Kudos

Thank you Raman..I will update you..They will test on Monday..I will post update :slightly_smiling_face:

Former Member
0 Kudos

This is test from BW team

If ALE_BW and ALEREMOTE is having SAP_ALL and SAP_New , He is geeting below data.

After Remove SAP_ALL and SAP_new and assigned S_BI-WHM_RFC and S_BI-WX_RFC

User will get below data..Model data is missing.

Former Member
0 Kudos

If ALE_BW and ALEREMOTE is having SAP_ALL and SAP_New , He is geeting below data.

0 Kudos

Hi raju,

Then you may need those roles to do extraction. same situation explain to your PM to get the approvals to have same profiles.

Thanks

rathy_moorthy2
Active Contributor
0 Kudos

Hi,

The RFC user on BW, receiving data from OLTP system, should have
profiles:
- S_BI-WHM_RFC
- S_RS_ALL

The RFC user on OLTP, receiving request from BW system, should have
profiles:
- S_BI-WX_RFC
- S_IDOC_ALL
- B_ALE_ALL

refer note 150315 for details

http://www.stechno.net/sap-notes.html?view=sapnote&id=150315

Former Member
0 Kudos

If I assigned above profiles also, Results are not coming.

Is it possible to run Trace on BW 3.5 systems..How to run Trace for this..

0 Kudos

Hi Raju,

Is this field is recently added or  after audit.

For custom field have you got the value while checking at RSA3.

THanks

Former Member
0 Kudos

This is not recently added, Long back ago on 2011.

0 Kudos

hi raju,

If allowed then try to debug with help of abap expert.

Custom defined object was filling by formula. please check

THanks

Former Member
0 Kudos

Hi,

I hope formula is not providing you the right values.

If possible check / paste the formula here, it might provide the analyzers a better idea.

Thank you.

Former Member
0 Kudos

Backend ECC system:  component: SAP_BW 701 0006

BW system:     SAP_BW 350 0013

        BI_CONT    353    0005