cancel
Showing results for 
Search instead for 
Did you mean: 

Events trigger

former_member188791
Participant
0 Kudos

Hi Group,

Can any body help how to trigger Events in BI system using PI.

Rajiv

Accepted Solutions (0)

Answers (2)

Answers (2)

iaki_vila
Active Contributor
0 Kudos

Hi Rajiv,

This theme has been dealed in some threads like these:

Also you can read the tips pointed by Sergio Locatelli in his blog


Regards.

former_member188791
Participant
0 Kudos

Hi Ricardo,

Thank you for your document, but my scenario is bit simple , when file appears in Directory without reading whole file just needs to trigger the event using FM BP_EVENT_RISE, how we can achieve this without reading massive file data

gagandeep_batra
Active Contributor
0 Kudos

Hi Rajiv,

I am not sure but you can check,

create Scenario like File to Proxy with dummy structure.

At Sender side use some dummy structure  with occurrence one and define the dummy FCC  parameter which read just first line of the file and create a message and in mapping you can ignore that data and send some dummy or constant value to  proxy which will trigger your event in proxy code "BP_EVENT_RISE"

Regards

GB

iaki_vila
Active Contributor
0 Kudos

Hi Rajiv,

You can use two directories in the BI system, “Received” and “Treated” . PI can poll the received directory, if PI find a file, it will archive the file directly in the sender file side. The scenario will be FILE – RFC, you don need to pass any value, no problem you only trigger the RFC.

I just check that BP_EVENT_RISE is not a RFC, you will need to wrap it with a Z RFC function.

Regards.

Message was edited by: Iñaki Vila

former_member188791
Participant
0 Kudos

Hi Inaki,

Still I am not clear how RC can trigger without passing file data sender structure

Harish
Active Contributor
0 Kudos

Hi Rajiv,

RFC will trigger when you have get the file from  “Received” directory and your sender File communication channel with archieve the file in “Treated” directory (in source server).

Hope this will clear your doubt.

regards,

Harish

former_member188791
Participant
0 Kudos

Hi Harish,

Thank you for your response, but can you tell me what will be source and target structure and in ID how the configuration will be

gagandeep_batra
Active Contributor
0 Kudos

Hi Rajiv;

AS i earlier said

Create Sender and Receiver  Structure like below map it one to one

here occurrence is one only

Root

Record     1..1

     row          1..1

At Recerver side create proxy for that

& in proxy you can call your RFC

& in  sender CC use Archive option to archive the file to another folder &  you FCC which will pick only first line of the file as below:

Record.endSeprator = 'nl'

Record.fieldNames=row

ignoreRecordsetName = true

Former Member
0 Kudos

Hello Rajiv,

1st option :

Just create a file to XI Proxy scenario. The receiver adapter will be XI in this case.

In the proxy code call the FM BP_EVENT_RAISE to raise an event.

In this case you have to use file content conversion to do some mapping as i guess you are using flat file.If the file is already XML then just do a simple mapping with source and target structures the same.


2nd option :

if your file directory is accessible through your BI system(if the directory is mounted) then you can create a simple program to run as a batch job in BI system which wll check if the file is there in the directory and if its there an event will be raised.

3rd option :

Create a simple file to file scenario without ESR in PI and transfer the file to a directory oin BI system and then create a program as per option 2.

Thanks

Gaurav Ranjan

former_member188791
Participant
0 Kudos

Hi Gagandeep,

Sorry for the delay in the response, but this is not working, I am getting the below Error in RWB:

Explanation 

Error 21/01/14 12:04:23   Conversion initialization failed: java.lang.Exception: java.lang.Exception: java.lang.Exception: Error(s) in XML conversion parameters found: Parameter 'RecordSet.fieldFixedLengths' or 'RecordSet.fieldSeparator' is missing Consistency check: no. of arguments in 'RecordSet.fieldFixedLength' does not match 'RecordSet.fieldNames' (0 <> 1) 

gagandeep_batra
Active Contributor
0 Kudos

Add

Record.fieldSeparator = , or blank

Regards

GB

former_member188791
Participant
0 Kudos

Hi Gagandeep,

Is there any way I can take File Name also in proxy ,I need to store file name in the custom table

Harish
Active Contributor
0 Kudos

Hi Rajiv,

you can read the file name from sender File adapter (by checking the ASMA option File name). The you have two option

  1. Set the file name to one of the field in message (proxy can read the field and store in table)
  2. Set the dynamic variable at header

First option is straight forward and easy to implement. for the second option you need to consume the soap header in ABAP proxy code. Please refer the below thread for consuming soap header

regards,

Harish

rhviana
Active Contributor
0 Kudos

Hi Rajiv,

You can use proxy or RFC.

Check this SAP Document, you will see all about integrations with SAP BI and SAPI.

http://www.sdn.sap.com/irj/scn/go/portal/prtroot/docs/library/uuid/40574601-ec97-2910-3cba-a0fdc10f4...

Also:

http://scn.sap.com/message/14676604#14676604

Regards,

Ricardo Viana.

Message was edited by: Ricardo Viana