EPM & HyperionTechnical

EPM & Hyperion What Is the EPM Cloud Security Model? The EPM Cloud security model is the layered access design of Oracle EPM Cloud, combining identity domain authentication and single sign-on, predefined… Technical EPM & Hyperion What Is Essbase? Essbase is Oracle's multidimensional OLAP database engine that stores and calculates data in cubes with dimension hierarchies, block or aggregate storage and… Technical EPM & Hyperion What Is Groovy Scripting in EPM? Groovy scripting in EPM is the use of the Groovy language in Oracle EPM Cloud rules to add logic beyond calc scripts,… Technical EPM & Hyperion What Is a Load Rule? A load rule in Essbase and on-premises Hyperion is a rules file that maps a source file's columns, fields and formats to… Technical EPM & Hyperion What Is a Member Formula? A member formula in Oracle EPM is a calculation attached to a specific dimension member in the metadata, written in Essbase calculation… Technical EPM & Hyperion What Is Metadata? Metadata in Oracle EPM is the structural configuration of an application, including dimension members, hierarchies, aliases, properties and member formulas, defining how… Technical EPM & Hyperion What Is the Migration Utility? The Migration utility, known as Lifecycle Management (LCM), exports, transports and imports Oracle EPM artefacts such as metadata, rules, forms, reports, security… Technical EPM & Hyperion What Is a Planning Unit? A planning unit in Oracle EPM is the combination of scenario, version and entity, optionally with a secondary dimension, that is promoted… Technical EPM & Hyperion What Is Smart View (Technical)? Smart View (technical) refers to how Oracle's Office add-in connects Excel, Word and PowerPoint to EPM, Essbase and Oracle Analytics through provider… Technical EPM & Hyperion What Is a Substitution Variable? A substitution variable in Oracle EPM is a named, centrally maintained placeholder, such as current month, current year or forecast version, that… Technical EPM & Hyperion What Is Account Reconciliation (ARCS Architecture)? Account reconciliation (ARCS architecture) describes how Oracle Account Reconciliation connects general ledger balances, sub-ledger and bank data, reconciliation formats, auto-reconciliation rules, transaction… Technical EPM & Hyperion What Is an Alias Table? An alias table in Essbase is a named set of alternative member labels that lets the same member display different descriptions for… Technical EPM & Hyperion What Is an Attribute Dimension? An attribute dimension in Essbase is a secondary dimension that associates descriptive characteristics, such as size, region or category, with members of… Technical EPM & Hyperion What Are Cache Settings (Essbase)? Cache settings (Essbase) are the memory allocations for the index cache, data cache, data file cache and calculator cache in on-premises BSO… Technical EPM & Hyperion What Is a Calculation Script (Calc Script)? A calculation script (calc script) is Essbase's native procedural language for block storage cubes, used in business rules to calculate, aggregate, allocate,… Technical