Reports in the GLOBAL Schema Folder: This screen capture of Analytic Workspace Manager shows the navigation tree on the left and the report on the right.

The tree shows the following:

Databases folder (expanded)

olap112 (global) - OLAP 11g folder (expanded)

• Schemas folder (expanded)

  • GLOBAL schema folder (expanded)

    • Analytic Workspaces folder (collapsed)

    • My Tables folder (with the button icon, expanded)

      ACCOUNT (selected)

      CHANNEL_DIM

      CUSTOMER_DIM

      PRICE_FACT

      PRODUCT_CHILD_PARENT

      PRODUCT_DIM

      TIME_DIM

      UNITS_FACT

      AW$GLOBAL

      CB$CHANNEL_PRIMARY

      CB$CUSTOMER_SHIPMENTS

      CB$CUSTOMER_MARKET

      CB$PRODUCT_PRIMARY

      CB$TIME_CALENDAR

      CB$TIME_FISCAL

      CB$UNITS_CUBE

      CR$UNITS_CUBE

  • Data Security Roles

• Reports

• My SQL Reports

The report shows the query, SELECT column_name, data_type FROM all_tab_columns WHERE. The remainder of the SELECT statement, which is owner = ? and table_name = ?, is not visible. The query results are:

• COLUMN_NAME column: ACCOUNT_ID, FIRSTNAME, LASTNAME, ADDRESS, ADDRESS2, CITY, STATE_PROV, COUNTRY, ZIP_PC, PHONE, FAX, EMAIL.

• DATA_TYPE column: VARCHAR2 for all rows.