Skip to Content

Patrice Le Bihan 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.

/wp-content/uploads/2013/07/1fig_250894.jpg

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.

/wp-content/uploads/2013/07/2fig_250901.jpg

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.

/wp-content/uploads/2013/07/3fig_250902.jpg

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

/wp-content/uploads/2013/07/4fig_250903.jpg

Figure 4: Source: SAP

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

/wp-content/uploads/2013/07/5fig_250907.jpg

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.

/wp-content/uploads/2013/07/6fig_250908.jpg

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

/wp-content/uploads/2013/07/7fig_250909.jpg

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.

/wp-content/uploads/2013/07/8fig_250910.jpg

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

To report this post you need to login first.

1 Comment

You must be Logged on to comment or reply to a post.

Leave a Reply