What's new in Customer Journeys?

Connect and learn more! ×
Clearing of partial data failed ASO cube with groovy — Cloud Customer Connect
You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

Clearing of partial data failed ASO cube with groovy

Received Response
in Planning 11 comments


Clearing of partial data failed: Syntax error in input MDX query

Content (please ensure you mask any confidential information):

hi all,

trying to clear partial data in ASO cube using this script

/*create cube connection*/

Cube cube = operation.getApplication().getCube('ITBPLN')

/* run clear - true will result in a physical clear aka MISSING */

cube.clearPartialData("Crossjoin(Crossjoin(Crossjoin(Crossjoin(Crossjoin(Crossjoin(Crossjoin(Crossjoin(Crossjoin(Crossjoin(Crossjoin(Crossjoin(Crossjoin({[BegBalance]}), {[FY23]}), {([Jumlah],[Tarif.],[TotalAmount])}), {[Current]}), {[Working]}), {[No_C1]}), {Descendants([Total Sub Satuan Akuntansi], [Total Sub Satuan Akuntansi].dimension.Levels(0))}), {Descendants([Total Sumber Dana], [Total Sumber Dana].dimension.Levels(0))}), {Descendants([Total Kegiatan], [Total Kegiatan].dimension.Levels(0))}), {Descendants([4000], [4000].dimension.Levels(0))}), {Descendants([Total Sub Akun], [Total Sub Akun].dimension.Levels(0))}), {Descendants([ITB Tarif], [ITB Tarif].dimension.Levels(0))}), {Descendants([Satuan Akuntansi], [Satuan Akuntansi].dimension.Levels(0))})",true)

Howdy, Stranger!

Log In

To view full details, sign in.


Don't have an account? Click here to get started!