After upgrade of Web UI (WCC) r12 to r12 SP1 the following is noticed in the WCC Dashboard in the "Connection Status" widget that "Reporting database" isn't connected.
Also noticed that there is no tab "Reporting".
Release : 12.0
Component : WORKLOAD CONTROL CENTER
The Reporting option can be enabled/disabled in the Reporting preferences section in the Configuration tab.
If the Reporting option is disabled, you cannot see the Reporting tab and also the "Connection status" wizard of the Web UI Dashboard does not show the Reporting database entry.
Reporting collection and cleanup will not start.
To enable or disable Reporting, use the following command syntax:
Windows:
cd %CA_WCC_INSTALL_LOCATION%\bin
wcc_config.bat -u ejmcommander -p ejmcommander -enablereporting true
Linux/Unix
cd $CA_WCC_INSTALL_LOCATION/bin
./wcc_config.sh -u ejmcommander -p ejmcommander -enablereporting true
After executing the command, it will indicate that you will need to stop/start WCC services and Collector.
More information can be found on wcc_config utility here