2017年11月15日 星期三

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


沒有留言:

張貼留言