Skip to Main Content
Jedox Ideas

Let us know how we can make Jedox even better!

Status Already exists
Workspace Jedox Platform
Categories Integrator
Created by Guest
Created on Sep 27, 2021

New ETL Cube Load Mode - Insert (Fresh)

Would like this mode to initially clear cube of all values and then act like insert. Update doesn't work when you have have the load process looped (in my case I loop the process on a year-by-year basis).

  • ADMIN RESPONSE
    Dec 21, 2021

    Thanks for the idea. In cases were mode "update" is not feasible, this can already be accomplished in Jedox by using a cube or cube slice extract that results in a load with mode "delete". This load would then be used before the cube load that uses mode "insert".

  • Attach files
  • Guest
    Reply
    |
    Sep 29, 2021

    why not using delete with a CubeSlice prior to loading the data