OBIEE: First BI Publisher Report

Learn Hyperion and OBIEE

Amit Sharma

Hello All,
Today we’ll devel our first BI Answer Request and convert it into BI Publisher. This guide will give you step by step to create Answer request, process request, conver it to BI Publisher and finally integrate it to Dashboard

Step #1 Loging it to BI Answer to create out first Answer Request.
URL: analytics/saw.dll?/analytics/saw.dll?Answers&SubjectArea=%22Sample%20Sales%22">>analytics/saw.dll?/analytics/saw.dll?Answers&SubjectArea=%22Sample%20Sales%22">http://>analytics/saw.dll?/analytics/saw.dll?Answers&SubjectArea=%22Sample%20Sales%22

Step #2 Once you login to the Server, you can see the list of Subject Areas. Select the subject to start building the first Answer Request. In our case I have taken sample sales.

Step#3 Select the dimension members and facts from Sample Sales Subject Area. You can find the selected Dimension members appear in Columns sections.

Step#4 Once you select all dimensions and filters. The screen may look like this.In the given below screenshot I haven’t selected any filter so the Filters section is empty. However you could select one by Ctrl+Select to place the filter in screen. Click the view button to view how does your request output look like. Save the below Answer Reques. I have given as Report16_V1 name.

Step# 5 . In the below screen I have selected[Ctrl+Select] Customer Name as Filter so it opens Create/Edit Filter Dialog box.Here we can specify the Customer name as default filter.

Step#6 Answer Query processed output

Step#7 Your Answer Request is ready now. We are going to convert it to BI Publisher. Open MS Word and Click on Oracle BI Publisher Log On Screen. Same as given in below screen.

Step#8 Once your user and password get authenticated, you can see the below screen. Select Oracle BI from Workspace Dropdown and select your BI Answer Request you created.