INFOSET

Infoset:

1       Actually Infoset works on the rule of join on DataStore objects, standard InfoCubes (Max 2 InfoCubes only we can use that to as Left Operand) and/or InfoObjects (characteristics with master data).

2       Sometimes we come across the scenarios where we have to build a report on two/more different data targets. In this case we can use Infosets which joins two/more data targets, and we can build Query on Infoset, which gets data from tables of Infoproviders.

      Do’s and Don’ts for InfoSets

•        Do not use more than 10 InfoProviders in one InfoSet. It is better to create multiple InfoSets depending on reporting needs.
•        Do not use more than 10 joins in one InfoSet (especially if you expect high a data volume).
•       InfoSet queries can be used for DataStore objects without the activated BEx Reporting indicator.
•      Do not use calculations before aggregation on InfoSet because this may lead to wrong query results.
•        If there are InfoSets with time-dependent master data, do not restrict the data by the fields Valid from (0DATEFROM) and Valid to (0DATETO).