As we all know, we have to be very careful with APO BW structure, mainly when we are transporting them across the APO landscape.
We have seen that lot of time, APO BW structures get inactive on subsequent system when some transport in area APO BW area is sent.
It´s difficult to find out the root cause of such issues. As the APO BW objects are inactive all subsequent important data flows get impacted heavily.
You have option to go again back to development system and transport the changes across the landscape to activate.
But you could also directly activate them in the respective system without transport request. We have few SAP standard reports which could make your life easier. I have collected them over the period of time and thought of sharing with you all.
RSDG_IOBJ_ACTIVATE Activation of InfoObject (without automatic transport connection)
RSDG_CUBE_ACTIVATE Activation of Info Cubes
RSDG_MPRO_ACTIVATE Activating Multiprovider
RSDG_ODSO_ACTIVATE Activating/Repairing Data Store Objects (Without Automatic Transport Connection)
RS_TRANSTRU_ACTIVATE_ALL Activate all active transfer structures for a source system
RSDS_DATASOURCE_ACTIVATE_ALL Activate All DataSources of a Log System
RS_COMSTRU_ACTIVATE_ALL Activate all inactive communication structures
RSAU_UPDR_REACTIVATE_ALL Activate all inactive update rules
Transformation and DTPs:
RSDG_TRFN_ACTIVATE Activate transformation with DTPs
I hope this information would be also helpful to you.