Tools for Creating Metadata for Analytic Workspaces. The CWM2 Write APIs create metadata for analytic workspaces. Analytic Workspace Manager and Oracle Warehouse Builder implement the CWM2 Write APIs when enabling for the BI Beans, or you can use these APIs directly in a program such as SQL*Plus. The metadata for analytic workspaces is stored in the CWM2 Read APIs, which are available to applications through union views.