Can we clear data using Maxl in ASO cube ? — 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
Get Started with Redwood: Oracle Cloud SCM and Purchasing

Can we clear data using Maxl in ASO cube ?

edited Aug 2, 2018 2:36AM in Essbase 2 comments

Summary

Can we clear data using Maxl in ASO cube ?

Content

Hi Team,

I am trying to clear the data for &CurrentYear->&CurrentMnth in ASO cube using Maxl script.

I tried the following

alter database 'APP_NAME'.'DATABASE_NAME' clear data in region '{[&FcstYr]}' physical; and it worked by clearing the entire data for '&cstYr'.

After the above step I tried the following by including '&CurrentMnth' but it is giving me syntax error

alter database 'KLXTEST'.'KLXTEST' clear data in region '{[&FcstYr],[&FcstMth]}' physical;

Can anyone please help me ?

Thanks

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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