Skip to Content
0

Lookups on multiple extractors

Nov 25, 2016 at 03:07 PM

22

avatar image
Former Member

It is required to develop Energy Audit reports in SAP BI and the logic provided in FS is very different from BI Logic.They have used customization at extractor level for standard extractors.Now we have to develop report applying that logic on BI Side as a modeling part. Below is the sample of the logic provided.

  • 1.Fetch all fields from extractor 0UC_GRIDLVL_ATTR whereGRID_LEVEL= 50, 30 and 32 .
  • 2.Fetch GRID_NAME field from extractor 0UC_GRID_TEXT for all GRID ID obtained from Step 1.
  • Now Feeder ID’s to be shown in output depend on below conditions also.
  • 3.Fetch field INT_UI (Internal PoD), DATETO, TIMETO, DATEFROM andTIMEFROM from extractor 0UC_PODGRID_ATTR for GRID_ID obtained from Step 1 where DATEFROM of extractor <= From-date entered in selection screen and DATETO >= To-date entered in selection screen
  • Here we fetch only those Internal PoDs which lie in date range specified.
  • 4.Fetch INT_UI, ANLAGE, DATETO and DATEFROM from extractor 0UC_PODINST_ATTR for all INT_UI obtained from Step 3 where DATEFROM <= From-date entered in selection screen and DATETO >= To-date entered in selection screen.
  • Here we get installtions (ANLAGE) for Internal PoDs (INT_UI) obtained.
  • 5.Fetch ANLAGE, ANLART from extractor 0UCINSTALLA_ATTR for all ANLAGE obtained from Step 4 where ANLART= 33KI (33KV Intput), ANLART=33KO (33KV Output).
  • 6.Fetch ANLAGE, AB, BIS HIGHLEVINST from extractor 0UCINSTALLAH_ATTR for all ANLAGE obtained from Step 4 where AB <= From-date entered in selection screen and BIS >= To-date entered in selection screen.
  • 7.Fetch ANLAGE, LOGIKNR, BIS, AB from extractor 0UC_DEVINST_ATTR for all ANLAGE obtained from Step 4 AB <= From-date entered in selection screen and BIS >= To-date entered in selection screen.
  • 8.Fetch EQUNR, BIS, AB, LOGIKNR from extractor 0UC_DEVICEH_ATTR for all LOGIKNR obtained from Step 7 where AB <= From-date entered in selection screen and BIS >= To-date entered in selection screen.

How this logic can be implemented on BI side? As one master data flow has lookup on 2nd and then on 3rd and so on. Please guide.

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

0 Answers