Skip to Main Content
Jedox Ideas

Let us know how we can make Jedox even better!

Status Planned
Workspace Jedox Platform
Categories Integrator
Created by Guest
Created on Apr 14, 2022

Incremental Jedox Data Driven Modeling in Excel

Scenario: User has created dimensions and cubes using Jedox DDM though add-in in month 1. In the next month there are few more new dimension elements and additional cube data which needs to be added to the database.
Challenge: the user is comfortable with the DDM template and do not want to upload multiple excel sheets for 10+ dimensions and cube.

Pain: Jedox DDM in excel supports one-time database/dimension/cube creation after which any incremental changes to dimension or cubes have to be done individually.

Solution: Jedox DDM should have the capability to perform incremental/delta uploads to existing dimensions and cubes (assuming the hierarchical relationships in dimensions are intact) and the cube load mode is 'Add'