Skip to Content
Former Member
Apr 27, 2015 at 09:56 AM

SPO vs InfoCube - why is SPO less efficient?


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?