Publishing a BEx Query in Enterprise Portal

[Former Member]

Step 1:

A BEx query with technical name ZTESTQ_EP is created as below.

Step 2:

A web template with technical name ZTESTW_EP is created in WAD, selecting the above query ZTESTQ_EP as a data provider.

Step 3:

Logon to your customer’s Enterprise Portal. Click on ‘Content Administration’ tab in the first level tabs. If not automatically selected, then click on ‘Portal Content’ tab in the second level tabs.

Browse through the portal content which is grouped and displayed as folders.Find a folder to create and place your iView. Right click and create a new iView as shown in the below screenshot.

Step 4:

Select an option to create an iView from an existing iView template and click ‘Next’.

Step 5:

Select ‘BEx Web Application iView’ Template based on the version which you are using.

Step 6:

Give a name and a technical ID for the iView which you want to create.

Note: iView Name can be duplicated but iView ID is unique and you can’t create another iView with the same ID.

Master Language option can be selected here based on your language preference.

Step 7:

Write ‘TEMPLATE=YYY’, where YYY= your web template’s technical name.

Note: blank spaces are not allowed in this query string input.

Step 8:

The details of the iView are displayed as below. Click ‘Finish’ to complete the iView creation.

Step 9:

A new workset ‘ZWORKSET_EPDEMO’ is created as shown below.

Step 10:

Add the iView to the workset created. The properties of the workset can be observed in the property editor on the right hand side.

Step 11:

Open an existing role or create a new role (in this example, workset is added to an existing role).In the screenshot below, an existing role ‘Activite’ is opened and some pre-existing worksets can be seen as subfolders to this role and some pre-existing iViews can be seen as sub folders to these worksets.Icons for the role, workset, iView can be seen under ‘Activite’ role/tab.

Step 12:

Add workset to pre-existing role ‘Activite’ as shown in below screenshot.

‘workset for EP Demo’ is added under ‘Activite’ role. ‘IVIEW for EP Demo’ can also be seen under workset.

Step 13:

In the below screenshot, it can be observed that role ‘activite’ is pre-existing under role ‘Pole A’. Hence the created iView and corresponding workset also become part of role ‘Pole A’.

Note: In this example, two pre-existing role levels are considered, where role ‘Pole A’ is an immediate higher level to the role ‘activite’.

Step 14:

Click on first level role ‘Pole A’ on the right hand side top corner. Then select second level role ‘activite’.

All the worksets and report iViews will be displayed on under detailed navigation. Find the iView you created and double click to display the report results.

Save As, variable selection,Export XLS, Filters and Free characteristics options can be used as and when required.