SAP BW - Data is not available for reporting in InfoCube though the request is completed

First of all, Unless and until it is really required; It is always better to keep the DTP setting to "Set Overall Status Automatically"

You need to set the status manually if the setting is "Set overall status manually"

If the DTP setting is set to manually, In this cass, After the request is completed the load in InfoCube it will show status in yellow color.

In such cases, You have to manually change the status to completed (green color).

While changing the status manually, You need to follow the sequence if there are more than one request.

You need to change from the bottom to top approach, You need to change for the request which is loaded to infocube first.