recomendation of parallel processing in Infoset? URGENT>>>

[Former Member]

<b>Hi Gurus,

Why parallel processing is not recommened for Infoset compared to Muliti provider? And what is the best process, whether to go for Infoset or Multiprovider ?

Thanks in Advance,

Sam.</b>

[Former Member]

Hi Hussain,

<b>MultiProviders</b> only exist as a logical definition. The data continues to be stored in the InfoProviders on which the MultiProvider is based.

A MultiProvider can consist of different combinations of the following InfoProviders: InfoCube, DataStore object, InfoObject, InfoSet, VirtualProvider, and aggregation level.

The reason for parallel processing not been recommended for infoset compared to multiprovider is :

A query based on a MultiProvider is divided internally into subqueries. There is a subquery for each InfoProvider included in the MultiProvider. These subqueries are usually processed in parallel.

Where as <b>Infosets</b> are entirely for the different purpose and they are structured appropriately for that. Especially for join operations like temporal join we go for infosets.

So, with Infosets parallel processing will only degrade the performance as there will be many complexities invloved.

Hope this solves your concern.

Regards,

Habeeb

[Former Member]

Mulla,

Both Multi provider and Infoset are used for different purposes.

Multiprovider:

A MultiProvider is a type of InfoProvider that combines data from a number of InfoProviders and makes it available for analysis purposes. The MultiProvider itself does not contain any data. Its data comes entirely from the InfoProviders on which it is based. These InfoProviders are connected to one another by a union operation.

Infoset:

Description of a specific kind of InfoProvider: InfoSet describes data sources that are defined as a rule as joins of DataStore objects, standard InfoCubes and/or InfoObjects (characteristics with master data). If one of the InfoObjects contained in the join is a time-dependent characteristic, the join is a time-dependent or temporal join.

An InfoSet is a semantic layer over the data sources.

For more information Please go thru the link below:

http://help.sap.com/saphelp_nw04s/helpdata/en/4d/c3cd3a9ac2cc6ce10000000a114084/frameset.htm

http://help.sap.com/saphelp_nw04s/helpdata/en/4d/c3cd3a9ac2cc6ce10000000a114084/frameset.htm

Hope this helps...

Thanks,

Gattu