Skip to Content
Author's profile photo Sunil Chandra

Lets Excel : Enhanced Communication Channel search in SAP PI

1. How many file channels are using file content conversion?

2. How many channels are using OS command?

3. Identify the channels that are using a particular adapter module in module configuration?

4. How many channels are configured with variable substitution?

5. List out the email ids configured in the mail channels along with business component?

There are many more possibilities of such questions.

Have you ever come across these kinds of questions before? If yes, then you know already how tedious it is to answer without properly updated documentation. Even if it is documented, it takes time to figure out the exact details. And what if you don’t have any documentation? Don’t worry. There is no need to check each and every channel from now on.  Yes, it’s possible now with an Excel application in a couple of seconds.

Pre-Requisite for using the application

User must be assigned with following roles in java stack

1. PI <= 7.0 – Api_display

2. PI > = 7.1 – SAP_XI_API_DISPLAY_J2EE

How to use

1. Download the Excel. Open it and enable macro.

2. Press ALT + F11 > Tools > References > Select the required library > click OK > close the window

3. Click Search Screen button on Search sheet  to open the form

4. Click SID label available at left top to System Configuration window

5. Enter the details SID host:port username password > Click Add System

This is a memory extensive step, so wait till it gets completed.

6. Click Back to Filter Screen.

7. Select the SID from the dropdown.

The channel search is ready to use now. Please note that this is kind of local search that works on downloaded channel details.

Also you can play around with search query by checking Run manual query.

image

Now you have the solution 🙂

*********************************************************************

1. How many file channels are using file content conversion?

SID > AdapterType = File > MessageProtocol = FileCSV > Search


2. How many channels are using OS command?

Run OS Command before message processing 

SID > AdapterType = File > AttributeName = file.preprocess.execute > AttributeValue = % > Search

Run OS Command after message processing 

SID > AdapterType = File > AttributeName = file.execute > AttributeValue = % > Search

Or simply.. SID > AdapterType = File > AttributeName = file%execute > AttributeValue = % > Search


3. Identify the channels that are using a particular adapter module?

SID > ModuleName = selectedValue > Search


4. How many channels are configured with variable substitution?

SID > AttributeName = file.varSubstitution > AttributeValue = 1 > Search


5. List out the email ids configured in the mail channels along with business component?

MailTo  SID > AttributeName = Mail.MailTo > AttributeValue = % > Search

MailCc   SID > AttributeName = Mail.MailCc > AttributeValue = % > Search

or simply  SID > AttributeName = Mail.Mail%  > AttributeValue = % > Search


*********************************************************************

I hope this tool would help you capturing communication channel details easily, increase productivity and improve the way you work. 

At end, special thanks to lliya Kuznetsov for his blog Simple reporting over PI communications channels that motivated me for this creation.

Assigned Tags

      21 Comments
      You must be Logged on to comment or reply to a post.
      Author's profile photo Laxman Molugu
      Laxman Molugu
      Hi Sunil,

      I couldn't find the button "Search Screen" and also which search screen are you referring?

      Thanks,
      Laxman

      Author's profile photo Sunil Chandra
      Sunil Chandra
      Blog Post Author
      "Search Screen" button is available at top of the Search sheet when you open the application.

      Thanks,
      Sunil Chandra

      Author's profile photo Mallam Mustak
      Mallam Mustak

      Hi,

      I am new to PI Upgradtion Project.

      We are planning to upgrade PI 7.11 to PI 7.3.

      Can you please help me what are the steps we have to fallow to upgdrade PI and what are the changes/Issues need to takecare when upgradtion in PI.

      Share me your ideasssssssssssssssssss.......

      Thanks,

      Mallam

      Author's profile photo Roberto Cantero
      Roberto Cantero

      Sorry I am not familiar with excel and I don't know how to add PI parameters. Could you please let me know how to do it?

      regards,

      Roberto.

      Author's profile photo Sunil Chandra
      Sunil Chandra
      Blog Post Author

      I have updated the How to use section. I guess it was lost somewhere while transition to new  SCN.

      Regards,

      Sunil Chandra

      Author's profile photo Former Member
      Former Member

      Hi Sunil,

      could you kindly tell me how to configure to connect to PI server?

      Author's profile photo Sunil Chandra
      Sunil Chandra
      Blog Post Author

      It gets connected in System Configuration screen that comes when you click SID in the main filter screen. Here you enter the details and Add the system. If you want, you can add multiple PI system also.

      Regards,

      Sunil Chandra

      Author's profile photo Former Member
      Former Member

      Hi Sunil,

      I no not see any Excel sheet in the downloads and  i see only XML files

      Author's profile photo Sunil Chandra
      Sunil Chandra
      Blog Post Author

      Try saving the downloaded content with extension .xlsm

      Regards,

      Sunil Chandra

      Author's profile photo Bhavesh Kantilal
      Bhavesh Kantilal

      Hi Sunil,

      Get the below error / info : "the specified xml source does not refer to a schema. excel will create a schema based on the xml source data". Post this, I dont see the data being extracted. Any idea what the reason for this would be?

      Note: I get the same error on both Excel 2010 / 2007.

      Regards,

      Bhavesh

      Author's profile photo Bhavesh Kantilal
      Bhavesh Kantilal

      Sunil,

      My bad. I had a issue on the set up on my end.. The above warning can be ignored!

      Thanks,

      Regards,

      Bhavesh    

      Author's profile photo Former Member
      Former Member

      Hi Sunil,

      does this tool support PI 7.31?

      I put in connection data and got the error: login failed. The user which I used to login has already the role:  SAP_XI_API_DISPLAY_J2EE

      Thanks

      Dingjun

      Author's profile photo Rafael Vieira
      Rafael Vieira

      Hey Dingjun,

      Did you figure if it indeed works good with 7.31?

      What about AEX?

      Tks

      Author's profile photo Former Member
      Former Member

      I am not able to see back search option... Where we can see SID option to select those options....

      Could any one tell me the procedure to open the Filter option to select SID....

      As of now i am able to download Updated Mapping Sheet.... After that i stuck after 5 th step .................

      Author's profile photo Bhavana C
      Bhavana C

      Hello Sunil,

      When i click on SID, i did not get anything to enter details like host,port,user name, password.

      Is there anything wrong with tool ?

      Author's profile photo Ralf Zimmerningkat
      Ralf Zimmerningkat

      Hello Sunil

      Error in working with the excel

      File not found

      ActiveWorkbook.XmlImport url:= _

              Environ$("TEMP") & "\PICCD\template.xml"

      there is no template.xml

      import of cc xml files overwrite all values so that only the last CC is in the workbook

      regards

      ralf

      Author's profile photo Glen Anthony
      Glen Anthony

      Hi Sunil,

      when I use this excel I get an error message 'Web service endpoint URI expected: Not found endpoint with URI /CommunicationChannelService'.

      I get this with your excel and the excel of Iliya and I am not sure why as I have correct authorisation. It seems somehow to build an invalid URL?

      Hope you can help.

      Kind regards.    

      Author's profile photo Peter Wallner
      Peter Wallner

      Hello Sunil,

      A very practical tool - thanks a lot!

      Kind regards, Peter

      Author's profile photo Juan Pascuet
      Juan Pascuet

      Hi Sunil, congrant by the article! Is very clear.

      I have one question, i need to work over XI (PI 7.0) starting with roles assignment, but i dont found the Api_display rol. I search with SUIM trx by rol name but nothing with *API*

      Can you help me with roles?

       

      Tnk

      Author's profile photo Rohan DCosta
      Rohan DCosta

      Hi Sunil,

      When I download click the "search screen" tab it gives me the error as

      "Run-time error '3706': Provider cannot be found. It may not be properly installed."

      Author's profile photo Samala Raghavendra
      Samala Raghavendra

      Hi Sunil,

      I am unable to download the Excel macro file from SOURCEFORGE, could you please assist.
      Thank you in advance.

      Br,
      Ram