Uploaded May 2026 | Updated September 2026, 3 weeks ago
Build custom calculations in Oracle Fusion Data Intelligence and Oracle Analytics Cloud to extend analysis with aggregate functions, string functions, and case logic. The tutorial also demonstrates nested calculations and reusable calculation folders to help teams organize analytical logic and better understand pricing and discount behavior. Check out additional resources at the links below.
This tutorial demonstrates how to build calculations in Oracle Fusion Data Intelligence and Oracle Analytics Cloud to create custom analytical logic from existing dataset columns. The workflow begins by creating calculated columns using operators and measures to derive discounted pricing, then validates and applies those calculations within workbook visualizations. The tutorial also explores aggregate and running aggregate functions, including percentile calculations that help identify discount trends and thresholds across products. Additional examples show how string functions can correct or standardize displayed values without changing the underlying dataset. The video then introduces expression calculations using case logic to categorize products into discount tiers based on pricing behavior. Nested calculations are also demonstrated to simplify complex logic and improve readability when multiple transformations are required. Finally, the tutorial shows how to organize related calculations into folders so analytical assets remain reusable and easier to manage. By the end, viewers understand how calculations can extend data analysis capabilities and support more flexible, customized reporting workflows.
Check out detailed instructions on how to get started with calculations: https://social.ora.cl/6003BBgXG1
Learn how to create meaningful analyses by building custom calculations in workbooks in this short self-paced course: https://social.ora.cl/6004BBgXHk
Find training paths for Oracle Analytics and AI from beginner to advanced and expert: https://social.ora.cl/6006BBgXJg
Explore self-paced short courses in the Oracle Analytics and AI Learning Hub: https://social.ora.cl/6004BBgXKA
0:00 Introduction to Calculations
0:50 Creating a Basic Calculation
2:06 Create visualization with calculation
3:05 Using Aggregate Functions
4:28 String Replace Functions
5:17 Building Case Logic Expressions
5:55 Nested Calculations
6:43 Organize with Folders
Like what you learned about Oracle Analytics Cloud? Subscribe now https://social.ora.cl/60025k87j
Join us at Oracle AI World: https://social.ora.cl/60035eVvJ
Contact AIDP sales: https://social.ora.cl/6003FLUMT
Learn more about Oracle AIDP: https://social.ora.cl/60047h76Q
Join the Oracle AIDP Community: https://social.ora.cl/60087h7Bj
Follow us here:
LinkedIn: https://social.ora.cl/60035eXuF
X: https://social.ora.cl/6008abVgG
Instagram: https://social.ora.cl/60095eXDN
Facebook: https://social.ora.cl/60065enQp
Build custom calculations in Oracle Fusion Data Intelligence and Oracle Analytics Cloud to extend analysis with aggregate functions, string functions, and case logic. The tutorial also demonstrates nested calculations and reusable calculation folders to help teams organize analytical logic and better understand pricing and discount behavior. Check out additional resources at the links below.
This tutorial demonstrates how to build calculations in Oracle Fusion Data Intelligence and Oracle Analytics Cloud to create custom analytical logic from existing dataset columns. The workflow begins by creating calculated columns using operators and measures to derive discounted pricing, then validates and applies those calculations within workbook visualizations. The tutorial also explores aggregate and running aggregate functions, including percentile calculations that help identify discount trends and thresholds across products. Additional examples show how string functions can correct or standardize displayed values without changing the underlying dataset. The video then introduces expression calculations using case logic to categorize products into discount tiers based on pricing behavior. Nested calculations are also demonstrated to simplify complex logic and improve readability when multiple transformations are required. Finally, the tutorial shows how to organize related calculations into folders so analytical assets remain reusable and easier to manage. By the end, viewers understand how calculations can extend data analysis capabilities and support more flexible, customized reporting workflows.
Check out detailed instructions on how to get started with calculations: https://social.ora.cl/6003BBgXG1
Learn how to create meaningful analyses by building custom calculations in workbooks in this short self-paced course: https://social.ora.cl/6004BBgXHk
Find training paths for Oracle Analytics and AI from beginner to advanced and expert: https://social.ora.cl/6006BBgXJg
Explore self-paced short courses in the Oracle Analytics and AI Learning Hub: https://social.ora.cl/6004BBgXKA
0:00 Introduction to Calculations
0:50 Creating a Basic Calculation
2:06 Create visualization with calculation
3:05 Using Aggregate Functions
4:28 String Replace Functions
5:17 Building Case Logic Expressions
5:55 Nested Calculations
6:43 Organize with Folders
Like what you learned about Oracle Analytics Cloud? Subscribe now https://social.ora.cl/60025k87j
Join us at Oracle AI World: https://social.ora.cl/60035eVvJ
Contact AIDP sales: https://social.ora.cl/6003FLUMT
Learn more about Oracle AIDP: https://social.ora.cl/60047h76Q
Join the Oracle AIDP Community: https://social.ora.cl/60087h7Bj
Follow us here:
LinkedIn: https://social.ora.cl/60035eXuF
X: https://social.ora.cl/6008abVgG
Instagram: https://social.ora.cl/60095eXDN
Facebook: https://social.ora.cl/60065enQp
