As a gift for my wife, I have created a book full of motivational and inspiring quotes. She loves this type of book and have many in her collection, and I though, instead of just buying one, I will make one for her.
Each page contains a few quotes and is beautifully illustrated.
Here is an excerpt from one of the pages and you can get a copy here
SAP BPC Training Courses
I have decided to move all my training courses to YouTube for free. If you like the courses, please subscribe and support me on Patreon.
The links to the various courses and playlists can be found in the pages to the right.
So that means al the courses, that previously were paid content through udemy is now free for you to enjoy and use. However, since training courses are expensive to creat3e and maintain, please could you support me on Patreon:
As part of my sql tutorial which is still very much in progress, I thought I'd do a quick post on using sql with statistics. I am covering two topics today, which are elementary concepts in statistics but forms a compliment my tutorials very well.
Permutations
Consider a set of 4
objects. Now, suppose that we want to fill three positions with objects selected from the 4. We need to consider the order of the items in each set as well, then the number of possible ordered arrangements is 24 and they are
a b c
b a c
c a b
Dab
a b d
b a d
c a d
d a c
a c b
b c a
c b a
d b c
a c d
b c d
c b d
d b a
a d c
b d a
c d b
d c a
a d b
b d c
c d a
d c b
The number of
possible ordered arrangements can be computed as follows:
Since there are 3 positions and 4 objects, the
first position can be filled in 4 different ways. Once the first position is filled
the remaining 2 positions can be filled from the remaining 3 objects. Thus, the
second position can be filled in 3 ways. The third position can be filled in 2
ways. Then the total number of ways 3 positions can be filled out of 4 objects
is given by
(4)(3)(2) = 24.
In HANA, we can write the following sql to achieve the same result set:
do begin
t_data =
select 'a' as id
from dummy
union all
select 'b' as id
from dummy
union all
select 'c' as id
from dummy
union all
select 'd' as id
from dummy
;
select o.id, t.id, r.id, f.id
from :t_data as o
cross join :t_data as t
cross join :t_data as r
cross join :t_data as f
where o.id != t.id
and o.id != r.id
and o.id != f.id
and t.id != r.id
and t.id != f.id
and r.id != f.id
;
end;
;ID;ID;ID;ID
1 ;a ;b ;c ;d
2 ;a ;b ;d ;c
3 ;a ;c ;b ;d
4 ;a ;c ;d ;b
5 ;a ;d ;b ;c
6 ;a ;d ;c ;b
7 ;b ;a ;c ;d
8 ;b ;a ;d ;c
9 ;b ;c ;a ;d
10;b ;c ;d ;a
11;b ;d ;a ;c
12;b ;d ;c ;a
13;c ;a ;b ;d
14;c ;a ;d ;b
15;c ;b ;a ;d
16;c ;b ;d ;a
17;c ;d ;a ;b
18;c ;d ;b ;a
19;d ;a ;b ;c
20;d ;a ;c ;b
21;d ;b ;a ;c
22;d ;b ;c ;a
23;d ;c ;a ;b
24;d ;c ;b ;a
Combinations
In permutation,
order is important. But in many problems, the order of selection is not
important and interest centers only on the set of r objects. Let c denote the
number of subsets of size r that can be selected from n different objects.
How many committees
of two chemists and one physicist can be formed from 4 chemists and 3
physicists?
I am pleased to announce that we have published a new SAP BPC Embedded 11 Course. This course covers all the new functionality of BPC Embedded running on BW4HANA, such as aDSOs, Composite Providers, openODSviews and more. The course will take you through all the steps to create a planning application from start to finish,
As a bonus, this course includes the book below, which retails for $40 on Amazon. It also acts as a study guide for the course. You may preview it here:
I have to highlight that this course includes the book below, which retails for $40 on Amazon. It also acts as a study guide for the course.
Previews of the lectures are available on my YouTube Channel. Be sure to check out all the other content as well.
Should you have any questions or comments, please do not hesitate to contact me.
The second chapter of my SAP HANA sql script tutorial is now available here. It is the beginning of covering the sql script language elements and covers BNF notation in more detail, Be sure to check it out and subscribe. The next tutorial will follow shortly. Should you require a SAP system to practice or try this out, follow the steps on 'How to activate your own SAP HANA system on the SAP Cloud Platform'
I am publishing a new series of tutorials on SAP HANA sql script. These tutorials will form the basis of a new book I am writing and will be published on a regular basis, so subscribe to keep up to date.
Introducing HANA sql script
The purpose of this guide is to simplify SAP HANA sql
script. It differs from all the sql courses available. The sql language is
looked at in detail, starting with a comprehensive look at the notation and
syntactic elements and then progressing to cover the individual statements.
Other courses may jump straight into the SELECT statement, for example, the
following course spends almost all of the course introduction covering the
installation of the database and only 42 seconds on SQL statement Fundamentals.
This pattern is repeated across blogs, online tutorials and
MOOCs. No time is spent on teaching the notation and general syntax. Everyone
jumps straight into the SELECT statement. Once more complex syntactic elements
are reached, the student may get lost as the general principles have not been
mastered yet and learning stops.
We believe that the first step in mastering sql is
understanding the notation used in SAP’s documentation – a ‘Teach a man to
fish’ approach. Once the notation is mastered, getting to grips with the rest
of the language is significantly easier. You will be able to craft complex and
efficient queries more effectively.
Why SAP HANA sql script?
We get this question often. So why did we choose to write a
guide on SAP HANA sql. The reason is that SAP is the leading ERP provider with
more than 12 million users, 121 000 installations and 41 200 customers.
There is an additional imperative for customers to move to SAP HANA. At the end
of 2025, SAP is sun-setting support for legacy software, such as SAP ERP and
BW. Customers will have to upgrade their database to HANA, and upgrade their
software to S/4HANA. A large install base, demand for skills and our enthusiasm
for the SAP platform in general, choosing to create a course on SAP SQL script
is a no-brainer.
This course is for BPC, BW and SD consultants who want to create an integrated Sales Price Planning solution in SAP BPC Embedded. This lecture is the first of a series of lectures on how to create a fully integrated planning solution in SAP BPC Embedded.
The full course is now free and can be accessed here
SAP's strategy is clearly heading towards SAC, including planning related activities. BPC 10.1 allowed the user or admin to create web reports and input-schedules. This is no longer available in BPC 11. Web-based input schedules and reports have to be created in SAC.
I have created a new page that aims to set out the steps to integrate SAP BPC with Embedded from a functional point of view.
How to activate your own SAP HANA system on the SAP Cloud Platform
Did you know that you can activate your own SAP HANA system on the SAP Cloud Platform?
All you need is a gmail
I just activated a system and found it very easy. In this post I'll take you through the required steps to activate this system as well as links to the documentation.
The first step is to make sure that you have an appropriate SAP s or p number. This can be obtained as follows:
If you already have an SAP logon, you can use your user credentials here, else, simply logon with your google, linked, facebook or twitter account. I will use my google account. Once you have logged into your google account, you will get the following message:
The next step is to link a new SAP account to your google account, by clicking on the 'Create Linked Account' button.
Fill in the registration details and then submit. You will be greeted with the following message:
Click on the link to activate your account. You will then be taken to the logon screen again. Log on with your email and click on the Link Accounts button:
Your sap and google accounts are now linked and you should be greeted by the following message:
Now, clicking on the logon button again and then selecting 'Account Settings', you can see you S-or-P Number:
Now head over to https://account.hanatrial.ondemand.com and click on Register. If you are still logged into your SAP account, your credentials will be picked up and you should be met with a Welcome screen:
After accepting all the terms and disclaimers, you will be taken to the Cloud Platform Cockpit. There are pletny options to choose from but we are interested in a SAP HANA system. So click on the Neo Trial button:
Your will now be presented with your subaccount and any systems that you may have activated. Since we have not activated anything yet, this screen contains not much information.
On the menu on the right, select Databases & Schemas:
Any activated databases & schemas will be listed here. Click on New:
Next, select the database ID and the SYSTEM user password. Note this password, as we will use it in the next few steps:
You database should be created and is being activated:
Once all steps are complete, we can go ahead with the configuration.
We will complete three steps:
1 - Use the SYSTEM user to create a database user.
2 - Connect eclipse to the HANA Cloud system
3 - Create a repository workspace.
The steps are published here. I will add some screenshots to make the process easier:
Use the SYSTEM user to create a database user.
We will use the SYSTEM user to create the database user, which will also create the schema we need.
Select the relevant SAP HANA tenant database in the list.
In the overview that is shown in the lower part of the screen, open the SAP HANA cockpit link under Administration Tools.
In the Enter Username field, enter SYSTEM, then enter the password you determined for the SYSTEM user in the Enter Password field.
A message is displayed to inform you that at that point, you lack the roles that you need to open the SAP HANA cockpit.
To confirm the message, choose OK.
You receive a confirmation that the required roles are assigned to you automatically.
Choose Continue.
You are now logged on to the SAP HANA cockpit.
Choose Manage Roles and Users.
To create database users and assign them the required roles, expand the Security node.
Open the context menu for the Users node and choose New User.
On the User tab, provide a name for the new user.
The user name always appears in upper case letters.
In the Authentication section, make sure the Password checkbox is selected and enter a password.
To create the user, choose Save.
The new database user is displayed as a new node under the Users node.
To assign your user the roles with the required permissions for working with SAP HANA Web-based Development Workbench, go to the Granted Roles section and choose the + (Add Role) button.
Type xs.ide in the search field and select all roles in the result list.
Choose Ok.
The roles are added on the Granted Roles tab.
Repeat the last two steps to assign the CONTENT_ADMIN role to the user.
Use of the Web-Based Development Workbench
At this point, you should be able to log into the HANA database and use the web client:
Select the relevant SAP HANA tenant database in the list again and select:
SAP HANA Web-Based Development Workbench
Log into the HANA system using the Database user created in the steps above:
You may be asked to change your password and then taken to the Web-based Workbench:
Clicking on Catalog takes us to the SAP HANA Modeler perspective, and we can see the DBUSER schema:
Right-Clicking on the schema, select 'Open Sql console". We are greeted with a new tab and a sql console and we can write some sql code:
Connect to your SAP HANA Database via the Eclipse IDE (Neon)
Note the prerequisite. Only Eclipse Neon is supported. If you don't have Eclipse Neon, download it from here
Once downloaded and installed, follow the procedure below:
Procedure
Go to WindowShow ViewOther.
Select SAP HANASystems and choose OK.
From the Systems context menu, choose Add Cloud System.
Verify the host in the Subaccount Information window.
