Modifying the Content of a Report: 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 (collapsed)

  • Reports folder (collapsed)

  • My SQL Reports folder (expanded)

    • My User Tables report

    • My User Views folder

      CHANNEL_PRIMARY_VIEW
      CHANNEL_VIEW
      CUSTOMER_MARKET_VIEW (selected)
      CUSTOMER_SHIPMENTS_VIEW
      CUSTOMER_VIEW
      PRICE_CUBE_VIEW
      PRODUCT_PRIMARY_VIEW
      PRODUCT_VIEW
      TIME_CALENDAR_VIEW
      TIME_FISCAL_VIEW
      TIME_VIEW
      UNITS_CUBE_VIEW
      

The report shows the query, SELECT * FROM user_tab_columns WHERE table_name = ?, and the query results:

• TABLE_NAME column: CUSTOMER_MARKET_VIEW for all rows.

• COLUMN_NAME column: DIM_KEY, LEVEL_NAME, MEMBER_TYPE, DIM_ORDER, HIER_ORDER, LONG_DESCRIPTION, SHORT_DESCRIPTION, TOTAL_LONG_DESCRIPTION, TOTAL_LONG_DESCRIPTION1, MARKET_SEGMENT_LONG_DESC, MARKET_SEGMENT_LONG_DE_1, ACCOUNT_LONG_DESCRIPTION, ACCOUNT_LONG_DESCRIPTI_1, SHIP_TO_LONG_DESCRIPTION, SHIP_TO_LONG_DESCRIPTI_1, PARENT, DEPTH, TOTAL, CUSTOMER_TOTAL_ID, MARKET_SEGMENT, CUSTOMER_MARKET_SEGMENT_, ACCOUNT, CUSTOMER_ACCOUNT_ID, SHIP_TO, CUSTOMER_SHIP_TO_ID.

• DATA_TYPE column: NUMBER for DIM_ORDER, HIER_ORDER, and DEPTH, and VARCHAR2 for all other rows.

• The other columns in the report do not appear in the figure.