Help Desk

Submit a ticket My Tickets
Welcome
Login

Clear Data

Looking to better understand the OAC Clear Data command in OneCloud. If I were to do what I want directly in Essbase, I would say Cleardata Budget; 

I assume I will pick Data Region as the option. and I assume the MDX region should be set to Budget, but it is giving an error.  Do I need to format the MDX?

  • I looked in the logs, and it appears OneCloud sent an ASO Clear Region command which failed as it is BSO...

  • If you are trying to interact with a BSO cube, consider using the Calculation Script Command.  You could write the clear calc in Essbase and save it as a .csc and then invoke it from OneCloud. 

    https://support.onecloud.io/support/solutions/articles/48000981076-oracle-analytics-cloud-command-reference#calculation-script 

  • Absolutely an option, already on it, but it would be helpful if the documentation stated that it is only for ASO cubes.

Login to post a comment