SAP & VBA: simple Excel application with User Form

SAP & VBA: simple Excel application with User Form

SAP BW
SAP GUI Scripting is an automation interface that enhances the capabilities of SAP GUI. Using Visual Basic users may automate repetitive tasks by running scripts. Developers on the other hand may build complex tools to make repetitive time-consuming tasks quick and easy. In SAP and VBA: How to Start blog post, you can check how to start working with SAP GUI scripting. Below you can find simple example of the code to be run from Microsoft Excel. Example In the post I will show how to create simple Excel application with UserForm. In the UserForm user will be able to choose SAP Transaction (T-Code) and then the chosen transaction will be run in SAP. Tutorial Open Excel and run Visual Basic editor (from Developer tab).Using Visual Basic editor in MS…
Read More
Start to work with HANA Predictive Analysis Library (PAL)

Start to work with HANA Predictive Analysis Library (PAL)

SAP HANA
The HANA Predictive Analysis Library (PAL) is a set of predictive algorithms in the HANA Application Function Library (AFL). Predictive Analysis Library (PAL) contains a number of universal predictive algorithms that can be executed directly against the data in HANA, includes classic and universal predictive analysis algorithms in data-mining categories: clustering, classification, regression, association, time series, preprocessing, statistics, Social Network analysis. When the PAL is installed, you can use algorithms using SQL Script or you can create a Predictive Analytical Model via Flowgraph Model tool. Univariate Statistics In this tutorial Univariate Statistics function is used. This function calculates several basic univariate statistics including mean, median, variance, standard deviation, skewness and kurtosis. The function treats each column as one dataset and calculates the statistics respectively. You can find details in SAP HANA Predictive Analysis…
Read More