Customize BI Reports Logo
The report wizard allows you to put a logo on your generated reports. The file it uses is stored in two places:
• <tomcat_dir>\webapps\qadbi\images\logo.gif - used for standard HTML reports.
• <tomcat_dir>\webapps\qadbi\WEB-INF\classes\images\logo.gif - used for PDF and Excel exports of reports.
If you want to have your company logo print on reports, replace the default logo.gif in the Web application’s images subdirectories with a GIF file of your logo. The logo file can be different for the two classes of report types.
Restart Apache Tomcat through the Services window.
Note on Password Encryption in the BI Portal
You can encrypt the SQL Server password in both the server-config.xml file, which contains the connection information for the BI Portal database, and the aw_sys_config table, which contains the connection information for the BI Data Warehouse. The encryption uses the Blowfish algorithm.
A command-line tool to encrypt the password named encpwd.bat is located in TOMCAT_HOME\webapps\your_bi_appname\cmdline. To run this, open a DOS window, change to the cmdline directory, and run:
encpwd.bat mypassword
The encrypted password is printed on the screen. Copy this value and use it in the server-config.xml file as the value for the pwd. Also make sure that pwdEncrypted=true. If you change back to using an unencrypted password value, make sure that you set pwdEncrypted=false.
Similarly, if you want to encrypt the password the Portal uses to connect to the Data Warehouse, use the encpwd.bat script to generate the encrypted password. Edit the value for the jdbcPassword in the aw_sys_config table in the DATASERVICE row and then set it to the encrypted value. Make sure that you add pwdEncrypted=true.
If you change either password, stop and restart Tomcat for the change to take effect.