We have a FOX formula in BPS that executes a distribution between cost centers, according to some premises entered by users. We use a multiarea with 2 transactional cubes and always execute this function in background.
We are trying to execute this formula in productive system but sometimes this works well and sometimes it doesn´t work (it seems that the function get stuck in a sequential read of the cubes). In the development system, this woks very well.
The package and the function are equal in the two systems.
Sometimes, we are having problems to acess a cube in LISTCUBE transaction. It takes a long time to execute in productive system (with the same selection in the development system). These two problems can be related ???