Skip to Content
Former Member
Mar 02, 2015 at 01:11 PM

BEx Query on SPO vs Multiprovider



I have a SPO which partitions data via Calendar Year. The plan is as time goes by i will add extra partitions for the other years and the process chain which is automatically created I would amend to not include years that data would no longer be created for.

Question i have is should i be creating the BEx Query on a multiprovider which uses the generated partitions OR should i be creating the BEx query on the SPO?

At the moment I am only using the SPO as a way to automatically create the partitions.