SAP Note 1581709 - BW InfoSet with InfoCube and LEFT OUTER join

Component : InfoSet Query - Interface to Database

Solution : https://service.sap.com/sap/support/notes/1581709 (SAP Service marketplace login required)

Summary :
Previously in SAP BW InfoSets, LEFT OUTER JOIN operations with BW InfoCubes were restricted due to potential performance issues stemming from inefficient SQL queries. Now, enabling LEFT OUTER JOIN could be permitted in cases where the number of JOINs and data volume is manageably low. This adjustment is necessary to facilitate specific modeling scenarios utilizing InfoCubes. Modifications can be applied through the RSADMIN parameter BW_ISET_CUBE_LEFT_OUTER_JOIN_ALLOW, settable via SAP_RS‎ADMIN_MAINTAIN. Import relevant Support Packages as detailed in SAP Notes for respective SAP NetWeaver BW versions to incorporate these changes fully.

Key words :
join operation left outer join, preliminary version sapbwnews nw bw 7, preliminary version sapbinews nw 7, solution sap netweaver bw 7, left outer join, sapbwnews nw bw 7, sap nw bw 7, left outer property, sap netweaver bw 7, 01 bw abap sp10

Related Notes :

1583842Constant Selection Append used as an outer join (CSA)
1581161SAPBWNews NW BW 7.02 ABAP SP09
1567706SAPBWNews NW7.0 BW ABAP Support Package 27
1538941SAPBWNews NW BW 7.30 ABAP SP3
1510977Prelimenary Version SAPBWNews NW BW 7.11 ABAP SP08
1419539SAPBWNews NW BW 7.01 ABAP SP10