SAP BPC Logic Script from Beginner to Expert

Description

In this course, you will :

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

Syllabus :

1. Building the BPC Models, Dimensions and Input Form

• Quick Introduction to the Design
• Creating Dimensions for the Resource Model
• Creating Dimensions for the Planning Model
• Creating Dimensions for the Rates Model
• Creating the EPM Connections to the Models
• Quick Introduction to the Input Form

 

2. Logic Script in the RESOURCE Model

• Simple *WHEN/*ENDWHEN Calculation - The "Hello World" in Logic Script!
• Use EXPRESSION keyword in *WHEN/*ENDWHEN
• Overview of the Web Administration Cockpit for Logic Script
• Creating Data Manager Package for Logic Script Execution
• Setting the Scope with *XDIM_MEMBERSET
• Changing the Scope and Aggregating Records
• Introduction to UJKT - Logic Script Tester in NetWeaver/BW
• Using *LOOKUP for Retrieving the Labour Rates
• Using *INCLUDE Statement for Modularising
• Retrieving MARKUP using MDX Tuples Lookup
• Expanding the Scope with *ADD_MEMBERSET
• Pushing Data to the Planning Model with *DESTINATION_APP

 

3. Logic Script in the PLANNING Model

• Distributing data with *RUNNALOCATION
• Creating variables with *SELECT Statement
• Using *FOR/*NEXT within *WHEN/*ENDWHEN
• Adding Conditional Statement in *WHEN/*ENDWHEN
• Retrieving the FX Rates with *LOOKUP
• Improving the *LOOKUP for the FX Rates with *FOR/*NEXT

 

4. Logic Script in DEFAULT

• Rewriting the Main Calculations of the Resource in DEFAULT
• Expanding the TIME Scope for MARKUP with *FOR/NEXT
• Challenges with *DESTINATION_APP in DEFAULT
• Solutions to the Challenges of *DESTINATION_APP in DEFAULT
• Rewritting the Main Calculations of the Planning Model in DEFAULT
• Changing the FX Translation with TIME Scope Expansion
• Changing the Initial Scope when Drivers are sent in DEFAULT

Show more