topic Can SAP Connector read multiproviders in QlikView

Can SAP Connector read multiproviders

Fri, 12 Mar 2010 20:14:34 GMT

I am new to QV using 8.5. I have inherited QV reporting for a new SAP installation and was asked by our BW consultant if the connector can access multiproviders. Not sure what they are

Any insight?

Thanks

Can SAP Connector read multiproviders

Thu, 02 Jun 2011 05:43:20 GMT

Moelkers,

It has been so long since you posted this. but I am stuck in same issue right now. did you find any solution how to do that??

Regards

Can SAP Connector read multiproviders

Ian_Crosland — Thu, 02 Jun 2011 11:36:12 GMT

A multiprovider within BW is a special type of Infoprovider which can contain data from several BW sources for example combining 2 separate cubes or combining multiple ODS objects. QlikView can pull data from these via a couple of routes:

Build a BeX query on the multiprovider and use the OLAP connector to link to this (depending on data volumes)
Determine the underlying logic of what is contained in the multiprovider and use the SQL connector to pull the base tables, for example a multiprovider may pull data from a sales and accounting cube, so we could use the SQL connector to pull the required fact/master data tables. For large volume cubes this will be the most performant approach

Ian

Can SAP Connector read multiproviders

suniljain — Fri, 03 Jun 2011 07:23:51 GMT

Its tough OR Not Possible to Build a BeX query on the multiprovider and use the OLAP connector to link to this (depending on data volumes)

Pls Try.