Query performance on Multiprovider

[Former Member]

Guys,

Does it make any sense to create a Multiprovider on single InfoCube in reporting perspective?

I know Multiprovider is used when we need to fetch data from Multiple infocubes,

Suppose a multiprovider is created on a single Cube & a report is built on that multiprovider.

Does the report performance is more on Multiprovider than that of built on Infocube?

Thanks Guys,

[Former Member]

Hi,

Does the report performance is more on Multiprovider than that of built on Infocube?

--> is not better...

It always make sence to create a MP based on single InfoCube for a query because you are much flexible then. If you will receive new reporting requirements you have not to design a new query.

Regards

Andreas