Technology Blogs by Members
Explore a vibrant mix of technical expertise, industry insights, and tech buzz in member blogs covering SAP products, technology, and events. Get in the mix!
Showing results for 
Search instead for 
Did you mean: 
Active Contributor

patrice.lebihan presented this to ASUG yesterday.  Patrice Le Bihan is part of the SAP Analytics Solution Management team and currently responsible for the SBO Analysis products as well as the SAP NetWeaver BW and SAP ERP integration topics.

BI4.1 is now in ramp-up.  Patrice reviewed how to connect directly to BI ERP.  The second half is how connect to BW (separate blog.

Figure 1: Source: SAP

Figure 1 represents the different connectivity options between the tools, showing direct access.

Lumira Desktop can connect directly to ERP system against ERP InfoSets.

Figure 2: Source: SAP

Figure 2 shows the interface with Lumira using Freehand SQL against the SAP ERP InfoSet.  This is with 1.0.11 Lumira Desktop.

They are working on adding support for SAP queries and ABAP function modules.

Figure 3: Source: SAP

Figure 3 shows authored access, which means you need an UNX universe that will connect to ERP system. It will look like another relational source and add semantics on top of your SAP ERP system.  It exists today in BI4.0 but in BI4.1 has some improvements

Figure 4: Source: SAP

Figure 4 shows in BI4.1 SAP has added join detection.

Figure 5: Source: SAP

Figure 5 shows joins are detected with primary key/foreign key relationships in the data foundation of the Information Design Tool.

The ABAP functions, etc. appear as tables and then you create the business layer.

Figure 6: Source: SAP

Figure 6 shows improvements in Input Columns

Parameters are mapped as input columns.

This exists in BI4.0 but improvements have been made in interface

Figure 6 shows the 3 options to improve the UI

Figure 7: Source: SAP

Figure 7 shows the integrity check will now detect unresolved mandatory input column. If you select a multi-value prompt (not supported) this will be detected.

Figure 8: Source: SAP

Figure 8 shows BI4.1 has support for optional parameters.

Prior to BI4.1 prompts were all mandatory, even if optional in SAP ERP.

Part 2 of this blog will focus on the BW connectivity against BI4.1

1 Comment
Labels in this area