SAP BPC Logic Script from Beginner to Expert

A-Z Guide to create awesome SAP BPC applications using the proprietary programming language - Logic Script

(31 ratings)

107 students

Created by Emiliyan Tanev

Last updated 5/2017

English

English [Auto]

30-Day Money-Back Guarantee

What you'll learn

Design and Build Logic Script Calculations
Debug and Troubleshoot Logic Script
Create Models and Dimensions
Become an Expert in Logic Script

5 sections • 34 lectures • 4h 25m total length

Preview03:13
Creating Dimensions for the Resource Model
09:28
Creating Dimensions for the Planning Model
04:41
Creating Dimensions for the Rates Model
04:43
Preview02:31
Preview04:25

Simple *WHEN/*ENDWHEN Calculation - The "Hello World" in Logic Script!
08:43
Use EXPRESSION keyword in *WHEN/*ENDWHEN
04:24
Overview of the Web Administration Cockpit for Logic Script
05:24
Creating Data Manager Package for Logic Script Execution
09:10
Setting the Scope with *XDIM_MEMBERSET
09:55
Changing the Scope and Aggregating Records
14:13
Preview07:11
Using *LOOKUP for Retrieving the Labour Rates
14:30
Using *INCLUDE Statement for Modularising
04:19
Retrieving MARKUP using MDX Tuples Lookup
11:51
Preview02:49
Pushing Data to the Planning Model with *DESTINATION_APP
10:21

Rewriting the Main Calculations of the Resource in DEFAULT
13:10
Expanding the TIME Scope for MARKUP with *FOR/NEXT
06:10
Challenges with *DESTINATION_APP in DEFAULT
15:06
Solutions to the Challenges of *DESTINATION_APP in DEFAULT
02:09
Rewritting the Main Calculations of the Planning Model in DEFAULT
06:14
Changing the FX Translation with TIME Scope Expansion
08:44
Changing the Initial Scope when Drivers are sent in DEFAULT
11:08
Concluding Thoughts
00:25

Requirements

General SAP BPC knowledge
SAP BPC 10.x system on NetWeaver/BW

Description

Design and Build Awesome SAP BPC Calculations!

Logic Script or Script Logic is a powerful proprietary language used in SAP BPC for logic execution. While it is widely used in almost every BPC implementation, especially for the Planning Models, there aren’t many resources teaching you on best practices or how to write it correctly.

The official SAP BPC420 BPC Administration course is covering only marginally how the Logic Script code should be written. Therefore the majority of the consultants are learning by doing without tutor guidance. The so-called “Trial and error” method.

This course has been created with core idea that the best way of learning something is to practice This is the reason the course is all about telling while showing. You will not see any presentation slides!

There are five sections.

Section 1: Building the same model and dimensions as I use for the course
Section 2: Introduction to Logic Script and writing Logic for Resource Model
Section 3: Logic Script for Planning Model
Section 4: Rewriting the Logic Script for DEFAULT Logic
Section 5: Bonus Lectures

Who this course is for:

SAP BPC Functional Consultants
SAP BPC Technical Consultants
SAP BPC End Users
SAP FICO Consultants

Emiliyan Tanev

SAP BPC Consultant

4.4 Instructor Rating
31 Reviews
107 Students
1 Course

SAP BPC Consultant with a few years experience in SAP FICO Support. Ex management accountant and a Fully Qualified CIMA UK associate member, passionate about learning and implementing new technical stuff. Substantial programming knowledge in Logic Script and a fair amount knowledge in VBA, ABAP for BADI. Committed to constantly improve and keep the technical skills up to date with continuous learning, testing and practicing.

SAP BPC Logic Script from Beginner to Expert

What you'll learn

Course content

Building the BPC Models, Dimensions and Input Form6 lectures • 29min

Logic Script in the RESOURCE Model12 lectures • 1hr 43min

Logic Script in the PLANNING Model6 lectures • 54min

Logic Script in DEFAULT8 lectures • 1hr 3min

Bonus Section2 lectures • 17min

Requirements

Description

Who this course is for:

Instructor