bw question

[Former Member]

what is the diference between infoset,and multprovider

[Former Member]

if any one have idea what kind of question in interview are asked in Accenture pls help me with that if any one can

thanks

[former_member193376]

Hi

INFOSETS

SAP Query allows you to evaluate data in the SAP system. But since the SAP system contains several hundred thousand fields in logical databases, tables and sequential datasets, it is simply not practical to offer all these fields for selection when creating queries. Therefore, before starting to create queries (using the component Maintain Queries), you create InfoSets (using the component Maintain InfoSets). Functional areas provide the user with a framework for defining a query quickly and without difficulty.

When you create an InfoSet, you select a logical database from an application system. However, since one logical database can still contain a very large number of fields, you combine fields together in logical units known as field groups.

An InfoSet not only allows you to restrict the number of fields and group them together in meaningful units, but also to define auxiliary fields and then process them like database fields. You can also read the long texts in additional tables (for example the long text of an airline carrier in the table SCARR) and perform any necessary preliminary work. This means that you can evaluate sequential data sets just as easily as SAP databases. For further information

MULTIPROVIDERS

A MultiProvider is a type of InfoProvider that combines data from a number of InfoProviders and makes it available for reporting purposes. The MultiProvider does not itself 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.

InfoProviders and MultiProviders are the objects or views that are relevant for reporting.

Use

A MultiProvider allows you to run reports using several InfoProviders.

InfoCube and InfoCube: You have an InfoProvider with actual data for a logically closed business area and an equivalent InfoProvider with planned data. You can combine the two InfoProviders into one MultiProvider so that you can compare the actual data with the planned data in a query. In BW releases 2.0B/2.1C, this combination of two InfoCubes is still called a MultiCube.

InfoCube and InfoObject: You have an InfoCube with your products and sales. You combine this InfoCube with the 0MATERIAL InfoObject. This allows you to display any "slow-moving items", since products that do not result in sales are also displayed. For a detailed description of the procedure,

ALSO...

multiproviders and info sets are logical you are not storing any data there, if you get any errors it will be at info provider level, if you got any error at reporting level which are based on multiproviders or info sets then you have to check your design of them and take necessary actions to correct them

Thanks

Saiyog

Reward points if useful.

[Former Member]

Hi,

Plz don't mind but you have posted this question in wrong forum,

I know very littel about BW, so plz see if belowinformation could help you much

Infosets

InfoSet are defined 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.

http://help.sap.com/saphelp_nw04s/helpdata/en/ad/2225391d4f000be10000000a114084/frameset.htm

MultiProvider

The term MultiCube goes with the older BW version (2x) as only InfoCubes could be combined to created a "multicube" object. Now in the 3x versions, MultiProvider is used as ODS and InfoObjects can also be used to create a "multi-" object.

MultiProvider is a special InfoProvider which combine data from several InfoProviders for its own reporting, without actually holding any physical data itself (i.e. its data comes exclusively from the InfoProviders on which it is based), then, it can only use an InfoProvider that is ready and available for reporting, in which case, the Transactional ODS object is not one of them. Therefore, to include a Transactional ODS object in a MultiProvider, you would have to first define an Infoset for the Transactional ODS object.

A MultiProvider can be made of of various combinations of the following InfoProviders:

1. InfoCubes

2. ODS Objects (Standard only)

3. InfoObjects

4. InfoSets

http://help.sap.com/saphelp_nw04/helpdata/en/52/1ddc37a3f57a07e10000009b38f889/content.htm

Thanks

Swarup

[Former Member]

Hi,

Reddy this is the XI forms, so please don't post the other technology questions, post only the XI questions.

Otherwise the moderator will delete you from the SDN.