We see a situation where the requests of the BPC Infocube are yellow and we would like to make use of the data further. How to make these requests green so that we can start using the data of the Infocube. a) By switching the Cube to load mode and again to plan Mode, the Infocube requests will turn green, but what is the way to turn the requests to green soon after BPC calculations are done by the data manager package calculations. b) When switching done to load mode and changing back to plan mode , planning users will be affected during the transit, is there a way to handle this.
Even I face the similar issue, the request status remains Yellow, even after data manager package is completed.To ensure that it turns green, I always run LIGHT_OPTIMIZE , post which the request turns to green.
Also any idea, why it is in yellow state, even after the data manager is completed successfully?
If one request is there, how to make it green automatically after doing BPC calculations from the Data Manager package. Is there a way to include some process chain ( even customized approach is fine ) to include in the package link list to run after doing calculations.
Intention is, soon after BPC calculations, if request turns green, the data can be used in other systems.
If one request is yellow you don't have to turn it green to get data out of the cube. Use something like APD based on Query. Query can pick up data from yellow request.
What I am looking for is, as soon as BPC calculations are done after running data manager package, how to close the request automatically so that the request should turn green and the data is used further.
Only when request turns green then only the data can be used further for other systems. The data is extracted every one hour, as the requests are yellow, not able to make use of complete data.
In order to make the request status to green, you need to make a process chain which contain Switch Realtime Cube to Load Mode variant, which located under Other BW Process node.
Whenever the user has finished their activity, you must make the package in BPC to call the process chain containing the variant above. Maybe you would need to chain both Switch Realtime Cube to Load Mode and Switch Realtime Cube to Plan Mode together so the user will always ready to input/change values.
Bluesky
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.