Question:
Hello,
I need help on reloading failed requests from ODS to cube. The data went into the ODS ok. But failed when trying to update cube from ODS. This was due to datasource replication issue. I have replicated the data source 8*.
I have two failed requests in the cube. The latest one has status yellow and the old one has status red. I have the two corresponding requests in the ODS. They both have status of green, but they do not have the check mark on the datamart status field.
Thanks very much for your help in advance!
Answer:
Hello,
I need help on reloading failed requests from ODS to cube. The data went into the ODS ok. But failed when trying to update cube from ODS. This was due to datasource replication issue. I have replicated the data source 8*.
I have two failed requests in the cube. The latest one has status yellow and the old one has status red. I have the two corresponding requests in the ODS. They both have status of green, but they do not have the check mark on the datamart status field.
Thanks very much for your help in advance!
Hello
Delete the 2 Red requests from the cube first.
in ODS goto DATAMART status of the request
Reset the Delta for the 2 requests which went to CUBE(Hit Delete button)
PS-Make sure u reset for only those 2 red requests of the cube
u r ready to send those 2 requests as Delta again to the cube.
Hope it Helps
_________________
Chetan
@ CP...