To Access BI Publisher ,please use the below link
http://localhost:9704/xmlpserver/ -Without SSL
https://localhost:9804/xmlpserver/
-With SSL
Login with Admin User
Credentials
After Login
Click Administration tab on the Top Right hand Corner to
Configure Administration Activities
Click the Connection type in the Data Sources:
We Can Connect the Same for the SOA Schema.
Here we got two Connections, one for OIM Schema and other for SOA Schema.
To Create Data Model:
On the Catalog Page on the Left Pane Click New to See Data Model.
We are Using SQL Query to Create the Data Model.
For Example:
I am using oim_ProdReporting(OIM Data Source) to pull the users list ,columns needed
userlogin ,firstname ,lastname hiredate.
Click Ok and then
Click ViewData and Click view and do
save the Sample Data to generate Sample XML.
Create a Report for the data model .By Clicking on the Top
Right hand side.
Click Next and select the Respective Options for the Report
template.
Click Next
Drag and drop on to the Right hand empty space for the
Required columns for the Report.
Click Next
And click finish and save the report name to view Report.
Report
We can add the new layout
for the report by clicking on the top right hand top corner button.
Click Edit button to
format the report
To change font size
,data formatting highlight the table grid.
To Change Date format, highlight date Column and format the
date accordingly
After changes done ,click save and return to view the Report.
View Report
To schedule the Report ,click action and click Schedule
Click output tab,to configure email addresses of the User.
Click schedule tab to set the
Frequency of the Report to generate.
Click submit button and specify the report job name.
No comments:
Post a Comment