Skip to content

EPMware Logic Builder Guide

Welcome to the EPMware Logic Builder Guide...!!!
This guide provides comprehensive instructions for creating and managing custom logic scripts to extend EPMware functionality and automate complex business processes.

📘 About This Guide

The Logic Builder module enables users to build custom logic across multiple EPMware modules to address advanced business requirements such as:

  • Custom property validations
  • Executing custom tasks within workflows
  • Automating metadata and system processes

🧩 Script Development Options

The Logic Builder uses Oracle PL/SQL as its programming language, and all scripts reside within the EPMware database.

For On-Premise customers only, it is also possible to:

  • Develop stored database functions
  • Reference those functions from Logic Scripts

This approach allows business logic to remain hidden from the front-end, improving security and maintainability.

🔗 Script Assignment & Execution

All Logic Scripts must be assigned to their respective configurations to be executed.

The execution flow follows a two-step process:

  1. Create the Logic Script in the Logic Builder module
  2. Assign the script in its related configuration screen

For example: - A Dimension Mapping logic script executes only when it is referenced in the Dimension Mapping configuration - The script runs when a triggering event occurs, such as creating a new request line for a mapped dimension

In summary, Logic Scripts are executed only when both: - They are correctly configured - A related system event is triggered

Tip

Always verify script assignment in the configuration screen to ensure the script executes as expected.

Prerequisites

Before using this guide, ensure you have:

  • Access to your EPMware environment
  • Basic understanding of Oracle PL/SQL syntax
  • Familiarity with EPMware metadata management concepts
  • Access to the Logic Builder module (via Security Provisioning)

Important Note

For cloud deployments, stored database functions are not available. All logic must be implemented within the Script Editor interface.

Quick Start

Explore the complete Logic Builder documentation:

Support & Resources

  • Technical Support: support@epmware.com
  • Phone: 408-614-0442
  • Website: www.epmware.com
  • Administrator Guide: For general EPMware administration topics