Skip to Content

Self Loop in SAP BI

Hi All,

Can you plese provide me some scenarios on Self loop in DSO and Info cubes. In real time, when we have use this concept.

Thanks.

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • Best Answer
    May 27, 2013 at 10:25 AM

    Hi Jalina,

        One good scenario I can think of is a change coming up with the existing reports. Suppose there is a new infoobject (characteristic) required in the report, and this infoobject doesn't exist in the infocube on which this particular report is based on. So through re-modelling we will be able to insert the new info object, and by coding a routine in the transformation we will be able to make sure that any data load which runs hereafter will have the routine populating values for the new infoobject by a look up or some other logic. Now if you would want to have the data for the new infoobject, for all the records which have already been loaded to this infocube(historical data), then you could create a self load on the infocube, incorporate the same population routine in the transformation and then trigger the load to put the infoobject value in the infocube, for the historical data.

    Hope this helps,

    Regards,

      Manohar. D

    Add comment
    10|10000 characters needed characters exceeded

    • If you are sure that its a custom cube with no non-cumulative key figures, then I'm sure that zero elimination upon compression will work in this scenario.. Please do not forget to update this thread with the results once you have implemented the suggestions for a sample data.

  • avatar image
    Former Member
    May 26, 2013 at 05:54 AM

    Hi Jalina,

    Self loop is required in scenario where you want to check data from target and loop up in other provider and load back in target.

    e.g. in one case what i required to do is, i have a DSO1 and DSO2 out of this DSO2 brings delta which need to get loaded to DSO1, but all fields are from DSO1 only. So i have created a transformation and brought delta request in the source package and using expert routine i have looked up in DSO1 itself and populated rest all fields except one field which is comingfrom DSO2, so it is like delta is taken from DSO2, but all data is from DSO1 only.

    Regards,

    Ganesh

    Add comment
    10|10000 characters needed characters exceeded