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

Can we clear data using Maxl in ASO cube ?

Received Response
9
Views
2
Comments
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!