You can clear the contents of an alias table, and you can delete an alias table from an outline. You can clear, but cannot delete, the Default alias table.
To clear or delete alias tables:
Open the outline in edit mode and select the Properties tab.
Under the Alias tables node, right-click an alias table, and select one of the following:
Clear: Clears the contents of the table but does not delete the table itself.
Delete: Deletes the alias table.
At the confirmation prompt, click Yes.
To clear or delete all alias tables:
Select the Properties tab.
Right-click the Alias tables node and select Clear all tables or Delete all tables.
At the confirmation prompt, click Yes.
“Setting Aliases” in the Oracle Essbase Database Administrator's Guide
“Working with Alias Table Language Codes” in the Oracle Essbase Database Administrator's Guide
query database (MaxL) in the Oracle Essbase Technical Reference