Thank you for supporting the Cloud Customer Connect Community in 2024. It's a gift to work with you!

Look back
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

in Planning 13 comments

Summary:

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)

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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