cancel
Showing results for 
Search instead for 
Did you mean: 

how to run delete on SQLscript based planning functions

rmuhuri
Participant
0 Kudos

Embedded BPC on HANA allows SQL script based Planning functions . How can one implement a delete function ?

Accepted Solutions (1)

Accepted Solutions (1)

former_member200327
Active Contributor
0 Kudos

You make all key figures = 0 in your SQL script and then run compression with zero-elimination.

Answers (2)

Answers (2)

former_member200327
Active Contributor
0 Kudos

This is not a workaround - this is how it's supposed to work. You never delete records from the cube directly.

rmuhuri
Participant
0 Kudos

nice smart and simple work around ... Thanks Gersh