Clearing ASO cube on RTPs with Groovy
Summary:
I am new to EPBCS and Groovy. I have a requirement to clear partial data from ASO cube by users on recurring basis. I am trying to write a business rule which users can run to clear partial data from ASO on select RTPs. I am using clearPartialData but not able to pass RTPs to the MDX query.
Any Idea?
Content (required):
Version (include the version you are using, if applicable):
Code Snippet (add any code snippets that support your topic, if applicable):
/* RTPS: {RTP_Periods} */
String sPeriod = rtps.RTP_Periods.toString()
Cube cube = operation.getApplication().getCube('ASO')
cube.clearPartialData('Crossjoin(Crossjoin(Crossjoin(Crossjoin({[${