The following steps are needed to configure EP for connecting to BW
Creating System Object
Creating Folder, Role, Workset, Page and iview
Attaching iview to page, page to workset, workset to Role
Assigning Role to the User
In the Enterprise portal you have to create the system object for connecting to BW system. Log on to Enterprise Portal using Fully qualified domain name using system admin id.
Creating System Object
Go to system Administration --> system configuration --> system landscape.
Expand the folder portal_content. Right click on the portal_content folder and choose new --> system. Select the template which matches with your BW system and choose save.
Right click the system object created and choose edit. In the drop down box select connector properties. Enter the BW details here like application host, server port, etc. and choose save.In the system object you have to give the BW system details in the connector property.
Now select WAS property from the drop down list. Give details of your WAS server and save. The WAS server details should follow the fully qualified domain name
Now choose user mapping from the drop down list and select the logon method you need and select user,admin from the drop down box and save.
Again right click the system object and choose system alias. Give your logical system name and set it as default and save. Also create another system alais SAP_BW and set it as default and save
Right click the system object and choose connection test. Select the check box you need to test and test the connection
Creating Folder, Roles, Workset, Pages and iviews
First create role, workset, page and iviews.
Go to Content Administration --> Portal content
Expand the folder Portal_content
Right click the portal_content folder and choose create folder. Enter the required details and save
Right click the created folder and choose create Role. Enter the required details and save
Right click the created folder and choose create Workset. Enter the required details and save
Right click the created folder and choose create Page. Choose the template required. Select the no of column template and enter the required details and save
Right click the created folder and choose create iview. Choose the template BW Report ivew or SAP Transaction iview. Enter the required details like query string or BW Transaction code and select the BW system you need to connect to from the drop down list and save. Now iview is created. Right click the iview and choose preview. The iview is executed and the BW query or transaction is displayed.
Attaching iview to page, page to workset, workset to Role
Now right click the page you created and choose edit. With this screen in edit mode, right click the iview you have created and choose add iview to page and save and close the window. Now iview is attached to page.
Now right click the role and choose edit. With the role in edit mode, now right click the workset you have created and choose add workset to role. Now workset is attached to role
Now in the right hand side window in the context area, highlight the workset, Then right click the page you have created and choose add page to workset.
Now you have assigned iview to page, page to workset, workset to role.
Now right click the role you have created and choose edit properties. In the property "Entry Points" select Yes. Only then the role will be visible in the portal
Now assign the role to the user
For this go to user administration --> role.
Enter the user and from the drop down box select user and search. Then choose the edit link and next screen is opened. enter the role and search. Select the add role button. The role gets added then click the save button. Now Role is attached to the user
Now login to portal (using Fully qualified domain name) using the portal user id and the roles will be displayed. Iview is displayed fetching the data from BW system
