• Knowledge Base
  • Training and Tutorials
  • Downloads
  • Jedox.com
Jedox Knowledge Base
  • Knowledge Base
  • Training and Tutorials
  • Downloads
  • Jedox.com

Knowledge Base

Home/Knowledge Base/Models/Financial Consolidation Model/Tasks/Configuration/

2 ArticlesBalance Sheet Cube →

  • Transaction Type Dimension (Financial Consolidation)
  • BS Account (Financial Consolidation)

1 ArticlesCash Flow Cube →

  • CF Account Dimension (Financial Consolidation)

9 ArticlesCurrency Conversion →

  • Scaling Amounts in Reports
  • Exchange Rates
  • Configuration of Conversion Types
  • Setting Up the Available Source Currencies
  • Synchronizing Exchange Rates in Forecast and Budget Versions

7 ArticlesOther →

  • Partner Entity Dimension (Financial Consolidation)
  • Month_YTD Dimension
  • Legal Entity Dimension (Financial Consolidation)
  • Scope Dimension
  • Configuring Design Elements

1 ArticlesProfit and Loss Cube →

  • PnL Account Dimension (Financial Consolidation)

Current version

Jedox 2019.4

Looking for older version of this page? Please check out our support portal!
  • General
    • How Jedox works
    • Jedox Architecture
    • Languages
    • Software Development and Testing at Jedox
    • Support Lifecycle
    • Release Notes 2019.4
    • Release Notes 2019.3
    • Known Issues
    • In-Preview and Deprecated Features
    • Windows Start Menu Entries
    • Predictive Analytics and R Integration
    • Third-Party Software
    • Jedox Component Versions
    • Technical Specifications
      • Platform Support Guide for Jedox Software
      • Hardware Requirements
      • Software Requirements
      • In-Memory DB Memory Requirements
      • Additional Requirements for Linux
      • Limits of Jedox Software Components
      • GPU Accelerator Requirements
      • Jedox Production Cloud - Hardware Specifications
      • Jedox Mobile Requirements
      • Systems Supported by Jedox Integrator
  • Installation
    • Windows Installation
    • Updating a Jedox Installation in Windows
    • Linux Installation
    • Updating a Jedox Installation in Linux
    • Excel Add-in Installation (Client Only)
    • Jedox Web Sandbox
    • Silent Setup for Automated Software Distribution
    • Setup Command Line Parameters
    • Cross-Version Compatibility of Jedox Components
    • Java Installation Updates and Changes
    • SAP Connector
      • Installing SAP Java Connector (JCo)
      • Installing Jedox Integrator Add-on SAP
      • Installing SAP Transport Packages
    • Further Jedox Applications
      • GPU Accelerator Installation
      • R Installation
      • R Installation of External Packages
      • Supervision Server Installation
    • Configuration
      • Administration Panel
      • Configuration Files
      • Check for Updates
      • Performance Monitor
      • Configuring palo.ini for the In-Memory DB
      • Cache Setting of Jedox In-Memory DB
      • Guidelines for Virtualization in Jedox
      • Scaling Jedox
        • Scaling Jedox
        • Clustering Jedox with Two Machines
        • Clustering Jedox with Five Machines
        • Guidelines for Virtualization in Jedox
      • Jedox Web Services and Configuration
        • Web Services and Configurations
        • Default Web Services Configuration
        • Turning off Password Storage in the Login Browser
        • Changing the Maximum Memory of Tomcat Service
        • Accessing the Jedox In-Memory DB from Client Machines
        • Timeout for In-Memory DB (OLAP) Requests
        • Additional Spreadsheet Server Configuration
        • Configuring the Text Metrics Engine
      • Jedox Web Settings
        • Overview of Jedox Web Settings
        • File and Folder Settings in Jedox Web
        • Adjusting Email Notification Settings
        • Adjusting the Paging Display in OLAP Dimension Dialogs
        • Cache Behavior of Jedox Web Spreadsheets
        • Spreadsheet Calculation in Jedox Web
        • Adjusting the Login Screen
        • Increasing Print Quality of Widgets in PDFs
    • Server Migration
      • Server Migration (OS Windows)
      • Server Migration (Linux)
  • Excel Add-in
    • First Steps
      • Quickstart with Jedox Excel Add-in
      • Jedox Ribbon in Jedox Excel Add-in
      • Options Dialog in Excel Add-in
      • Connection Wizard in Excel Add-in
      • Password Management in Jedox Excel Add-in
    • Special Topics
      • Shortcuts in Excel Add-in
      • Snapshot and OLAP Snapshot
      • Offline Mode for Excel Workbooks
      • Jedox Web buttons in Jedox Ribbon
      • Formatting Cells in Excel Add-in
      • Excel Add-in COM Interface
      • Office Add-in
      • Configuring Log Levels in Excel Add-in
      • Configuring Longer Processing Times
      • Solutions for Restrictions in Excel Add-in
      • Floating Point Precision in Jedox
    • Data Import/Export
      • Import Options Overview
      • Import from Flat Textfiles
      • Import from ODBC Sources
      • Import from Other Cubes
      • Import with Internal Loops
      • Import to Delete Elements
      • Import to Rename Elements
      • Import Errors
      • Data-Driven Modeling in Excel Add-in
        • Data-Driven Modeling in Excel Add-in
        • Data-Driven Modeling Exercise
        • Preparing Source Data for Data-Driven Modeling
  • Jedox Web
    • First Steps
      • Quickstart with Jedox Web
      • Jedox Web File Administration
      • Report Designer
      • Jedox Spreadsheet Basics
      • Designer Mode and User Mode
      • Description of Reports
      • Options Dialog in Jedox Web
    • Data Import/Export
      • Importing and Exporting Various File Types
      • PB Files
      • WSS Files
      • Exporting / Importing XLSX Files in Jedox Web
      • Creating PDF and HTML Files
      • Data-Driven Modeling
        • Data-Driven Modeling in Jedox Web
        • Preparing Source Data for Data-Driven Modeling
    • Charts
      • Insert - Chart
      • Advanced Chart Properties
      • Line Chart Examples
      • Stock Chart Examples
      • Meter Chart Examples
      • Bubble Chart Example
      • XY Scatter Chart Examples
      • Insert - SUCCESS Chart
      • Inserting a Micro Chart
      • Legacy Charts Conversion
    • Selected Spreadsheet Commands
      • Jedox Web Spreadsheets - FAQ
      • UI & Menu
        • Query Menu (formerly Jedox Menu)
        • ComboBoxes, Lists, CheckBoxes, Buttons, DatePicker, and Labels
      • Data & Data Sources
        • Data - Refresh, Auto-Refresh, Auto-Calculate
        • Data - Validation
        • Data Sources for Data Validation, DynaRanges, ComboBoxes, and Lists
      • Functions
        • HYPERLINK Function
        • LOCALIZE function
        • INFO Function
      • Adding Elements to the Spreadsheet
        • Inserting Functions
        • Inserting Pictures
        • Inserting Hyperlinks
        • DynaRanges
      • Formatting
        • Formatting Cells
        • Conditional Formatting
    • Special Topics
      • Shortcuts and Special Commands in Jedox Spreadsheets
      • Automatic Saving of Jedox Spreadsheets
      • Rules for Names of Folders, Workbooks, Worksheets and Ranges
      • Comments Panel
      • Comments in Jedox Spreadsheet cells
      • Tags
      • Jedox Analyzer Report
      • Creating and Using Hyperlinks as Files
      • Printing of Reports Exported to HTML
      • Notes to Jedox Spreadsheets
      • Jedox Spreadsheet Functions
      • Generating a Batch PDF
      • Enabling IN PREVIEW UI features in Jedox Web
      • Floating Point Precision in Jedox
    • Macro Engine
      • Macro Engine Overview
      • Macro Examples
      • Macro Engine Configuration
      • External Libraries in the Macro Engine
  • In-Memory Database
    • Service, File Locations, and APIs
      • In-Memory DB Service
      • Locations of Files and Databases on Windows
      • Storing Zero Values
      • Jedox OLAP HTTP API and Server Browser
      • PHP API for Jedox In-Memory DB
      • Java API for Jedox In-Memory DB
    • Business Rules
      • Business Rules Overview
      • Rule Editor
      • Supported Functions for Rules
      • Rule Engines
        • Rule Engines in Jedox
        • Data-Driven Engine
        • Rule Engine Statistics
      • Advanced Topics for Rules
        • Rule Templates
        • Query Types for the Creation of Rule Templates
        • Access Rights in Rules
        • Markers
        • Cell Tracer
        • Rule Upgrade Troubleshooting
        • Floating Point Precision in Jedox
    • Supervision Server
      • Supervision Server (SVS)
      • Supervision Server Installation
      • Functional Description of Supervision Server
      • Supervision Server Event Handlers
      • Functions Specific to Supervision Server
      • Supervision Server Samples
      • Supervision Server for Drilldown and Drillthrough
      • SVS Cube Supervisor
      • SVS Login Supervisor
    • 3rd-Party Access
      • 3rd Party Access: ODBO/XMLA
      • 3rd Party Access/MDX: Needed Address Changes
      • 3rd Party Access/MDX: Use with Excel 2007/2010
      • Jedox 3rd Party Access/MDX: Use with Excel 2013/2016
      • 3rd Party Access/MDX: Supported Schemas and Defined Syntax Elements
      • 3rd Party Access/MDX: Provided Functions
      • 3rd Party Access/MDX: Supported Statements
    • GPU Accelerator
      • GPU Accelerator Installation
      • Using the Jedox GPU Accelerator
      • GPU Accelerator Requirements
      • GPU Accelerator Advisor
      • Jedox GPU Accelerator FAQ
  • Cloud
    • Cloud Overview
    • General Information
      • Jedox Production Cloud - FAQ
      • Jedox Production Cloud - Regional Availability
      • Time Zones in Jedox
      • Jedox Cloud Trial
    • Technical Information
      • Jedox Production Cloud - Hardware Specifications
      • Connecting a Jedox Cloud Environment to On-premises SAP Systems
      • Setting Up an SFTP Connection to a Jedox Production Cloud
      • Jedox Cloud Console
    • Cloud Services
      • Disaster Recovery - Extended Business Continuity
      • Virtual Private Network Gateway
      • Single Sign-On (SSO)
      • Web Application Firewall (WAF)
      • Cloud-based Relational Databases
    • Status and Events
      • Jedox Cloud Status
      • Jedox Cloud Events
  • Jedox Mobile
    • Introduction to Jedox Mobile
    • Jedox Mobile Requirements
    • Installing Jedox Mobile Client
    • Jedox Mobile Client Login Options
    • Jedox Mobile Navigation
    • Tags in Jedox Mobile
    • Mobile Reports & Documents
    • Access Rights for Jedox Mobile
    • Settings for Jedox Mobile
    • Jedox Mobile - Security
    • Jedox Mobile FAQ
  • Modeling
    • Modeler Overview
    • Modeler Shortcuts
    • Managing Databases in Modeler
    • Naming Conventions in Jedox
    • Advanced Database Properties
    • Internationalization of Databases
    • Database Scripts
    • Dimensions
      • Managing Dimensions in Modeler
      • Dimension Overview
      • Creation and Handling of Dimension Elements
      • Copying and Pasting Elements in Dimensions
      • Sorting and Filtering Elements in Dimensions
      • Default Elements in Dimensions
      • Creating and Handling Attributes
      • Dimension Interfaces
      • Time Editor
      • Dynamic Views - Styles and Formats
    • Cubes
      • Managing Cubes in Modeler
      • Adding Business Logic to Cubes
      • Using Semi-Additive Measures
      • Cube Interfaces
      • Flexible Cube Layout
  • Reporting
    • Hyperlinks to Reports
    • Reports as Homepages
    • Ad hoc Reporting
      • Creating a Jedox View
      • Paste View Dialog
      • Paste View Options
      • Stored Views
      • Using Subsets in Jedox Views
      • Detaching Jedox Views
      • Drillthrough in Jedox Views
    • Custom Reports
      • Description of Paste Elements
      • Using Paste Elements
      • Jedox Data Functions
        • Jedox Spreadsheet Functions
        • Jedox / PALO OLAP Functions
        • Paste Data Function
        • PALO.DATA(): Why are there Different Functions?
    • Subsets
      • Subset Editor Overview
      • Attribute Tab in the Subset Editor
      • Data Tab in the Subset Editor
      • Sort Tab in the Subset Editor
      • Manual Editing of Subset Editor Expressions
      • Saving Subsets
      • Insert a Subset in the Area of an Existing Subset
      • Subset Example: Top-Ten Analysis
      • Subset Example: ABC Turnover Analysis
      • Subset Example: Base Subset
    • Dynamic Web Reporting
      • Changing the Visibility of Objects
      • Example: Report with ComboBox and DynaRanges
      • Example: Report with List and DynaRanges
      • Example: Report with ComboBoxes and two interdependent vertical DynaRanges
      • Working with Named Ranges and Variables
      • About Variable Mapping
      • Example: Report with Variables
      • Passing Commands to Embedded Reports
      • Description of a Frameset
      • Example: Frameset
      • ODBC Connections in Jedox Web Spreadsheets
    • Widgets
      • Widgets Overview
      • Creating a New Widget
      • Defining Widget Code
      • Reading and Setting Values in a Worksheet with Widgets
      • Increasing Print Quality of Widgets in PDFs
  • Planning / Data Entry
    • Basics
      • Entering Values Manually
      • Copying Values into a Cube
      • Deleting Data
      • Reverting Data Entries (Undo)
      • Setting Holds and Using the Hold Manager
      • Audit Information
      • Zero Suppression
    • Data Distribution – Splashing
      • Splashing: Data Entry on Consolidated Cells
      • Splash Parameter #
      • Splash Parameter !
      • Splashing Commands
      • Splashing Command: Copy
      • Splashing Command: Like
      • Jedox Planning Assistant: Overview
      • Planning Assistant: Splashing
      • Planning Assistant: Copy
      • Planning Assistant: Like
      • Planning Assistant: Linear Regression
      • Planning Assistant: Transfer and Reallocate
      • Planning Assistant: Hold
  • Integrator
    • Jedox Integrator: First Steps
    • Systems Supported by Jedox Integrator
    • Integrator Monitor
    • Jedox Integrator Samples
    • Connections
      • Connections Overview
      • Locations for File-based Connections
      • Global Connections
      • Access File Connection
      • CosmosDB Connection
      • DB2 Connection
      • Derby Connection
      • Directory Connection
      • ExcelFile Connection
      • File (CSV) Connection
      • JDBC Connection
      • H2 Connection
      • Hadoop with Hive Connection
      • HyperSQL DataBase (HSQLDB) Connection
      • Ingres Connection
      • Jedox OLAP Connection
      • Jedox XMLA Connection
      • JSON File Connection
      • LDAP Connection
      • Lucanet Connection
      • MaxDB Connection
      • Microsoft SQL Server Connection
      • MongoDB Connection
      • MySQL Connection
      • OAuthToken Connection
      • Oracle Connection
      • PostgreSQL Connection
      • PowerBI Connection
      • Qlik Connection
      • Qlik QVX File Connection
      • REST Connection
      • Salesforce Connection
      • SOAP (WSDL) Connection
      • SQLite Connection
      • Tableau Server Connection
      • Tableau TDE File Connection
      • XML File Connection
    • Extracts
      • Extracts Overview
      • Calendar Extract
      • Constant Table Extract
      • Constant Tree Extract
      • CosmosSQL Extract
      • Count Extract
      • Cube Extract
      • Cube Slice Extract
      • Dimension Extract
      • Excel Extract
      • File Extract
      • JSON Extract
      • LDAP Extract
      • Metadata Extract
      • MongoDB Extract
      • Qlik Extract
      • Relational Extract
      • Relational Table Extract
      • Rule Extract
      • SalesforceObject Extract
      • SalesforceSOQL Extract
      • XML Extract
      • XmlTree Extract
    • Transforms
      • Transforms Overview
      • Field List Transform
      • Field Normalization Transform
      • RScript Transform
      • Field Transform
      • FieldTransform Functions
        • Field Transform Functions Overview
        • Aggregation Function
        • Column Aggregation Function
        • Concatenation Function
        • DateDuration Function
        • DateFormat Function
        • Groovy Function
        • Java Function
        • JavaScript Function
        • LastNonEmpty Function
        • Lookup Function
        • LookupInterval Function
        • Map Function
        • NumberFormat Function
        • OlapData Function
        • Previous Function
        • Replace Function
        • RowNumber Function
        • Split Function
        • SubString Function
        • Switch Function
        • UpperLower Function
      • Table Transforms
        • TableAggregation Transform
        • TableDenormalization Transform
        • TableJoin Transform
        • TableLoop Transform
        • TableNormalization Transform
        • TableUnion Transform
        • TableView Transform
      • Tree Transforms
        • Overview of Tree Formats
        • Tree Element Transform
        • Tree FH Transform
        • Tree Join Transform
        • Tree LE Transform
        • Tree NC Transform
        • Tree PC Transform
        • Tree View Transform
    • Loads
      • Loads Overview
      • Cube Load
      • Cube Load with Drillthrough
      • CubeSliceCopy Load
      • Dimension Load
      • Excel Load
      • File Load
      • Jedox Database Load
      • JSON Load
      • PowerBI Load
      • Qlik Load
      • Qlik QVX File Load
      • Relational Load
      • Relational SQL Load
      • Rule Load
      • Salesforce Load
      • Tableau TDE File Load
      • XML Load
      • XmlTree Load
    • Jobs
      • Jobs Overview
      • Standard Job
      • External job
      • Groovy Job
      • JavaScript Job
      • Loop Job
      • Parallel Job
      • Switch Job
    • Special Topics
      • Changing the Maximum Memory of Tomcat Service
      • Accessing Network Files
      • Accessing the SOAP API of Jedox Integrator from PHP
      • Changing Passwords with Groovy in Integrator
      • Caching in Extracts and Transforms
      • Command-Line-Client Parameters
      • Integrator Configuration
      • Generating Project Documentation
      • Handling of NULL Values in Jedox Integrator
      • Integrator Command-Line Client
      • Integrator Scripting API
      • Integrator Server SOAP API
      • Integrator Variables
      • Migration of Integrator Projects
      • Reachability of files for Integrator operations
      • Using Integrator for Database Backup
      • Removing Unused Integrator Components
      • Protection of Internal Databases
      • Security of Script Jobs and Functions
      • Restricting Access to FileSystem Directories
    • SAP Connector
      • SAP Connector Overview
      • SAP Components Supported by Jedox SAP Connector
      • SAP Connector Requirements
      • SAP Connection
      • SAP HANA Connection
      • SAPBalanceSheet Extract
      • SAPBICube Extract
      • SAPBIDataStore Extract
      • SAPBIHierarchy Extract
      • SAPBIMaster Extract
      • SAPERPHierarchy Extract
      • SAPGenericRFC Extract
      • SAPProject Extract
      • SAPTable Extract
      • Filtering with SAP Connector
      • SAP Authorizations
      • SNC Configuration for SAP
      • SAP Transport Packages
      • SAP Connector FAQ
  • Security
    • Jedox Security Overview
    • User Login and Password Management
    • Session Management of Jedox In-Memory DB
    • Database System Cubes
    • Deactivating Users, Roles, and Groups
    • Encryption
    • Generating an Encrypted URL for a Report
    • Jedox Web Connections
    • User Authentication with External Directory Services
    • Admin User Account
    • Integrator Security
      • Protection of Internal Databases
      • Security of Script Jobs and Functions
      • Restricting Access to FileSystem Directories
    • Rights in Jedox
      • Rights Objects in Jedox
      • Administration of User Rights
      • Access Rights for Server-Wide Objects (Level 1)
      • Access Rights for Databases (Level 2)
      • Access Rights Within Specific Databases (Level 3)
      • Rights with Impact on Jedox Web
      • Rights with Impact on Jedox Integrator
    • Secure Communication Between Clients and Servers
      • Encryption: Technical Information
      • Encrypting Jedox Web (HTTPS)
      • Encrypting Jedox In-Memory DB
      • Encrypting Connections in Excel Add-in and Jedox Web Environment
      • Encrypting a Standalone Installation
    • User Authentication with SSO
      • SSO (Single Sign On) Overview
      • SSO Configuration of Jedox Server on Windows
      • SSO Configuration of Jedox Server on Linux
      • SSO Authorization Mode
      • SSO Authentication Mode
      • SSO Configuration of a Browser as a Jedox Web Client
      • SSO Configuration for Excel Add-in
      • SSO Technical Information
      • Certificate for Communication with Jedox Marketplace
      • SAML Authentication in Jedox
      • LDAPS
      • Hardening Jedox
  • Maintenance
    • License Management
      • Jedox Licenses
      • License Activation in Jedox
      • Automatic Assignment of Licenses
      • Assigning Licenses, Deleting Assignments, and Removing Licenses in Jedox Web
      • License Management FAQ
    • Jedox Backup Handling
      • Using Integrator for Database Backup
      • Database Backup
      • Downloading a Database
      • Backing Up Jedox Supervision Server Files
      • Backing Up Jedox Web
      • Backing Up all Jedox Data with Batch Files
      • Restoring a Backup
      • Rights for Downloading/Restoring Databases
      • Scheduling Database Backup
    • Scheduler
      • Scheduler Overview
      • Scheduling a Task as a Batch PDF
      • Scheduling Database Backup
      • Scheduling Tasks as Integrator Jobs
      • Scheduler Trigger Types
      • Scheduler Storage Types
      • Configuring and Using E-mail Templates in the Scheduler
      • Scheduler Task Status Codes
    • Further Topics
      • Start/Stop on Linux
      • Jedox OS Integration on RHEL/CentOS Linux
      • Jedox Database Files
      • General Information about Logs
      • Jedox SDK
      • Request Profiler
  • Services
    • Jedox Support Portal
    • Jedox Marketplace
  • Models
    • AIssisted Prediction Preview for Sales Planning
    • Jedox Models Overview
    • Models (Platform)
    • Installation of Premium Models
    • Model Lifecycle and Updates
    • Financial Consolidation Model Overview
    • Profit & Loss Model
      • Profit and Loss Model Overview
      • Technical Documentation
        • Database
          • Profit and Loss Cube
          • Daily Exchange Rates Cube
          • Exchange Rates Cube
          • Fact Cube Using Currency Conversion
          • _WF Task Assignments (Customer) Cube
        • Business Logic
          • Version Blending
          • KPI Calculations (by Version) for Profit and Loss Cube
          • Previous Year
          • Currency Conversion
          • Integration of Detail-Planning Cubes (Profit and Loss Cube)
          • Semi-Additive Measures (Profit and Loss Model)
        • Interfaces
          • Import Exchange Rates Interfaces
        • Reports
          • Start Page
          • Profit and Loss Actual Report
          • Profit and Loss Forecast Report
          • Profit and Loss Mid-Term Planning Report
          • Profit and Loss Budget Report
          • Profit and Loss Legal Entity Breakdown Report
          • Profit and Loss Time Series Report
        • Administration Reports
          • Legal Entity Administration Report
          • Exchange Rates Report
          • Profit and Loss Forecast Initialization Report
          • Import Exchange Rates Report
      • Tasks
        • Setup
          • Getting Started with the Profit and Loss Model
          • Setting Up the Profit and Loss Model
        • Configuration
          • Profit & Loss Cube
            • PnL Account Dimension
          • Currency Conversion
            • Setting Up the Available Source Currencies
            • Setting Up the Target Currencies
            • Configuration of Conversion Types
            • Setting Up Additional Conversion Types
            • Conversion from Implicit Local Currency
            • Conversion from Explicit Source Currency
            • Comparison of Currency Conversions
            • Synchronizing Exchange Rates in Forecast and Budget Versions
            • Exchange Rates
            • Scaling Amounts in Reports
            • Turn Off Currency Conversion
          • Other
            • Start Page Configuration
            • Configuring Design Elements
            • Version Dimension
            • Month Dimension
            • Day Dimension
            • Legal Entity Dimension
    • Cost Center Model
      • Cost Center Model Overview
      • Technical Documentation
        • Database
          • Daily Exchange Rates Cube
          • Exchange Rates Cube
          • Fact Cube Using Currency Conversion
          • Cost Center Cube
          • _WF Task Definition Cube
          • _WF Task Assignments (Cost Center) Cube
          • _WF Status (Cost Center) Cube
          • _WF Task Dimension
          • _WF Activity Dimension
        • Business Logic
          • Version Blending
          • Previous Year
          • Currency Conversion
          • KPI Calculations (by Version) for Cost Center Cube
          • Integration of Detail-Planning Cubes (Cost Center Cube)
          • Semi-Additive Measures (Cost Center Model)
          • Workflow in the Cost Center Model
        • Interfaces
          • Import Exchange Rates Interfaces
        • Reports
          • Start Page
          • Cost Center Actual Report
          • Cost Center Forecast Report
          • Cost Center Mid-Term Planning Report
          • Cost Center Budget Report
          • Cost Center Legal Entity Breakdown Report
          • Cost Center Time Series Report
        • Administration Reports
          • Legal Entity Administration Report
          • Exchange Rates Report
          • Import Exchange Rates Report
          • Cost Center Forecast Initialization Report
          • Workflow Detail
          • Workflow Task
      • Tasks
        • Setup
          • Getting Started with the Cost Center Model
          • Setting Up the Cost Center Model
        • Configuration
          • Cost Center Cube
            • Cost Center Dimension
            • Cost Type Dimension
          • Currency Conversion
            • Setting Up the Available Source Currencies
            • Setting Up the Target Currencies
            • Configuration of Conversion Types
            • Setting Up Additional Conversion Types
            • Conversion from Implicit Local Currency
            • Conversion from Explicit Source Currency
            • Comparison of Currency Conversions
            • Synchronizing Exchange Rates in Forecast and Budget Versions
            • Exchange Rates
            • Scaling Amounts in Reports
            • Turn Off Currency Conversion
          • Other
            • Start Page Configuration
            • Configuring Design Elements
            • Version Dimension
            • Month Dimension
            • Day Dimension
            • Legal Entity Dimension
            • Assigning Activities to User Groups
    • Sales Model
      • Sales Model Overview
      • Technical Documentation
        • Database
          • Daily Exchange Rates Cube
          • Exchange Rates Cube
          • Fact Cube Using Currency Conversion
          • _WF Task Definition Cube
          • _WF Task Dimension
          • _WF Activity Dimension
          • Sales Cube
          • Sales Planning Cube
          • Sales Order Backlog Cube
          • _WF Task Assignments (Customer) Cube
          • _WF Status (Customer) Cube
        • Business Logic
          • Version Blending
          • Previous Year
          • Currency Conversion
          • KPI Calculations (by Version) for Sales Cube
          • KPI Calculations (by Version) for Sales Planning Cube
          • KPI Calculations for Sales Order Backlog Cube
          • Semi-Additive Measures (Sales Model)
          • Workflow in the Sales Model
        • Interfaces
          • Import Exchange Rates Interfaces
        • Reports
          • Start Page
          • Sales Actual Report
          • Sales Mid-Term Planning Report
          • Sales Gross Earnings Report
          • Sales Gross Revenue Report
          • Sales Commission Report
          • Sales Costs and Contribution Margin Report
          • Sales Order Backlog Report
          • Sales Legal Entity Breakdown Report
          • Sales Time Series
        • Administration Reports
          • Legal Entity Administration Report
          • Exchange Rates Report
          • Import Exchange Rates Report
          • Workflow Administration Report
          • Workflow Detail
          • Workflow Task
          • Sales Forecast Initialization Report
      • Tasks
        • Setup
          • Getting Started with the Sales Model
          • Setting Up the Sales Model
        • Configuration
          • Sales Planning Cube
            • Sales Planning_measure Dimension
          • Sales Cube
            • Article Dimension
            • Customer Dimension
            • Sales Channel Dimension
            • Sales_measure Dimension
          • Currency Conversion
            • Setting Up the Available Source Currencies
            • Setting Up the Target Currencies
            • Configuration of Conversion Types
            • Setting Up Additional Conversion Types
            • Conversion from Implicit Local Currency
            • Conversion from Explicit Source Currency
            • Comparison of Currency Conversions
            • Synchronizing Exchange Rates in Forecast and Budget Versions
            • Exchange Rates
            • Scaling Amounts in Reports
            • Turn Off Currency Conversion
          • Sales Order Backlog Cube
            • Sales Order Status Dimension
            • Sales Order Backlog_measure Dimension
          • Other
            • Start Page Configuration
            • Configuring Design Elements
            • Version Dimension
            • Month Dimension
            • Day Dimension
            • Legal Entity Dimension
            • Assigning Activities to User Groups
    • Human Resources Model
      • Human Resources Model Overview
      • Technical Documentation
        • Database
          • _WF Task Definition Cube
          • _WF Task Assignments (Cost Center) Cube
          • _WF Status (Cost Center) Cube
          • _WF Task Dimension
          • _WF Activity Dimension
          • _WF Task Assignments (Customer) Cube
          • Personnel Costs Cube
          • Personnel Cost Parameters Cube
        • Business Logic
          • Version Blending
          • Previous Year
          • Workflow in the Human Resources Model
          • KPI Calculations (by Version) for Personnel Costs Cube
          • Semi-Additive Measures (Human Resources Model)
        • Reports
          • Start Page
          • Human Resources Actual Report
          • Human Resources Mid-Term Planning Report
          • Human Resources Headcount Report
          • Human Resources Wages and Salaries Report
          • Human Resources Parameters Report
          • Human Resources Non-Wage Labour Costs Report
          • Human Resources Legal Entity Breakdown Report
          • Human Resources Time Series Report
        • Administration Reports
          • Legal Entity Administration Report
          • Workflow Detail
          • Workflow Task
      • Tasks
        • Setup
          • Getting Started with the Human Resources Model
          • Setting Up the Human Resources Model
        • Configuration
          • Personnel Costs Cube
            • Cost Center Dimension
            • Employee Dimension
            • Personnel Costs_measure Dimension
          • Personnel Cost Parameters Cube
            • Region Dimension
            • Employee Category Dimension
            • Personnel Cost Parameters_measure Dimension
          • Other
            • Start Page Configuration
            • Configuring Design Elements
            • Version Dimension
            • Month Dimension
            • Legal Entity Dimension
            • Assigning Activities to User Groups
    • Balance Sheet Model
      • Balance Sheet Model Overview
      • Technical Documentation
        • Database
          • Daily Exchange Rates Cube
          • Exchange Rates Cube
          • Fact Cube Using Currency Conversion
          • Balance Sheet Cube
        • Business Logic
          • Version Blending
          • Previous Year
          • KPI Calculations (by Version) for Balance Sheet Cube
          • Currency Conversion (Balance Sheet & Projected Balance Sheet Models)
          • Integration of Detail-Planning Cubes (Balance Sheet Cube)
          • Semi-Additive Measures (Balance Sheet & Projected Balance Sheet Models)
          • Debit Credit Shift
        • Interfaces
          • Import Exchange Rates Interfaces
        • Reports
          • Balance Sheet Actual Report
          • Balance Sheet Forecast Report
          • Balance Sheet Mid-Term Planning Report
          • Balance Sheet Budget Report
          • Balance Sheet Legal Entity Breakdown Report
          • Balance Sheet Time Series Report
          • Cash Flow Forecast Report
          • Cash Flow Time Series Report
        • Administration Reports
          • Legal Entity Administration Report
          • Exchange Rates Report
          • Import Exchange Rates Report
          • Balance Sheet Initialization Report
      • Tasks
        • Setup
          • Getting Started with the Balance Sheet Model
          • Setting Up the Balance Sheet Model
        • Configuration
          • Balance Sheet Cube
            • BS Account Dimension
            • Transaction Type Dimension
          • Currency Conversion
            • Setting Up the Available Source Currencies
            • Setting Up the Target Currencies
            • Configuration of Conversion Types
            • Setting Up Additional Conversion Types
            • Conversion from Implicit Local Currency
            • Conversion from Explicit Source Currency
            • Comparison of Currency Conversions
            • Synchronizing Exchange Rates in Forecast and Budget Versions
            • Exchange Rates
            • Scaling Amounts in Reports
            • Turn Off Currency Conversion
          • Other
            • Start Page Configuration
            • Configuring Design Elements
            • Version Dimension
            • Month Dimension
            • Day Dimension
            • Legal Entity Dimension
    • Cash Flow Model
      • Cash Flow Model Overview
      • Technical Documentation
        • Database
          • Daily Exchange Rates Cube
          • Exchange Rates Cube
          • Fact Cube Using Currency Conversion
          • Cash Flow Cube
          • Cash Flow Mapping Cube
          • Cash Flow Calculation Cube
        • Business Logic
          • Version Blending
          • Previous Year
          • KPI Calculations for Cash Flow Cube
          • Currency Conversion (Cash Flow Model)
          • Integration of Detail-Planning Cubes (Cash Flow Cube)
          • Semi-Additive Measures (Cash Flow Cube)
          • Sign Standard (Cash Flow)
        • Interfaces
          • Import Exchange Rates Interfaces
        • Reports
          • Start Page
          • Cash Flow Actual Report
          • Cash Flow Forecast Report
          • Cash Flow Mid-Term Planning Report
          • Cash Flow Budget Report
        • Administration Reports
          • Legal Entity Administration Report
          • Exchange Rates Report
          • Import Exchange Rates Report
          • Cash Flow Mapping Report
      • Tasks
        • Setup
          • Getting Started with the Cash Flow Model
          • Setting Up the Cash Flow Model
        • Configuration
          • Cash Flow Cube
            • CF Account Dimension
          • Currency Conversion
            • Setting Up the Available Source Currencies
            • Setting Up the Target Currencies
            • Configuration of Conversion Types
            • Setting Up Additional Conversion Types
            • Conversion from Implicit Local Currency
            • Conversion from Explicit Source Currency
            • Comparison of Currency Conversions
            • Synchronizing Exchange Rates in Forecast and Budget Versions
            • Exchange Rates
            • Scaling Amounts in Reports
            • Turn Off Currency Conversion
          • Other
            • Start Page Configuration
            • Configuring Design Elements
            • Version Dimension
            • Month Dimension
            • Day Dimension
            • Legal Entity Dimension
    • Projected Balance Sheet Model
      • Projected Balance Sheet Model Overview
      • Technical Documentation
        • Database
          • Balance Sheet Cube
          • Projection Configuration Cube
        • Business Logic
          • Actions on Journal Entries
          • Posting Journal
          • Projection
        • Interfaces
          • Import Exchange Rates Interfaces
        • Reports
          • Start Page
          • Projected Balance Sheet Actual Report
          • Projected Balance Sheet Forecast Report
          • Projected Balance Sheet Mid-Term Planning Report
          • Projected Balance Sheet Budget Report
          • Projected Balance Sheet Legal Entity Breakdown Report
          • Projected Balance Sheet Time Series Report
          • Projected Balance Sheet Posting Journal
          • Projected Balance Sheet Posting Journal Details
        • Administration Reports
          • Projected Balance Sheet Projection Configuration
          • Projected Balance Sheet PnL Account Configuration
          • Projected Balance Sheet Initialization Report
      • Tasks
        • Setup
          • Getting Started with the Projected Balance Sheet Model
          • Setting Up the Projected Balance Sheet Model
        • Configuration
          • Projection Configuration Cube
            • Batch Procedure Configuration Dimension (Projected Balance Sheet Model)
          • Balance Sheet Cube
            • Posting Journal Configuration Dimension
          • Currency Conversion
            • Setting Up the Target Currencies
          • Other
            • Start Page Configuration
    • Profit Center Model
      • Profit Center Model Overview
      • Technical Documentation
        • Database
          • Daily Exchange Rates Cube
          • Exchange Rates Cube
          • Fact Cube Using Currency Conversion
          • Profit Center Cube
          • Allocation Configuration Cube
        • Business Logic
          • Version Blending
          • Previous Year
          • Currency Conversion
          • Actions on Journal Entries
          • Posting Journal
          • KPI Calculations (by Version) for Profit Center Cube
          • Integration of Detail-Planning Cubes (Profit Center Cube)
          • Semi-Additive Measures (Profit Center Model)
          • Allocation
        • Interfaces
          • Import Exchange Rates Interfaces
        • Reports
          • Start Page
          • Profit Center Actual Report
          • Profit Center Forecast Report
          • Profit Center Budget Report
          • Profit Center Profit Center Breakdown Report
          • Profit Center Cost Objects Breakdown Report
          • Profit Center Posting Journal
        • Administration Reports
          • Legal Entity Administration Report
          • Exchange Rates Report
          • Import Exchange Rates Report
          • Profit Center Allocation Step
      • Tasks
        • Setup
          • Getting Started with the Profit Center Model
          • Setting Up the Profit Center Model
        • Configuration
          • Profit Center Cube
            • Posting Journal Configuration Dimension
            • Partner Entity Dimension
            • Profit Center Dimension
            • Partner Profit Center Dimension
            • Cost Object Dimension
            • Partner Cost Object Dimension
            • PC Account Dimension
          • Allocation Configuration Cube
            • Batch Procedure Configuration Dimension (Profit Center Model)
          • Currency Conversion
            • Setting Up the Available Source Currencies
            • Setting Up the Target Currencies
            • Configuration of Conversion Types
            • Setting Up Additional Conversion Types
            • Conversion from Implicit Local Currency
            • Conversion from Explicit Source Currency
            • Comparison of Currency Conversions
            • Synchronizing Exchange Rates in Forecast and Budget Versions
            • Exchange Rates
            • Scaling Amounts in Reports
          • Other
            • Configuring Design Elements
            • Version Dimension
            • Month Dimension
            • Day Dimension
            • Legal Entity Dimension
    • Workflow Building Block
      • Workflow Building Block Overview
      • Technical Documentation
        • Database
          • _WF Activity Dimension
          • _WF Task Dimension in Custom Applications
          • _WF Task Assignments Cube (Custom Application)
          • _WF Status Cube (Custom Application)
        • Business Logic
          • Workflow in Custom Applications
        • Reports
          • My Workflow Activities
        • Administation Reports
          • Workflow Wizard
          • Workflow Administration Report
      • Tasks
        • Setup
          • Getting Started with the Workflow Building Block
          • Setting Up Workflow Building Block
        • Configuration
          • Adding Workflow Building Block to Custom Planning Reports
          • Adding Keys to Custom Application Settings
    • Financial Consolidation Model
      • Technical Documentation
        • Database
          • Profit and Loss Cube (Financial Consolidation)
          • Cash Flow Cube (Financial Consolidation)
          • Exchange Rates_YTD Cube
          • Daily Exchange Rates Cube
          • Cash Flow Mapping Cube
          • Scope of Consolidation Cube
        • Administration Reports
          • Exchange Rates
          • Cash Flow Mapping Report
          • Scope of Consolidation Report
        • Business Logic
          • KPI Calculations (by Version) for Balance Sheet Cube
          • KPI Calculations for Cash Flow Cube
          • KPI Calculations (by Version) for Profit Center Cube
      • Tasks
        • Configuration
          • Currency Conversion
            • Setting Up the Available Source Currencies
            • Configuration of Conversion Types
            • Setting Up Additional Conversion Types
            • Conversion from Implicit Local Currency
            • Conversion from Explicit Source Currency
            • Comparison of Currency Conversions
            • Synchronizing Exchange Rates in Forecast and Budget Versions
            • Exchange Rates
            • Scaling Amounts in Reports
          • Balance Sheet Cube
            • BS Account (Financial Consolidation)
            • Transaction Type Dimension (Financial Consolidation)
          • Profit and Loss Cube
            • PnL Account Dimension (Financial Consolidation)
          • Cash Flow Cube
            • CF Account Dimension (Financial Consolidation)
          • Other
            • Partner Entity Dimension (Financial Consolidation)
            • Legal Entity Dimension (Financial Consolidation)
            • Scope Dimension
            • Configuring Design Elements
            • Version Dimension
            • Day Dimension
            • Month_YTD Dimension

News at Jedox

Internal Resources - Forum.jedox.com

Newsletter

Resources

  • Jedox Blog
  • Online Courses
  • Jedox Academy
  • Free Trial

Solutions

  • Finance
  • Sales, HR & More
  • Integrated Planning
  • Enterprise Planning

Information

  • Jedox Marketplace
  • Legal
  • Jedox Trust
  • Known Issues
© Copyright Jedox AG
Current version: Jedox 2019.4