CLEARDATA command in Essbase

CLEARDATA:
CLEARDATA command clears data values from the database and sets them to #MISSING.
CLEARDATA does not work if placed in IF statement.
CLEARDATA can only clear a section of a database, not clears or removes entire block.
SYNTAX:
CLEARDATA  mbrname; (mbr name can be a single member or combination of members)
EX:
1.CLEARDATA India; (clears india data)
2.CLEARDATA India ->sales; (clears sales data for india)
3.FIX(Actual)
   CLEARDATA "electronics";
   ENDFIX               (it only clears the electronics block, but not remove the block)