Custom report in rtc. Empty tables in snapshot schemas
hi,
i m trying to create the custom reports in rtc. but tables in the available snapshot schema (WORKITEM_SNAPSHOT, SCM_SNAPSHOT etc. ) dont contain any data.
I setup the rtc using db2 as database and i double checked the tables using DB2 Control Center and verify that all these tables are empty
how can i populate these tables???
Regards,
Qaiser
i m trying to create the custom reports in rtc. but tables in the available snapshot schema (WORKITEM_SNAPSHOT, SCM_SNAPSHOT etc. ) dont contain any data.
I setup the rtc using db2 as database and i double checked the tables using DB2 Control Center and verify that all these tables are empty
how can i populate these tables???
Regards,
Qaiser
3 answers
The data warehouse data collection tasks run every midnight. You need to wait until the next day to see data in those tables.
The SCM_SNAPSHOT needs to be configured by selecting which streams to collect data for. This can be done through the reports Web UI. Click the link "Administer SCM Snapshot"
The SCM_SNAPSHOT needs to be configured by selecting which streams to collect data for. This can be done through the reports Web UI. Click the link "Administer SCM Snapshot"
The data warehouse data collection tasks run every midnight. You need to wait until the next day to see data in those tables.
The SCM_SNAPSHOT needs to be configured by selecting which streams to collect data for. This can be done through the reports Web UI. Click the link "Administer SCM Snapshot"
is there any way to run these task manually??
The data warehouse data collection tasks run every midnight. You need to wait until the next day to see data in those tables.
The SCM_SNAPSHOT needs to be configured by selecting which streams to collect data for. This can be done through the reports Web UI. Click the link "Administer SCM Snapshot"
thanks, i found the link to update all snapshots from web ui. thanks again for help