SAP BPC Logic Script from Beginner to Expert
3.7 (5 ratings)
Instead of using a simple lifetime average, Udemy calculates a course's star rating by considering a number of different factors such as the number of ratings, the age of ratings, and the likelihood of fraudulent ratings.
29 students enrolled
Wishlisted Wishlist

Please confirm that you want to add SAP BPC Logic Script from Beginner to Expert to your Wishlist.

Add to Wishlist

SAP BPC Logic Script from Beginner to Expert

A-Z Guide to create awesome SAP BPC applications using the proprietary programming language - Logic Script
3.7 (5 ratings)
Instead of using a simple lifetime average, Udemy calculates a course's star rating by considering a number of different factors such as the number of ratings, the age of ratings, and the likelihood of fraudulent ratings.
29 students enrolled
Created by Emiliyan Tanev
Last updated 5/2017
English
Price: $75
30-Day Money-Back Guarantee
Includes:
  • 4.5 hours on-demand video
  • 2 Supplemental Resources
  • Full lifetime access
  • Access on mobile and TV
  • Certificate of Completion
What Will I Learn?
  • Design and Build Logic Script Calculations
  • Debug and Troubleshoot Logic Script
  • Create Models and Dimensions
  • Become an Expert in Logic Script
View Curriculum
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 is the target audience?
  • SAP BPC Functional Consultants
  • SAP BPC Technical Consultants
  • SAP BPC End Users
  • SAP FICO Consultants
Students Who Viewed This Course Also Viewed
Curriculum For This Course
34 Lectures
04:25:28
+
Building the BPC Models, Dimensions and Input Form
6 Lectures 29:01

Creating Dimensions for the Resource Model
09:28

Creating Dimensions for the Planning Model
04:41

Creating Dimensions for the Rates Model
04:43


+
Logic Script in the RESOURCE Model
12 Lectures 01:42:50
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


Using *LOOKUP for Retrieving the Labour Rates
14:30

Using *INCLUDE Statement for Modularising
04:19

Retrieving MARKUP using MDX Tuples Lookup
11:51


Pushing Data to the Planning Model with *DESTINATION_APP
10:21
+
Logic Script in the PLANNING Model
6 Lectures 53:56
Distributing data with *RUNNALOCATION
08:11

Creating variables with *SELECT Statement
11:23

Using *FOR/*NEXT within *WHEN/*ENDWHEN
12:12


Retrieving the FX Rates with *LOOKUP
09:39

Improving the *LOOKUP for the FX Rates with *FOR/*NEXT
05:31
+
Logic Script in DEFAULT
8 Lectures 01:03:06
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
+
Bonus Section
2 Lectures 16:35
*COMMIT Statement in NetWeaver
03:08

Transaction and Master Data read for *WHEN/*ENDWHEN
13:27
About the Instructor
Emiliyan Tanev
3.7 Average rating
5 Reviews
29 Students
1 Course
SAP BPC Consultant

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.