If after your configure the Business Intelligence reports, you do not see any data in the reports in the WebSphere Commerce Accelerator, you may have one of the following problems:
- WebSphere Commerce Analyzer has not analyzed any data. Check the FACT_ tables in the data mart to see if there is data. If there is no data, make sure replication and ETL have completed successfully and that there is data to analyze in the WebSphere Commerce database. Try to run the report SQL directly against the data mart from a DB2 Command Prompt. If data is returned, there is a problem with the WebSphere Application Server dataSource setup. If no data is returned, then WebSphere Commerce Analyzer does not have any data to report. Try re-running WebSphere Commerce Analyzer and make sure there is data in the Commerce database to analyze.
- WebSphere Commerce Analyzer did not complete ETL processing, possibly due to some error. Check the error log for details. The last step in ETL, End_ETL, should have run successfully.
- You do not have a connection with the data mart. Check that you have created a connection to the data mart database from the WebSphere Commerce machine.