Skip to Content
avatar image
Rajarshi Muhuri

how to run delete on SQLscript based planning functions

Dec 21, 2016 at 05:37 PM | 88 Views

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

BW SAP HANA Data Warehousing
SAP Business Planning and Consolidation, version for SAP NetWeaver
Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

3 Answers

  • Best Answer
    avatar image
    Gersh Voldman
    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

  • avatar image
    Rajarshi Muhuri
    Dec 26, 2016 at 09:07 AM

    nice smart and simple work around ... Thanks Gersh

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Gersh Voldman
    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