SAP BPC Logic Script from Beginner to Expert

SAP BPC Logic Script from Beginner to Expert, available at $64.99, has an average rating of 4.5, with 34 lectures, based on 40 reviews, and has 139 subscribers.

You will learn about Design and Build Logic Script Calculations Debug and Troubleshoot Logic Script Create Models and Dimensions Become an Expert in Logic Script This course is ideal for individuals who are SAP BPC Functional Consultants or SAP BPC Technical Consultants or SAP BPC End Users or SAP FICO Consultants It is particularly useful for SAP BPC Functional Consultants or SAP BPC Technical Consultants or SAP BPC End Users or SAP FICO Consultants.

Enroll now: SAP BPC Logic Script from Beginner to Expert

Summary

Title: SAP BPC Logic Script from Beginner to Expert

Price: $64.99

Average Rating: 4.5

Number of Lectures: 34

Number of Published Lectures: 34

Number of Curriculum Items: 34

Number of Published Curriculum Objects: 34

Original Price: ￡69.99

Quality Status: approved

Status: Live

What You Will Learn

Design and Build Logic Script Calculations

Debug and Troubleshoot Logic Script

Create Models and Dimensions

Become an Expert in Logic Script

Who Should Attend

SAP BPC Functional Consultants

SAP BPC Technical Consultants

SAP BPC End Users

SAP FICO Consultants

Target Audiences

SAP BPC Functional Consultants

SAP BPC Technical Consultants

SAP BPC End Users

SAP FICO Consultants

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

Course Curriculum

Chapter 1: Building the BPC Models, Dimensions and Input Form

Lecture 1: Quick Introduction to the Design

Lecture 2: Creating Dimensions for the Resource Model

Lecture 3: Creating Dimensions for the Planning Model

Lecture 4: Creating Dimensions for the Rates Model

Lecture 5: Creating the EPM Connections to the Models

Lecture 6: Quick Introduction to the Input Form

Chapter 2: Logic Script in the RESOURCE Model

Lecture 1: Simple *WHEN/*ENDWHEN Calculation – The Hello World in Logic Script!

Lecture 2: Use EXPRESSION keyword in *WHEN/*ENDWHEN

Lecture 3: Overview of the Web Administration Cockpit for Logic Script

Lecture 4: Creating Data Manager Package for Logic Script Execution

Lecture 5: Setting the Scope with *XDIM_MEMBERSET

Lecture 6: Changing the Scope and Aggregating Records

Lecture 7: Introduction to UJKT – Logic Script Tester in NetWeaver/BW

Lecture 8: Using *LOOKUP for Retrieving the Labour Rates

Lecture 9: Using *INCLUDE Statement for Modularising

Lecture 10: Retrieving MARKUP using MDX Tuples Lookup

Lecture 11: Expanding the Scope with *ADD_MEMBERSET

Lecture 12: Pushing Data to the Planning Model with *DESTINATION_APP

Chapter 3: Logic Script in the PLANNING Model

Lecture 1: Distributing data with *RUNNALOCATION

Lecture 2: Creating variables with *SELECT Statement

Lecture 3: Using *FOR/*NEXT within *WHEN/*ENDWHEN

Lecture 4: Adding Conditional Statement in *WHEN/*ENDWHEN

Lecture 5: Retrieving the FX Rates with *LOOKUP

Lecture 6: Improving the *LOOKUP for the FX Rates with *FOR/*NEXT

Chapter 4: Logic Script in DEFAULT

Lecture 1: Rewriting the Main Calculations of the Resource in DEFAULT

Lecture 2: Expanding the TIME Scope for MARKUP with *FOR/NEXT

Lecture 3: Challenges with *DESTINATION_APP in DEFAULT

Lecture 4: Solutions to the Challenges of *DESTINATION_APP in DEFAULT

Lecture 5: Rewritting the Main Calculations of the Planning Model in DEFAULT

Lecture 6: Changing the FX Translation with TIME Scope Expansion

Lecture 7: Changing the Initial Scope when Drivers are sent in DEFAULT

Lecture 8: Concluding Thoughts

Chapter 5: Bonus Section

Lecture 1: *COMMIT Statement in NetWeaver

Lecture 2: Transaction and Master Data read for *WHEN/*ENDWHEN

Instructors

Emiliyan Tanev
Managing Principal SAP Analytics Consultant

Rating Distribution

1 stars: 1 votes

2 stars: 2 votes

3 stars: 4 votes

4 stars: 14 votes

5 stars: 19 votes

Frequently Asked Questions

How long do I have access to the course materials?

You can view and review the lecture materials indefinitely, like an on-demand channel.

Can I take my courses with me wherever I go?

Definitely! If you have an internet connection, courses on Udemy are available on any device at any time. If you don’t have an internet connection, some instructors also let their students download course lectures. That’s up to the instructor though, so make sure you get on their good side!