8/9/2019 First BIP Report
1/16
Learn hyperion by Amit Sharma learnhyperion.wordpress.com mail [email protected] for Hyperion/OBIEE Training
Learn Hyperion/OBIEE by Amit Sharma [email protected]
Creating First
Oracle Business Intelligence
BI Publisher Report
Amit SharmaOBIEE/[email protected]/Consultant
8/9/2019 First BIP Report
2/16
Learn hyperion by Amit Sharma learnhyperion.wordpress.com mail [email protected] for Hyperion/OBIEE Training
Learn Hyperion/OBIEE by Amit Sharma [email protected]
Creating my first BI Publisher Report
Today lets create our first BI Publisher report. Im going to demonstrate you the step by step approach to create a first BIPublisher report.
Step#1: Open the BI Publisher report as given below.
Step#2: Enter the username default is UserName: Administrator and password is Administrator
8/9/2019 First BIP Report
3/16
Learn hyperion by Amit Sharma learnhyperion.wordpress.com mail [email protected] for Hyperion/OBIEE Training
Learn Hyperion/OBIEE by Amit Sharma [email protected]
Step#3. The below screen appears once you login into the BIP report. This consists of Shared Foldersand MyFolder(Private folder) . There is a folder named Usersstores each folder for all the users who have access to BIP.
Step#4 Now well create a new report. Click on Create a new reportlink in Folder and Report Tasks
8/9/2019 First BIP Report
4/16
Learn hyperion by Amit Sharma learnhyperion.wordpress.com mail [email protected] for Hyperion/OBIEE Training
Learn Hyperion/OBIEE by Amit Sharma [email protected]
Step#5 : Enter Report Name : Order_Placed
Step#6 Rename the report with Oder_Placedto Order_Placed
Step#7 Clicked on Editand modify the BIP report
8/9/2019 First BIP Report
5/16
Learn hyperion by Amit Sharma learnhyperion.wordpress.com mail [email protected] for Hyperion/OBIEE Training
Learn Hyperion/OBIEE by Amit Sharma [email protected]
Step#8 First of all we need to create a Data Model. And specify the Data Source.
Step#9 The below screen shows the new Database connection parameters. In General Settingtab we need to specify theNameand Type of Data Source.
8/9/2019 First BIP Report
6/16
Learn hyperion by Amit Sharma learnhyperion.wordpress.com mail [email protected] for Hyperion/OBIEE Training
Learn Hyperion/OBIEE by Amit Sharma [email protected]
These are the different data type can be selected
Select the existing Data Source or create a new Data Source.
Step#10 : Click on Query Builder to build the query.
8/9/2019 First BIP Report
7/16
Learn hyperion by Amit Sharma learnhyperion.wordpress.com mail [email protected] for Hyperion/OBIEE Training
Learn Hyperion/OBIEE by Amit Sharma [email protected]
Step#11: On clicking Query Builderyou find the Presentation Catalog Presentation Tables and Columns are visible.
8/9/2019 First BIP Report
8/16
8/9/2019 First BIP Report
9/16
Learn hyperion by Amit Sharma learnhyperion.wordpress.com mail [email protected] for Hyperion/OBIEE Training
Learn Hyperion/OBIEE by Amit Sharma [email protected]
Step#14 : Specify the Username Administrator and Password: Administrator.
Step#15 Select the file Order_Placedfiled saved in Shared Folders.
8/9/2019 First BIP Report
10/16
Learn hyperion by Amit Sharma learnhyperion.wordpress.com mail [email protected] for Hyperion/OBIEE Training
Learn Hyperion/OBIEE by Amit Sharma [email protected]
Step#16 Export the XML file so that it could be used as Sample Data while generating the Report in MS Word.
Step17 The XML file we saved in previous step.
Step#18 Now we can display report in tabular format or any predefine Template format given by your client.a) Displaying report in Tabular format by using Table WIzard.
8/9/2019 First BIP Report
11/16
Learn hyperion by Amit Sharma learnhyperion.wordpress.com mail [email protected] for Hyperion/OBIEE Training
Learn Hyperion/OBIEE by Amit Sharma [email protected]
a)
b)
8/9/2019 First BIP Report
12/16
Learn hyperion by Amit Sharma learnhyperion.wordpress.com mail [email protected] for Hyperion/OBIEE Training
Learn Hyperion/OBIEE by Amit Sharma [email protected]
c)
d)
e)
8/9/2019 First BIP Report
13/16
Learn hyperion by Amit Sharma learnhyperion.wordpress.com mail [email protected] for Hyperion/OBIEE Training
Learn Hyperion/OBIEE by Amit Sharma [email protected]
f)
Step#19 Now on clicking on any tag shaded with gray color you find the definition of the tab.
8/9/2019 First BIP Report
14/16
Learn hyperion by Amit Sharma learnhyperion.wordpress.com mail [email protected] for Hyperion/OBIEE Training
Learn Hyperion/OBIEE by Amit Sharma [email protected]
Step 20 : Save the file with .rtf extension and thenpreview the output in any given format.
8/9/2019 First BIP Report
15/16
Learn hyperion by Amit Sharma learnhyperion.wordpress.com mail [email protected] for Hyperion/OBIEE Training
Learn Hyperion/OBIEE by Amit Sharma [email protected]
Step 21 The Report Output is
Step 22 : Now display the report in predefine format.
8/9/2019 First BIP Report
16/16
Learn hyperion by Amit Sharma learnhyperion.wordpress.com mail [email protected] for Hyperion/OBIEE Training
Learn Hyperion/OBIEE by Amit Sharma [email protected]
Step23 Double Click the Row elements and placed in the given template empty fields.
Step 24 Now save the template and review the report.