The simplest way to execute OLAP DML statement is by using the OLAP Worksheet. The OLAP Worksheet is delivered as part of the Analytic Workspace Manager. To open the OLAP worksheet from within the Analytic Workspace Manager:
Connect to an Oracle Database.
Select a Schema.
Select Tools, then OLAP Worksheet.
You can also execute OLAP DML statements from with SQL and Java:
Using the PL/SQL DBMS_AW package you can execute OLAP DML statements as described in "Embedding OLAP DML in SQL Statements".
Using SPL_Executor delivered as part of Oracle OLAP Java API you can embed OLAP DML statements within a Java program. See Oracle OLAP Java API Reference for more information.