The De Villiers Walton Blog

Recent blog posts
05
Aug
0
Posted by on in SAP BI

During a recent project a requirement was identified for directly uploading data from MS Excel into SAP BW. Various options were considered to address this requirement; amongst others:

  • SAP BW IP Planning Layout, which would have been too expensive to develop and maintain.
  • High frequency flat-file uploads, which was deemed too tedious from an end-user perspective.
  • Making a Remote Function Call (RFC) through VBA to a Function Module (such as RSDRI_ODSO_INSERT_RFC) in SAP BW. Even though I have done this before this technique requires the SAP GUI to be installed on the user’s desktop.

Instead I decided to create a Web Service DataSource with Real-time Data Acquisition to stage the data in SAP BW. The challenging bit was creating the client-side VBA to generate the required XML and then to make a call to the SAP BW Web Service. I have previously done bits of this in VBA, but I have never before attempted to make a call to a SAP BW DataSource from VBA.

Continue reading
Hits: 1295
Rate this blog entry:
0
26
Jul
0
Posted by on in SAP CRM

Miller Heiman is one of the world’s most respected sales performance companies. Their Strategic Selling® system helps thousands of organizations worldwide develop comprehensive strategies to win sales opportunities.

Following on from our previous blog, this short movie shows how we seamlessly integrated Miller Heiman’s Blue Sheet and Green Sheet into the SAP Cloud for Customer Opportunity and Activity using SAP's Cloud Application Studio.

Continue reading
Hits: 1684
Rate this blog entry:
22
Jul
0
Posted by on in SAP Cloud

Interest in SAP's Cloud for Customer solution and in particular SAP Cloud for Sales is red-hot at the moment. We are able to provide you with an estimate of the cost, effort and duration of your SAP Cloud for Sales project.

Continue reading
Hits: 1006
Rate this blog entry:
0
30
Jun
0
Posted by on in SAP E-Commerce

Dear SAP WCEM customer,

Like you, we mourned the premature passing of the SAP Web Channel Experience Management (WCEM) solution. We liked it for the same reasons you decided to invest in it and have written about this at length in our WCEM blogs.

Continue reading
Hits: 1651
Rate this blog entry:
0
02
Jul
0
Posted by on in SAP BI

Recently we were investigating the options to resolve the particular analysis requirements of a customer to combine well defined data held in BW with more ad hoc data from various sources.  This wasn’t the first time I have come across this issue.  It is a problem that has been around since the inception of Data Warehousing.  Systems such as SAP BW were created specifically to centralise, homogenise and standardise data, to provide an efficient and consistent analysis view.  Data warehouses also drive good data governance and security, so this gives great control of data from an IT viewpoint.  Our requirement however, involves the opposite; namely de-centralisation, de-standardisation and control being passed to particular individuals or non-IT departments.  

Continue reading
Hits: 2211
Rate this blog entry:
0