Skip to Content

SAP Predictive Analytics 2.1 – Connecting to your SAP ERP System

For fun, I thought I would see if this works.  Of course, using fake data (I can’t share real data here).  I am using an ERP BEx query against the FI Check Register.  Say for instance you want to forecast cash flow based on cash paid (in public sector enterprises, this is a big deal in my experience).

Using SAP Predictive’s Expert Analytics, I gave this a try.

/wp-content/uploads/2015/05/1aao_696899.jpg

Figure 1

First (and this is just me) I took a look at how the BEx query looks in Analysis Office.  Note that I am using a SAP Business Content BEx Query against the check register, not one that I created myself.

/wp-content/uploads/2015/05/2checkregister_696900.jpg

Figure 2

Using Expert Analytics I search for the check register query

/wp-content/uploads/2015/05/3view_696901.jpg

Figure 3

I decide not to select the Cash Discount.  See the message “Selected query contains features that are not currently supported by this application” – when I tried this in the 2.0 version I couldn’t get the standard BEx queries with cost center hierarchies to work.   I hope to research this more later.

/wp-content/uploads/2015/05/4autoreg_696903.jpg

Figure 4

Figure 4 shows the model configuration where I select forecast over trend.

/wp-content/uploads/2015/05/5success_696904.jpg

Figure 5

Figure 5 shows success when I run the model.

/wp-content/uploads/2015/05/6visualize_696905.jpg

Figure 6

Figure 6 shows a visualization of the predicted values.

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