on 2014 Jan 16 11:39 AM
Hi Group,
Can any body help how to trigger Events in BI system using PI.
Rajiv
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.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
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
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
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
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)
Hi Rajiv,
you can read the file name from sender File adapter (by checking the ASMA option File name). The you have two option
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
Hi Rajiv,
You can use proxy or RFC.
Check this SAP Document, you will see all about integrations with SAP BI and SAPI.
Also:
http://scn.sap.com/message/14676604#14676604
Regards,
Ricardo Viana.
Message was edited by: Ricardo Viana
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
70 | |
10 | |
10 | |
7 | |
6 | |
6 | |
6 | |
5 | |
5 | |
5 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.