We have been trying to replace one of our InfoCubes with an SPO to improve performance of BW queries. SPO is partitioned by OCALYEAR and both InfoCube and SPO are further connected up to a Multiprovider and queries are built on the Multiprovider.
However, queries run on the SPO seem to take considerably longer to run than those based on the InfoCube, although the dataset is exactly the same. This goes against any theory that we have been reading about with respect to SPOs so we must be doing something wrong, surely?
Is there a trick that we are missing?