Problem with BPS

[Former Member]

Dear Experts,

We are having a problem with report which is included with BPS.

when we upload the customer through the flat file to the BPS Link,we are getting the result and when we give the customer manually and press the enter button we are not able to get the result for the same customer.we are having upload option too for multiple customers through flatfile and the manual option where thaey can give single customer,since endusers cant use file upload for single customer when they want to see sales specific to that customer.

this is happening only with some customer numbers and not for all customers,when we give some other customers even manually in the BPS link and press enter we are able to see the result.

we have checked the query and have debugged for different customer numbers,we are able to see the values in the debug mode for the same and when the display ia happenning the result was blank for few customers.

we are new to the BPS,might be any problem in BPS layout or Business server page code.

it would be a great help if any suggestions to over come the problem.

Regards,

Sunil

[Former Member]

Solved

[Former Member]

Hi,

First u need to identify is it a problem with master data or transactional data load.

Check for characteristic relationship in Infoarea,then as u have mentioned some of the specific customers records u are not able to upload try entering them through RSINPUT T.code (it's not advisable to use this )but still can test for master data checks.

If you are able to upload the data through this transaction and save it correctly in Cube as required,then problem is in GUI or the BSP which you have given for upload.

If you have given web interface then it could be that u have to regenerate it.

Check it up,hope it may be helpful.

[Former Member]

Hi Indu,

i am able to upload all the customers through file,the exact problem was,

1.i am able to see the result for the customer 0000900006 when i am uploading through the file.

2.Instead of uploading,when i will give the same customer 0000900006 in the BPS Input and enter for the result,we are not able to see the result,since user can also use report in this manner when his intension was to see details with respect to single customer.

this is happening only with few customer numbers,when we have given some other customers like example 0000102218 and enter manually we are able to see the result.

As you told we are having webinterface,as per my knowledge it is WAD APPLICATION right where it is used to integrate query with BPS.

Regards,

Sunil.

[Former Member]

Hi Indu,

i have seen the webinterface for the BPS in the transaction BPS_WB and it is the place where we will inlcude our WAD APPLICATION which in turn contains the Bex QUERY for providing the data.Please correct me if i am wrong.

why do we need to regenerate the Web Interface.i am new to this concept and noidea regarding the same.

Regards,

Sunil...

[Former Member]

Hi Sunil,

I will suggest few steps as a check,not sure if it can really help u out but can give it a try:-

1.Check ; manual planning layout (Is it working fine or not ) by executing directly through transaction BPS0.

2.Key in entries which you are trying to push through WAD.

3.If you are able to key in values here then the problem is in WAD Interface,else the catch is here.

4.If you are not able to key in manual planning layout then check for planning package and planning level used ,what restrictions are been used are u taking care of all while entering the data.

5.If layout is working fine the you have to check the same in BPS_WB transaction by executing it or viewing it's preview.

6.If you are able to key in there then no need of interface regeneration else you have to regenerate the interface.

Why do we have to regenerate?

Coz if you have done any changes layout BPS_Wb even a single property is been changed or layout is been changed,correspondingly the interface gets deactivated in SICF ..I don't remember the correct t.code where we have BSP files..So It activates those files after regeneration.