BI Publisher Notes

Create data source

1. Administration on the top right corner0
2. JDBC > Add datasource

Create data model

1. Create data model
2. tab diagram > new > sql query > enter name, sql and select datasource > OK
3. tab data > view > save as sample data
4. save on the top right corner

Create report

1. create report
2. select data model, if the data model does not contain sample data, error message returns, you cannot proceed
3. keep pressing next
4. edit report
5. you can drag "layout grid", "text item", field name of data set, etc, to the report
6. save on the top right corner
7. click "return" button to exit
8. view report
9. click the menu button on the top right corner > export > interactive
10. new window opens
11. append "&id=<username>&passwd=<password>" to the link and copy
12. i.e. http://<host>:9704/xmlpserver/viewer.jsp?_xpf=&_xpt=1&_xdo=%2F%7Ebi_opr01%2FDrafts%2Ftest+report+1.xdo&_xmode=&_xt=test+report+1&_xf=analyze&_xana=view&id=chantaiman&passwd=23456789

Grant permission to other report users

1. Click "catalog" on the top right corner
2. Select a report > More > Permissions
3. Click the boxes > click OK
4. Wait until the changes become effective