Skip to Content

how to run delete on SQLscript based planning functions

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

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

3 Answers

  • Best Answer
    Dec 23, 2016 at 08:20 PM

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

    Add comment
    10|10000 characters needed characters exceeded

  • Dec 26, 2016 at 09:07 AM

    nice smart and simple work around ... Thanks Gersh

    Add comment
    10|10000 characters needed characters exceeded

  • Dec 26, 2016 at 02:55 PM

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

    Add comment
    10|10000 characters needed characters exceeded