[Oracle BI] Forgot password

Assume weblogic server is installed.....

cat /product/fmw/BI/user_projects/domains/BIDomain/servers/bi_server1/security/boot.properties

password={AES}.................................................................=

username={AES}rvEVZgs/uEWN8WC6M4EgTwEq/o6f/X1unADuTFNgx/s\=

cd /product/fmw/11g/oracle_common/common/bin

./wlst.sh

wls:/offline>domain = "/product/fmw/BI/user_projects/domains/BIDomain"

wls:/offline>service = weblogic.security.internal.SerializedSystemIni.getEncryptionService(domain)

wls:/offline>encryption = weblogic.security.internal.encryption.ClearOrEncryptedService(service)

wls:/offline>print "Weblogic server Admin password: %s" %encryption.decrypt("{AES}....................y3w7o=")

:-D

樓下華潤LAST DAY

樓下華潤超市即將結業﹗

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