VC and SAP Query

[Former Member]

<u><b>System Landscape</b></u>

NW Sneak Preview Java Edition with EP 6.0 (from SDN)

VC 6.0, Patch 5

R/3 Enterprise 4.7 extension set 200 (WAS 6.20)

<u><b>Scenario</b></u>

Utilize the BI Kit in VC and use SAP Query from a backend R/3 system to generate VC content.

<i>(From what I have understood, the BI Kit does not necessarily need BW and can work with a R/3 source)</i>

<u><b>Questions</b></u>

(a) Is the assumption correct that the BI Kit can use the SAP Query as a backend to generate content in VC (without a BW system in the landscape)?

(b) Do I need to install the BI UDI SP stack with the EP in NetWeaver Sneak Preview ?

(c) What type of systems do I need in the EP ? If I try the "New System" wizard, I do not get an option to connect to a "BI" system. nevertheless, if i try "new from PAR", i have a an option to use "com.sap.portal.systems.BIUDI". Can you help me with the parameters for a PAR - "com.sap.portal.systems.BIUDI" ?

any other tips / experiences of working with SAP Query and VC are most welcome.

Regards, Parag.

Note: I have tried a R/3 system connection and the RFCs are visible in VC

[Former Member · Accepted solution]

a) yes

b)&c) Look at the documents that come up with the keywords "BI Kit VC" in the SDN Library, for example this one: https://www.sdn.sap.com/irj/servlet/prt/portal/prtroot/com.sap.km.cm.docs/library/events/bw-and-port... coding required-develop portal applications with the sap visual composer and the visual composer bi kit.pdf

This one contains a lot of further information.

Mario

[Former Member · Accepted solution]

Thanks Mario.

I ran thru the document and it mentions the following

- Slide 9: "For VC BI Kit: Deploy BI UDI SP Stack 05 to the J2EE Engine of the Portal"

- Slide 10: "Requirements for SAP ERP System- Nothing special as long as it can be attached to the portal

(see note 655941 for details)"

Now, I think (it would be great if you can confirm or let me know how to do this), the NW Sneak Preview from SDN has this BI UDI stack.

As far as Slide 10 info goes, it points to a note that talks about installing EP Plug-in. Is this plug-in mandatory ? I have been able to create a connection from EP to R/3 without the plug in (tested a transaction iview and the RFCs are also visible in VC).

So, what am i missing in terms of installation ?

If the installation is allright, can you help with the parameters in setting up a "SAP_Query" system so that this can be used as "data services" to retrieve queries ?

Thanks for all the help.

Regards, Parag.

[Former Member · Accepted solution]

A detailed descritpion can be found here:

https://websmp206.sap-ag.de/nw04installation and then go into SAP VC and look at the Installation Guide at section 2.2. It contains a precise desciption, what you have to do.

Servus

Mario

[Former Member · Accepted solution]

Actually the original link is: http://service.sap.com/nw04installation

[Former Member · Accepted solution]

And while we are on it (and thanks to Moya Watson who pointed me to the documents), this also might be helpful:

installation guide:

http://service.sap.com/nw04installation -->

SAP VC --> Installation Guide - SAP NetWeaver Visual Composer 6.0

specifically, section 2.2: "NetWeaver '04"

user guide, starting with "Creating BI Queries":

http://help.sap.com/saphelp_nw04/helpdata/en/d7/521c29bea645b8ab299c1c4e9fc2be/frameset.htm

via path -

http://help.sap.com --> Documentation --> SAP NetWeaver --> {language...} --> Application Platform --> SAP NetWeaver Visual Composer: User Guide --> Creating Portal Content --> Building an iView --> Defining Data Services --> Creating BI Queries

and the best and most complete source of documentation for Visual Composer is on SDN:

https://www.sdn.sap.com/sdn/visualcomposer.sdn?

(you get to this page from the Quick Links list at the right of the entry page . . .).

[Former Member · Accepted solution]

Thanks a ton Mario, your hints helped me in arriving at the configuration.

For the sake of completeness, I am listing the steps that led me to a successful config.

1. Download the BW 3.5 SR1 installation guide from service marketplace

2. Goto section 6 and perform the steps highlighted for BI Query Connector. Note that if you dont assign a value for the parameter "SERVERGROUP", the default is PUBLIC. So if you have a server with only SPACE (like I had), please do enter "SPACE" for this property.

3. Edit the services file on the Windows Server and add an entry for your SAP server. For example, my server SID is DEV, hence I inserted the following entry in the service file: sapmsDEV 3600/tcp

This step is necessary for JCo to work.

4. Stop and Re-start the BI Query service (using the Visual Administrator)

5. Test the connection with the following URL - http://<host>:<port>/TSapq/servlet/TestSapq

This should list you the queries in the SAP system

6. Open EP (I logged in as admin) and add the system as described in Step 4, section 2.2 of the VC installation guide.

7. Add permission for "everyone" group to this system

8. Login to EP with another userid, perform user mapping (personalize option)

9. Start VC storyboard, login to EP with the other userid (not admin), use Data Service or BI Query Wizard to retreive the queries.

Why did I have to use another userid ?

Well, this was because the connection test did not work for me with the admin user, nor was I able to retrieve the queries in VC. Dont know why this didnt work.

Message was edited by: Parag Jain