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

How to clear partial data in ASO Reporting Cube via Groovy when Aggregation Views are enabled?

in Planning 1 comment

Hi everyone,

I'm working on an Oracle EPM Cloud Planning application (version 26.05) and I need to clear partial data from an ASO reporting cube before running a series of Plan Type Map push data jobs.

Context:

  • Source cube: BSO (FS)
  • Target cube: ASO (REPORT)
  • The clear needs to cover specific dimensions from a Data Map scope
  • Some dimensions need to be cleared at level 0 (e.g. Entity, Brand, Category) and one dimension (Scenario) is a parent member with many children at level 0

What I've tried:

  1. executeCalcScript with CLEARBLOCK/CLEARDATA — fails because these are BSO-only commands
  2. clearPartialData with ILvl0Descendants — fails with
Tagged:

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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