The following are the steps to create BIP report:
Data Model: Data Model is the source of data, where the developer can write the code as per requirement.
Report: Report is the representation layer where the developer has to attach the templates ( RTF, E-Text, Excel, XSLT, etc.). The report needs to be linked with Data Model to extract data.
Navigate to Tools ==> Reports and Analytics
Click on Browse Catalog, a new window will open.
Click on Create ==> Data Model
Click on + symbol as shown below and choose based on your source query. Here as per my requirement I chosen SQL query.
Enter Query into the dialogue box opened and click on OK button. We can even verify cost of the query using Generate Explain Plan. Save the Data Model.
Click on Data tab, we can view the data from here. Click Save as Sample Data button and it will save the resulted information as XML data for reporting purpose. Click on Export Data, it will generate XML data and a XML file will be downloaded.
To design the template, we can do it through RTF, Excel, XSL etc. As per our requirement, we chosen RTF template.
Open a Word document, save the blank file as .rtf extension. We must have installed already BI Publisher plug-in to be able to load XML data into RTF file for design purpose.
Click on BIP Plugin option, click on Sample XML and import data.
Click on Table Wizard, choose fields and click on Finish. Now, our RTF is ready.
Now, we will navigate to Fusion Applications, BIP Console and browse the Data Model created. Click on Create Report button and Use Report Editor option to upload RTF that we created.
Click on Finish button from Report Editor screen. Now, click on upload RTF. Enter template language, choose RTF file, select the file type as RTF and click on upload.
As soon as the file is uploaded, we can now see the data in the format that we designed.
No comments:
Post a Comment