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
Apr 5, 2024
We have reevaluated this idea. While we cannot commit to a specific target version, we will consider adding it to our future internal backlog. If you can add further information about the context of this feature, please add it here so we can evaluate it more fully.
I still can not find a quick way to clear cube using cube slice extract. The quickest way is to just clear cube using modeller. But to reproduce that using cube slice extract it seems to take a very long time. Unless I have missed something, I still think an extra option for cube loading is "fresh"...which is like "update" but starting from a clean (empty) cube is preferable. Also, you don't need to add in an extra process in the ETL that way.
I still can not find a quick way to clear cube using cube slice extract. The quickest way is to just clear cube using modeller. But to reproduce that using cube slice extract it seems to take a very long time. Unless I have missed something, I still think an extra option for cube loading is "fresh"...which is like "update" but starting from a clean (empty) cube is preferable. Also, you don't need to add in an extra process in the ETL that way.
why not using delete with a CubeSlice prior to loading the data