Technical

Business Intelligence What Is a Data Pipeline? A data pipeline is the automated, orchestrated sequence of steps that moves data from source systems through ingestion, transformation and validation to… Technical Business Intelligence What Is Data Refresh Architecture? Data refresh architecture is the design of schedules, triggers, dependencies, refresh methods and monitoring that keep BI datasets current, balancing freshness needs… Technical Business Intelligence What Is DAX? DAX (Data Analysis Expressions) is the formula language used in Power BI, Analysis Services Tabular and Power Pivot to define measures, calculated… Technical EPM & Hyperion What Are Dense and Sparse Dimensions? Dense and sparse dimensions are Essbase block storage settings in which dense dimensions define the cells inside each data block and sparse… Technical Intelligent Automation What Is a Digital Worker? A digital worker is the operating model in which an automation bot is managed like a workforce member, with defined responsibilities, its… Technical EPM & Hyperion What Is a Dimension? A dimension in Oracle EPM is a structural axis of the Essbase cube, such as Account, Entity, Period, Scenario or Version, whose… Technical EPM & Hyperion What Is Dimension Build? A dimension build in Oracle EPM is the automated creation or update of dimension members, hierarchies and properties from an external source,… Technical Business Intelligence What Is a Dimension Table? A dimension table stores the descriptive attributes, such as account, entity, cost centre, product and date, used to filter, group and label… Technical Business Intelligence What Is Direct Query vs Import Mode? Direct query vs import mode is the Power BI storage choice between Import, which loads data into the in-memory engine for fast,… Technical Consultancy What Is a Disaster Recovery Plan? A disaster recovery plan (DRP) is the documented and tested set of procedures for restoring a system after a disruptive event such… Technical Business Intelligence What Is ELT (Extract, Load, Transform)? ELT (extract, load, transform) is the data integration pattern that loads raw source data into a target analytical platform first and transforms… Technical Consultancy What Is an Environment Strategy (Dev, Test, Prod)? An environment strategy defines the number, purpose, configuration, data and access rules of the environments used in an ERP or EPM programme,… Technical EPM & Hyperion What Is EPM Automate? EPM Automate is Oracle's command-line utility for automating EPM Cloud tasks such as uploading files, running data integrations and business rules, exporting… Technical EPM & Hyperion What Is the EPM Cloud REST API? The EPM Cloud REST API is Oracle's set of HTTP web services for programmatically running jobs, business rules, data imports and exports,… Technical 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